eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_ITEM_PROPERTIES_PKG dependencies on FND_API

Line 81: IF FND_API.To_Boolean(l_key_exists) THEN

77: 'F',
78: l_rowid,
79: l_key_exists);
80:
81: IF FND_API.To_Boolean(l_key_exists) THEN
82: RAISE Item_Exists_Error;
83: END IF;
84: /*B1319565 Added for Technical Parameters */
85: INSERT INTO gr_item_properties

Line 124: IF FND_API.To_Boolean(l_key_exists) THEN

120: 'F',
121: l_rowid,
122: l_key_exists);
123:
124: IF FND_API.To_Boolean(l_key_exists) THEN
125: x_rowid := l_rowid;
126: ELSE
127: RAISE Row_Missing_Error;
128: END IF;

Line 132: IF FND_API.To_Boolean(p_commit) THEN

128: END IF;
129:
130: /* Check the commit flag and if set, then commit the work. */
131:
132: IF FND_API.To_Boolean(p_commit) THEN
133: COMMIT WORK;
134: END IF;
135:
136: EXCEPTION

Line 147: IF FND_API.To_Boolean(p_called_by_form) THEN

143: 'GR_FOREIGN_KEY_ERROR');
144: FND_MESSAGE.SET_TOKEN('TEXT',
145: l_msg_data,
146: FALSE);
147: IF FND_API.To_Boolean(p_called_by_form) THEN
148: APP_EXCEPTION.Raise_Exception;
149: ELSE
150: x_msg_data := FND_MESSAGE.Get;
151: END IF;

Line 163: IF FND_API.To_Boolean(p_called_by_form) THEN

159: 'GR_RECORD_EXISTS');
160: FND_MESSAGE.SET_TOKEN('CODE',
161: l_msg_token,
162: FALSE);
163: IF FND_API.To_Boolean(p_called_by_form) THEN
164: APP_EXCEPTION.Raise_Exception;
165: ELSE
166: x_msg_data := FND_MESSAGE.Get;
167: END IF;

Line 179: IF FND_API.To_Boolean(p_called_by_form) THEN

175: 'GR_NO_RECORD_INSERTED');
176: FND_MESSAGE.SET_TOKEN('CODE',
177: l_msg_token,
178: FALSE);
179: IF FND_API.To_Boolean(p_called_by_form) THEN
180: APP_EXCEPTION.Raise_Exception;
181: ELSE
182: x_msg_data := FND_MESSAGE.Get;
183: END IF;

Line 196: IF FND_API.To_Boolean(p_called_by_form) THEN

192: 'GR_UNEXPECTED_ERROR');
193: FND_MESSAGE.SET_TOKEN('TEXT',
194: l_msg_token,
195: FALSE);
196: IF FND_API.To_Boolean(p_called_by_form) THEN
197: APP_EXCEPTION.Raise_Exception;
198: ELSE
199: x_msg_data := FND_MESSAGE.Get;
200: END IF;

Line 292: IF FND_API.To_Boolean(p_commit) THEN

288: END IF;
289:
290: /* Check the commit flag and if set, then commit the work. */
291:
292: IF FND_API.To_Boolean(p_commit) THEN
293: COMMIT WORK;
294: END IF;
295:
296: EXCEPTION

Line 307: IF FND_API.To_Boolean(p_called_by_form) THEN

303: 'GR_FOREIGN_KEY_ERROR');
304: FND_MESSAGE.SET_TOKEN('TEXT',
305: l_msg_data,
306: FALSE);
307: IF FND_API.To_Boolean(p_called_by_form) THEN
308: APP_EXCEPTION.Raise_Exception;
309: ELSE
310: x_msg_data := FND_MESSAGE.Get;
311: END IF;

Line 322: IF FND_API.To_Boolean(p_called_by_form) THEN

318: 'GR_NO_RECORD_INSERTED');
319: FND_MESSAGE.SET_TOKEN('CODE',
320: l_msg_token,
321: FALSE);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;
324: ELSE
325: x_msg_data := FND_MESSAGE.Get;
326: END IF;

Line 338: IF FND_API.To_Boolean(p_called_by_form) THEN

334: 'GR_UNEXPECTED_ERROR');
335: FND_MESSAGE.SET_TOKEN('TEXT',
336: l_msg_token,
337: FALSE);
338: IF FND_API.To_Boolean(p_called_by_form) THEN
339: APP_EXCEPTION.Raise_Exception;
340: ELSE
341: x_msg_data := FND_MESSAGE.Get;
342: END IF;

Line 414: IF FND_API.To_Boolean(p_commit) THEN

410: RAISE No_Data_Found_Error;
411: END IF;
412: CLOSE c_lock_item_properties;
413:
414: IF FND_API.To_Boolean(p_commit) THEN
415: COMMIT WORK;
416: END IF;
417:
418: EXCEPTION

Line 428: IF FND_API.To_Boolean(p_called_by_form) THEN

424: 'GR_RECORD_NOT_FOUND');
425: FND_MESSAGE.SET_TOKEN('CODE',
426: l_msg_token,
427: FALSE);
428: IF FND_API.To_Boolean(p_called_by_form) THEN
429: APP_EXCEPTION.Raise_Exception;
430: ELSE
431: x_msg_data := FND_MESSAGE.Get;
432: END IF;

Line 440: IF FND_API.To_Boolean(p_called_by_form) THEN

436: x_return_status := 'E';
437: x_oracle_error := APP_EXCEPTION.Get_Code;
438: FND_MESSAGE.SET_NAME('GR',
439: 'GR_ROW_IS_LOCKED');
440: IF FND_API.To_Boolean(p_called_by_form) THEN
441: APP_EXCEPTION.Raise_Exception;
442: ELSE
443: x_msg_data := FND_MESSAGE.Get;
444: END IF;

Line 456: IF FND_API.To_Boolean(p_called_by_form) THEN

452: 'GR_UNEXPECTED_ERROR');
453: FND_MESSAGE.SET_TOKEN('TEXT',
454: l_msg_token,
455: FALSE);
456: IF FND_API.To_Boolean(p_called_by_form) THEN
457: APP_EXCEPTION.Raise_Exception;
458: ELSE
459: x_msg_data := FND_MESSAGE.Get;
460: END IF;

Line 539: IF FND_API.TO_Boolean(p_commit) THEN

535: WHERE rowid = p_rowid;
536:
537: /* Check the commit flag and if set, then commit the work. */
538:
539: IF FND_API.TO_Boolean(p_commit) THEN
540: COMMIT WORK;
541: END IF;
542:
543: EXCEPTION

Line 549: IF FND_API.To_Boolean(p_called_by_form) THEN

545: WHEN Check_Integrity_Error THEN
546: ROLLBACK TO SAVEPOINT Delete_Row;
547: x_return_status := l_return_status;
548: x_oracle_error := l_oracle_error;
549: IF FND_API.To_Boolean(p_called_by_form) THEN
550: APP_EXCEPTION.Raise_Exception;
551: ELSE
552: x_msg_data := FND_MESSAGE.Get;
553: END IF;

Line 564: IF FND_API.To_Boolean(p_called_by_form) THEN

560: 'GR_RECORD_NOT_FOUND');
561: FND_MESSAGE.SET_TOKEN('CODE',
562: l_msg_token,
563: FALSE);
564: IF FND_API.To_Boolean(p_called_by_form) THEN
565: APP_EXCEPTION.Raise_Exception;
566: ELSE
567: x_msg_data := FND_MESSAGE.Get;
568: END IF;

Line 581: IF FND_API.To_Boolean(p_called_by_form) THEN

577: 'GR_UNEXPECTED_ERROR');
578: FND_MESSAGE.SET_TOKEN('TEXT',
579: l_msg_token,
580: FALSE);
581: IF FND_API.To_Boolean(p_called_by_form) THEN
582: APP_EXCEPTION.Raise_Exception;
583: ELSE
584: x_msg_data := FND_MESSAGE.Get;
585: END IF;

Line 665: IF FND_API.To_Boolean(p_commit) THEN

661: AND label_code = p_label_code;
662: END IF;
663: END IF;
664:
665: IF FND_API.To_Boolean(p_commit) THEN
666: COMMIT WORK;
667: END IF;
668:
669: EXCEPTION

Line 679: IF FND_API.To_Boolean(p_called_by_form) THEN

675: 'GR_NULL_VALUE');
676: FND_MESSAGE.SET_TOKEN('CODE',
677: l_msg_token,
678: FALSE);
679: IF FND_API.To_Boolean(p_called_by_form) THEN
680: APP_EXCEPTION.Raise_Exception;
681: ELSE
682: x_msg_data := FND_MESSAGE.Get;
683: END IF;

Line 695: IF FND_API.To_Boolean(p_called_by_form) THEN

691: 'GR_UNEXPECTED_ERROR');
692: FND_MESSAGE.SET_TOKEN('TEXT',
693: l_msg_token,
694: FALSE);
695: IF FND_API.To_Boolean(p_called_by_form) THEN
696: APP_EXCEPTION.Raise_Exception;
697: ELSE
698: x_msg_data := FND_MESSAGE.Get;
699: END IF;

Line 750: IF NOT FND_API.To_Boolean(l_key_exists) THEN

746: 'F',
747: l_rowid,
748: l_key_exists);
749:
750: IF NOT FND_API.To_Boolean(l_key_exists) THEN
751: l_return_status := 'E';
752: l_msg_token := l_msg_token || ' ' || p_item_code;
753: END IF;
754:

Line 763: IF NOT FND_API.To_Boolean(l_key_exists) THEN

759: 'F',
760: l_rowid,
761: l_key_exists);
762:
763: IF NOT FND_API.To_Boolean(l_key_exists) THEN
764: l_return_status := 'E';
765: l_msg_token := l_msg_token || ' ' || p_label_code;
766: END IF;
767:

Line 776: IF NOT FND_API.To_Boolean(l_key_exists) THEN

772: 'F',
773: l_rowid,
774: l_key_exists);
775:
776: IF NOT FND_API.To_Boolean(l_key_exists) THEN
777: l_return_status := 'E';
778: l_msg_token := l_msg_token || ' ' || p_property_id;
779: END IF;
780:

Line 864: IF FND_API.To_Boolean(p_called_by_form) THEN

860: 'GR_UNEXPECTED_ERROR');
861: FND_MESSAGE.SET_TOKEN('TEXT',
862: l_msg_data,
863: FALSE);
864: IF FND_API.To_Boolean(p_called_by_form) THEN
865: APP_EXCEPTION.Raise_Exception;
866: ELSE
867: x_msg_data := FND_MESSAGE.Get;
868: END IF;

Line 927: IF FND_API.To_Boolean(p_called_by_form) THEN

923: 'GR_UNEXPECTED_ERROR');
924: FND_MESSAGE.SET_TOKEN('TEXT',
925: l_msg_data,
926: FALSE);
927: IF FND_API.To_Boolean(p_called_by_form) THEN
928: APP_EXCEPTION.Raise_Exception;
929: END IF;
930:
931: END Check_Primary_Key;