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_INV_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: INSERT INTO gr_inv_item_properties
85: (organization_id,

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 301: IF FND_API.To_Boolean(p_commit) THEN

297: END IF;
298:
299: /* Check the commit flag and if set, then commit the work. */
300:
301: IF FND_API.To_Boolean(p_commit) THEN
302: COMMIT WORK;
303: END IF;
304:
305: EXCEPTION

Line 316: IF FND_API.To_Boolean(p_called_by_form) THEN

312: 'GR_FOREIGN_KEY_ERROR');
313: FND_MESSAGE.SET_TOKEN('TEXT',
314: l_msg_data,
315: FALSE);
316: IF FND_API.To_Boolean(p_called_by_form) THEN
317: APP_EXCEPTION.Raise_Exception;
318: ELSE
319: x_msg_data := FND_MESSAGE.Get;
320: END IF;

Line 331: IF FND_API.To_Boolean(p_called_by_form) THEN

327: 'GR_NO_RECORD_INSERTED');
328: FND_MESSAGE.SET_TOKEN('CODE',
329: l_msg_token,
330: FALSE);
331: IF FND_API.To_Boolean(p_called_by_form) THEN
332: APP_EXCEPTION.Raise_Exception;
333: ELSE
334: x_msg_data := FND_MESSAGE.Get;
335: END IF;

Line 347: IF FND_API.To_Boolean(p_called_by_form) THEN

343: 'GR_UNEXPECTED_ERROR');
344: FND_MESSAGE.SET_TOKEN('TEXT',
345: l_msg_token,
346: FALSE);
347: IF FND_API.To_Boolean(p_called_by_form) THEN
348: APP_EXCEPTION.Raise_Exception;
349: ELSE
350: x_msg_data := FND_MESSAGE.Get;
351: END IF;

Line 423: IF FND_API.To_Boolean(p_commit) THEN

419: RAISE No_Data_Found_Error;
420: END IF;
421: CLOSE c_lock_item_properties;
422:
423: IF FND_API.To_Boolean(p_commit) THEN
424: COMMIT WORK;
425: END IF;
426:
427: EXCEPTION

Line 437: IF FND_API.To_Boolean(p_called_by_form) THEN

433: 'GR_RECORD_NOT_FOUND');
434: FND_MESSAGE.SET_TOKEN('CODE',
435: l_msg_token,
436: FALSE);
437: IF FND_API.To_Boolean(p_called_by_form) THEN
438: APP_EXCEPTION.Raise_Exception;
439: ELSE
440: x_msg_data := FND_MESSAGE.Get;
441: END IF;

Line 449: IF FND_API.To_Boolean(p_called_by_form) THEN

445: x_return_status := 'E';
446: x_oracle_error := APP_EXCEPTION.Get_Code;
447: FND_MESSAGE.SET_NAME('GR',
448: 'GR_ROW_IS_LOCKED');
449: IF FND_API.To_Boolean(p_called_by_form) THEN
450: APP_EXCEPTION.Raise_Exception;
451: ELSE
452: x_msg_data := FND_MESSAGE.Get;
453: END IF;

Line 465: IF FND_API.To_Boolean(p_called_by_form) THEN

461: 'GR_UNEXPECTED_ERROR');
462: FND_MESSAGE.SET_TOKEN('TEXT',
463: l_msg_token,
464: FALSE);
465: IF FND_API.To_Boolean(p_called_by_form) THEN
466: APP_EXCEPTION.Raise_Exception;
467: ELSE
468: x_msg_data := FND_MESSAGE.Get;
469: END IF;

Line 547: IF FND_API.TO_Boolean(p_commit) THEN

543: WHERE rowid = p_rowid;
544:
545: /* Check the commit flag and if set, then commit the work. */
546:
547: IF FND_API.TO_Boolean(p_commit) THEN
548: COMMIT WORK;
549: END IF;
550:
551: EXCEPTION

Line 557: IF FND_API.To_Boolean(p_called_by_form) THEN

553: WHEN Check_Integrity_Error THEN
554: ROLLBACK TO SAVEPOINT Delete_Row;
555: x_return_status := l_return_status;
556: x_oracle_error := l_oracle_error;
557: IF FND_API.To_Boolean(p_called_by_form) THEN
558: APP_EXCEPTION.Raise_Exception;
559: ELSE
560: x_msg_data := FND_MESSAGE.Get;
561: END IF;

Line 572: IF FND_API.To_Boolean(p_called_by_form) THEN

568: 'GR_RECORD_NOT_FOUND');
569: FND_MESSAGE.SET_TOKEN('CODE',
570: l_msg_token,
571: FALSE);
572: IF FND_API.To_Boolean(p_called_by_form) THEN
573: APP_EXCEPTION.Raise_Exception;
574: ELSE
575: x_msg_data := FND_MESSAGE.Get;
576: END IF;

Line 589: IF FND_API.To_Boolean(p_called_by_form) THEN

585: 'GR_UNEXPECTED_ERROR');
586: FND_MESSAGE.SET_TOKEN('TEXT',
587: l_msg_token,
588: FALSE);
589: IF FND_API.To_Boolean(p_called_by_form) THEN
590: APP_EXCEPTION.Raise_Exception;
591: ELSE
592: x_msg_data := FND_MESSAGE.Get;
593: END IF;

Line 676: IF FND_API.To_Boolean(p_commit) THEN

672: AND label_code = p_label_code;
673: END IF;
674: END IF;
675:
676: IF FND_API.To_Boolean(p_commit) THEN
677: COMMIT WORK;
678: END IF;
679:
680: EXCEPTION

Line 690: IF FND_API.To_Boolean(p_called_by_form) THEN

686: 'GR_NULL_VALUE');
687: FND_MESSAGE.SET_TOKEN('CODE',
688: l_msg_token,
689: FALSE);
690: IF FND_API.To_Boolean(p_called_by_form) THEN
691: APP_EXCEPTION.Raise_Exception;
692: ELSE
693: x_msg_data := FND_MESSAGE.Get;
694: END IF;

Line 706: IF FND_API.To_Boolean(p_called_by_form) THEN

702: 'GR_UNEXPECTED_ERROR');
703: FND_MESSAGE.SET_TOKEN('TEXT',
704: l_msg_token,
705: FALSE);
706: IF FND_API.To_Boolean(p_called_by_form) THEN
707: APP_EXCEPTION.Raise_Exception;
708: ELSE
709: x_msg_data := FND_MESSAGE.Get;
710: END IF;

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

779: 'F',
780: l_rowid,
781: l_key_exists);
782:
783: IF NOT FND_API.To_Boolean(l_key_exists) THEN
784: l_return_status := 'E';
785: l_msg_token := l_msg_token || ' ' || p_label_code;
786: END IF;
787:

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

792: 'F',
793: l_rowid,
794: l_key_exists);
795:
796: IF NOT FND_API.To_Boolean(l_key_exists) THEN
797: l_return_status := 'E';
798: l_msg_token := l_msg_token || ' ' || p_property_id;
799: END IF;
800:

Line 884: IF FND_API.To_Boolean(p_called_by_form) THEN

880: 'GR_UNEXPECTED_ERROR');
881: FND_MESSAGE.SET_TOKEN('TEXT',
882: l_msg_data,
883: FALSE);
884: IF FND_API.To_Boolean(p_called_by_form) THEN
885: APP_EXCEPTION.Raise_Exception;
886: ELSE
887: x_msg_data := FND_MESSAGE.Get;
888: END IF;

Line 950: IF FND_API.To_Boolean(p_called_by_form) THEN

946: 'GR_UNEXPECTED_ERROR');
947: FND_MESSAGE.SET_TOKEN('TEXT',
948: l_msg_data,
949: FALSE);
950: IF FND_API.To_Boolean(p_called_by_form) THEN
951: APP_EXCEPTION.Raise_Exception;
952: END IF;
953:
954: END Check_Primary_Key;