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_DOC_STATUSES_PKG dependencies on FND_API

Line 80: IF FND_API.To_Boolean(l_key_exists) THEN

76: 'F',
77: l_rowid,
78: l_key_exists);
79:
80: IF FND_API.To_Boolean(l_key_exists) THEN
81: RAISE Item_Exists_Error;
82: END IF;
83:
84: INSERT INTO gr_item_doc_statuses

Line 122: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 130: IF FND_API.To_Boolean(p_commit) THEN

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

Line 145: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 161: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 177: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 194: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 289: IF FND_API.To_Boolean(p_commit) THEN

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

Line 304: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 319: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 335: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 411: IF FND_API.To_Boolean(p_commit) THEN

407: RAISE No_Data_Found_Error;
408: END IF;
409: CLOSE c_lock_item_doc_statuses;
410:
411: IF FND_API.To_Boolean(p_commit) THEN
412: COMMIT WORK;
413: END IF;
414:
415: EXCEPTION

Line 425: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 437: IF FND_API.To_Boolean(p_called_by_form) THEN

433: x_return_status := 'E';
434: x_oracle_error := APP_EXCEPTION.Get_Code;
435: FND_MESSAGE.SET_NAME('GR',
436: 'GR_ROW_IS_LOCKED');
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 453: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 536: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 546: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 561: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 578: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 648: IF FND_API.To_Boolean(p_commit) THEN

644: WHERE document_code = p_document_code;
645: END IF;
646: END IF;
647:
648: IF FND_API.To_Boolean(p_commit) THEN
649: COMMIT WORK;
650: END IF;
651:
652: EXCEPTION

Line 662: IF FND_API.To_Boolean(p_called_by_form) THEN

658: 'GR_NULL_VALUE');
659: FND_MESSAGE.SET_TOKEN('CODE',
660: l_msg_token,
661: FALSE);
662: IF FND_API.To_Boolean(p_called_by_form) THEN
663: APP_EXCEPTION.Raise_Exception;
664: ELSE
665: x_msg_data := FND_MESSAGE.Get;
666: END IF;

Line 678: IF FND_API.To_Boolean(p_called_by_form) THEN

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

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

729: 'F',
730: l_rowid,
731: l_key_exists);
732:
733: IF NOT FND_API.To_Boolean(l_key_exists) THEN
734: l_return_status := 'E';
735: l_msg_token := l_msg_token || ' ' || p_item_code;
736: END IF;
737:

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

742: 'F',
743: l_rowid,
744: l_key_exists);
745:
746: IF NOT FND_API.To_Boolean(l_key_exists) THEN
747: l_return_status := 'E';
748: l_msg_token := l_msg_token || ' ' || p_document_code;
749: END IF;
750:

Line 834: IF FND_API.To_Boolean(p_called_by_form) THEN

830: 'GR_UNEXPECTED_ERROR');
831: FND_MESSAGE.SET_TOKEN('TEXT',
832: l_msg_data,
833: FALSE);
834: IF FND_API.To_Boolean(p_called_by_form) THEN
835: APP_EXCEPTION.Raise_Exception;
836: ELSE
837: x_msg_data := FND_MESSAGE.Get;
838: END IF;

Line 894: IF FND_API.To_Boolean(p_called_by_form) THEN

890: 'GR_UNEXPECTED_ERROR');
891: FND_MESSAGE.SET_TOKEN('TEXT',
892: l_msg_data,
893: FALSE);
894: IF FND_API.To_Boolean(p_called_by_form) THEN
895: APP_EXCEPTION.Raise_Exception;
896: END IF;
897:
898: END Check_Primary_Key;