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

Line 143: IF FND_API.To_Boolean(l_key_exists) THEN

139: 'F',
140: l_rowid,
141: l_key_exists);
142:
143: IF FND_API.To_Boolean(l_key_exists) THEN
144: RAISE Label_Exists_Error;
145: END IF;
146:
147: INSERT INTO gr_document_structures

Line 253: IF FND_API.To_Boolean(l_key_exists) THEN

249: 'F',
250: l_rowid,
251: l_key_exists);
252:
253: IF FND_API.To_Boolean(l_key_exists) THEN
254: x_rowid := l_rowid;
255: x_current_seq := l_current_seq;
256: ELSE
257: RAISE Row_Missing_Error;

Line 262: IF FND_API.To_Boolean(p_commit) THEN

258: END IF;
259:
260: /* Check the commit flag and if set, then commit the work. */
261:
262: IF FND_API.To_Boolean(p_commit) THEN
263: COMMIT WORK;
264: END IF;
265:
266: EXCEPTION

Line 277: IF FND_API.To_Boolean(p_called_by_form) THEN

273: 'GR_FOREIGN_KEY_ERROR');
274: FND_MESSAGE.SET_TOKEN('TEXT',
275: l_msg_data,
276: FALSE);
277: IF FND_API.To_Boolean(p_called_by_form) THEN
278: APP_EXCEPTION.Raise_Exception;
279: ELSE
280: x_msg_data := FND_MESSAGE.Get;
281: END IF;

Line 292: IF FND_API.To_Boolean(p_called_by_form) THEN

288: 'GR_RECORD_EXISTS');
289: FND_MESSAGE.SET_TOKEN('CODE',
290: p_document_structures_seqno ,
291: FALSE);
292: IF FND_API.To_Boolean(p_called_by_form) THEN
293: APP_EXCEPTION.Raise_Exception;
294: ELSE
295: x_msg_data := FND_MESSAGE.Get;
296: END IF;

Line 308: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 324: IF FND_API.To_Boolean(p_called_by_form) THEN

320: 'GR_UNEXPECTED_ERROR');
321: FND_MESSAGE.SET_TOKEN('TEXT',
322: l_msg_data,
323: FALSE);
324: IF FND_API.To_Boolean(p_called_by_form) THEN
325: APP_EXCEPTION.Raise_Exception;
326: ELSE
327: x_msg_data := FND_MESSAGE.Get;
328: END IF;

Line 510: IF FND_API.To_Boolean(p_commit) THEN

506: END IF;
507:
508: /* Check the commit flag and if set, then commit the work. */
509:
510: IF FND_API.To_Boolean(p_commit) THEN
511: COMMIT WORK;
512: END IF;
513:
514: EXCEPTION

Line 525: IF FND_API.To_Boolean(p_called_by_form) THEN

521: 'GR_FOREIGN_KEY_ERROR');
522: FND_MESSAGE.SET_TOKEN('TEXT',
523: l_msg_data,
524: FALSE);
525: IF FND_API.To_Boolean(p_called_by_form) THEN
526: APP_EXCEPTION.Raise_Exception;
527: ELSE
528: x_msg_data := FND_MESSAGE.Get;
529: END IF;

Line 541: IF FND_API.To_Boolean(p_called_by_form) THEN

537: 'GR_NO_RECORD_INSERTED');
538: FND_MESSAGE.SET_TOKEN('CODE',
539: l_msg_data,
540: FALSE);
541: IF FND_API.To_Boolean(p_called_by_form) THEN
542: APP_EXCEPTION.Raise_Exception;
543: ELSE
544: x_msg_data := FND_MESSAGE.Get;
545: END IF;

Line 557: IF FND_API.To_Boolean(p_called_by_form) THEN

553: 'GR_UNEXPECTED_ERROR');
554: FND_MESSAGE.SET_TOKEN('TEXT',
555: l_msg_data,
556: FALSE);
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 618: IF FND_API.To_Boolean(p_commit) THEN

614: END IF;
615:
616: /* Check the commit flag and if set, then commit the work. */
617:
618: IF FND_API.To_Boolean(p_commit) THEN
619: COMMIT WORK;
620: END IF;
621:
622: EXCEPTION

Line 633: IF FND_API.To_Boolean(p_called_by_form) THEN

629: 'GR_NO_RECORD_INSERTED');
630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_document_structures_seqno,
632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;
635: ELSE
636: x_msg_data := FND_MESSAGE.Get;
637: END IF;

Line 649: IF FND_API.To_Boolean(p_called_by_form) THEN

645: 'GR_UNEXPECTED_ERROR');
646: FND_MESSAGE.SET_TOKEN('TEXT',
647: l_msg_data,
648: FALSE);
649: IF FND_API.To_Boolean(p_called_by_form) THEN
650: APP_EXCEPTION.Raise_Exception;
651: ELSE
652: x_msg_data := FND_MESSAGE.Get;
653: END IF;

Line 756: IF FND_API.To_Boolean(p_commit) THEN

752: RAISE No_Data_Found_Error;
753: END IF;
754: CLOSE c_lock_document;
755:
756: IF FND_API.To_Boolean(p_commit) THEN
757: COMMIT WORK;
758: END IF;
759:
760: EXCEPTION

Line 771: IF FND_API.To_Boolean(p_called_by_form) THEN

767: 'GR_RECORD_NOT_FOUND');
768: FND_MESSAGE.SET_TOKEN('CODE',
769: l_msg_data,
770: FALSE);
771: IF FND_API.To_Boolean(p_called_by_form) THEN
772: APP_EXCEPTION.Raise_Exception;
773: ELSE
774: x_msg_data := FND_MESSAGE.Get;
775: END IF;

Line 783: IF FND_API.To_Boolean(p_called_by_form) THEN

779: x_return_status := 'E';
780: x_oracle_error := APP_EXCEPTION.Get_Code;
781: FND_MESSAGE.SET_NAME('GR',
782: 'GR_ROW_IS_LOCKED');
783: IF FND_API.To_Boolean(p_called_by_form) THEN
784: APP_EXCEPTION.Raise_Exception;
785: ELSE
786: x_msg_data := FND_MESSAGE.Get;
787: END IF;

Line 799: IF FND_API.To_Boolean(p_called_by_form) THEN

795: 'GR_UNEXPECTED_ERROR');
796: FND_MESSAGE.SET_TOKEN('TEXT',
797: l_msg_data,
798: FALSE);
799: IF FND_API.To_Boolean(p_called_by_form) THEN
800: APP_EXCEPTION.Raise_Exception;
801: ELSE
802: x_msg_data := FND_MESSAGE.Get;
803: END IF;

Line 943: IF FND_API.TO_Boolean(p_commit) THEN

939: WHERE document_structures_seqno = p_document_structures_seqno;
940:
941: /* Check the commit flag and if set, then commit the work. */
942:
943: IF FND_API.TO_Boolean(p_commit) THEN
944: COMMIT WORK;
945: END IF;
946:
947: EXCEPTION

Line 953: IF FND_API.To_Boolean(p_called_by_form) THEN

949: WHEN Check_Integrity_Error THEN
950: ROLLBACK TO SAVEPOINT Delete_Row;
951: x_return_status := l_return_status;
952: x_oracle_error := l_oracle_error;
953: IF FND_API.To_Boolean(p_called_by_form) THEN
954: APP_EXCEPTION.Raise_Exception;
955: ELSE
956: x_msg_data := FND_MESSAGE.Get;
957: END IF;

Line 969: IF FND_API.To_Boolean(p_called_by_form) THEN

965: 'GR_RECORD_NOT_FOUND');
966: FND_MESSAGE.SET_TOKEN('CODE',
967: l_msg_data,
968: FALSE);
969: IF FND_API.To_Boolean(p_called_by_form) THEN
970: APP_EXCEPTION.Raise_Exception;
971: ELSE
972: x_msg_data := FND_MESSAGE.Get;
973: END IF;

Line 986: IF FND_API.To_Boolean(p_called_by_form) THEN

982: 'GR_UNEXPECTED_ERROR');
983: FND_MESSAGE.SET_TOKEN('TEXT',
984: l_msg_data,
985: FALSE);
986: IF FND_API.To_Boolean(p_called_by_form) THEN
987: APP_EXCEPTION.Raise_Exception;
988: ELSE
989: x_msg_data := FND_MESSAGE.Get;
990: END IF;

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

1066: 'F',
1067: l_rowid,
1068: l_key_exists);
1069:
1070: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1071: x_return_status := 'E';
1072: FND_MESSAGE.SET_NAME('GR',
1073: 'GR_RECORD_NOT_FOUND');
1074: FND_MESSAGE.SET_TOKEN('CODE',

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

1086: 'F',
1087: l_rowid,
1088: l_key_exists);
1089:
1090: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1091: x_return_status := 'E';
1092: FND_MESSAGE.SET_NAME('GR',
1093: 'GR_RECORD_NOT_FOUND');
1094: FND_MESSAGE.SET_TOKEN('CODE',

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

1107: 'F',
1108: l_rowid,
1109: l_key_exists);
1110:
1111: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1112: x_return_status := 'E';
1113: FND_MESSAGE.SET_NAME('GR',
1114: 'GR_RECORD_NOT_FOUND');
1115: FND_MESSAGE.SET_TOKEN('CODE',

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

1128: 'F',
1129: l_rowid,
1130: l_key_exists);
1131:
1132: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1133: x_return_status := 'E';
1134: FND_MESSAGE.SET_NAME('GR',
1135: 'GR_RECORD_NOT_FOUND');
1136: FND_MESSAGE.SET_TOKEN('CODE',

Line 1253: IF FND_API.To_Boolean(p_called_by_form) THEN

1249: 'GR_UNEXPECTED_ERROR');
1250: FND_MESSAGE.SET_TOKEN('TEXT',
1251: l_msg_data,
1252: FALSE);
1253: IF FND_API.To_Boolean(p_called_by_form) THEN
1254: APP_EXCEPTION.Raise_Exception;
1255: ELSE
1256: x_msg_data := FND_MESSAGE.Get;
1257: END IF;

Line 1312: IF FND_API.To_Boolean(p_called_by_form) THEN

1308: 'GR_UNEXPECTED_ERROR');
1309: FND_MESSAGE.SET_TOKEN('TEXT',
1310: l_msg_data,
1311: FALSE);
1312: IF FND_API.To_Boolean(p_called_by_form) THEN
1313: APP_EXCEPTION.Raise_Exception;
1314: END IF;
1315:
1316: END Check_Primary_Key;