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

Line 72: IF FND_API.To_Boolean(l_key_exists) THEN

68: 'F',
69: l_rowid,
70: l_key_exists);
71:
72: IF FND_API.To_Boolean(l_key_exists) THEN
73: RAISE Item_Exists_Error;
74: END IF;
75:
76: INSERT INTO gr_document_codes_tl

Line 106: IF FND_API.To_Boolean(l_key_exists) THEN

102: 'F',
103: l_rowid,
104: l_key_exists);
105:
106: IF FND_API.To_Boolean(l_key_exists) THEN
107: x_rowid := l_rowid;
108: ELSE
109: RAISE Row_Missing_Error;
110: END IF;

Line 114: IF FND_API.To_Boolean(p_commit) THEN

110: END IF;
111:
112: /* Check the commit flag and if set, then commit the work. */
113:
114: IF FND_API.To_Boolean(p_commit) THEN
115: COMMIT WORK;
116: END IF;
117:
118: EXCEPTION

Line 129: IF FND_API.To_Boolean(p_called_by_form) THEN

125: 'GR_FOREIGN_KEY_ERROR');
126: FND_MESSAGE.SET_TOKEN('TEXT',
127: l_msg_data,
128: FALSE);
129: IF FND_API.To_Boolean(p_called_by_form) THEN
130: APP_EXCEPTION.Raise_Exception;
131: ELSE
132: x_msg_data := FND_MESSAGE.Get;
133: END IF;

Line 144: IF FND_API.To_Boolean(p_called_by_form) THEN

140: 'GR_RECORD_EXISTS');
141: FND_MESSAGE.SET_TOKEN('CODE',
142: p_document_code,
143: FALSE);
144: IF FND_API.To_Boolean(p_called_by_form) THEN
145: APP_EXCEPTION.Raise_Exception;
146: ELSE
147: x_msg_data := FND_MESSAGE.Get;
148: END IF;

Line 160: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 176: IF FND_API.To_Boolean(p_called_by_form) THEN

172: 'GR_UNEXPECTED_ERROR');
173: FND_MESSAGE.SET_TOKEN('TEXT',
174: l_msg_data,
175: FALSE);
176: IF FND_API.To_Boolean(p_called_by_form) THEN
177: APP_EXCEPTION.Raise_Exception;
178: ELSE
179: x_msg_data := FND_MESSAGE.Get;
180: END IF;

Line 257: IF FND_API.To_Boolean(p_commit) THEN

253: END IF;
254:
255: /* Check if do the commit */
256:
257: IF FND_API.To_Boolean(p_commit) THEN
258: COMMIT WORK;
259: END IF;
260:
261: EXCEPTION

Line 272: IF FND_API.To_Boolean(p_called_by_form) THEN

268: 'GR_FOREIGN_KEY_ERROR');
269: FND_MESSAGE.SET_TOKEN('TEXT',
270: l_msg_data,
271: FALSE);
272: IF FND_API.To_Boolean(p_called_by_form) THEN
273: APP_EXCEPTION.Raise_Exception;
274: ELSE
275: x_msg_data := FND_MESSAGE.Get;
276: END IF;

Line 287: IF FND_API.To_Boolean(p_called_by_form) THEN

283: 'GR_NO_RECORD_INSERTED');
284: FND_MESSAGE.SET_TOKEN('CODE',
285: p_document_code,
286: FALSE);
287: IF FND_API.To_Boolean(p_called_by_form) THEN
288: APP_EXCEPTION.Raise_Exception;
289: ELSE
290: x_msg_data := FND_MESSAGE.Get;
291: END IF;

Line 303: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 474: IF FND_API.To_Boolean(p_commit) THEN

470: END LOOP;
471: END IF;
472: CLOSE c_get_installed_languages;
473:
474: IF FND_API.To_Boolean(p_commit) THEN
475: COMMIT WORK;
476: END IF;
477:
478: EXCEPTION

Line 489: IF FND_API.To_Boolean(p_called_by_form) THEN

485: 'GR_RECORD_NOT_FOUND');
486: FND_MESSAGE.SET_TOKEN('CODE',
487: l_msg_token,
488: FALSE);
489: IF FND_API.To_Boolean(p_called_by_form) THEN
490: APP_EXCEPTION.Raise_Exception;
491: ELSE
492: x_msg_data := FND_MESSAGE.Get;
493: END IF;

Line 505: IF FND_API.To_Boolean(p_called_by_form) THEN

501: 'GR_UNEXPECTED_ERROR');
502: FND_MESSAGE.SET_TOKEN('TEXT',
503: l_msg_token||SQLERRM,
504: FALSE);
505: IF FND_API.To_Boolean(p_called_by_form) THEN
506: APP_EXCEPTION.Raise_Exception;
507: ELSE
508: x_msg_data := FND_MESSAGE.Get;
509: END IF;

Line 579: IF FND_API.To_Boolean(p_commit) THEN

575: IF LockEinRcd.last_update_date <> p_last_update_date THEN
576: RAISE RECORD_CHANGED_ERROR;
577: END IF;
578:
579: IF FND_API.To_Boolean(p_commit) THEN
580: COMMIT WORK;
581: END IF;
582:
583: EXCEPTION

Line 593: IF FND_API.To_Boolean(p_called_by_form) THEN

589: 'GR_RECORD_NOT_FOUND');
590: FND_MESSAGE.SET_TOKEN('CODE',
591: p_document_code,
592: FALSE);
593: IF FND_API.To_Boolean(p_called_by_form) THEN
594: APP_EXCEPTION.Raise_Exception;
595: ELSE
596: x_msg_data := FND_MESSAGE.Get;
597: END IF;

Line 603: IF FND_API.To_Boolean(p_called_by_form) THEN

599: ROLLBACK TO SAVEPOINT Lock_Row;
600: X_return_status := 'E';
601: FND_MESSAGE.SET_NAME('FND',
602: 'FORM_RECORD_CHANGED');
603: IF FND_API.To_Boolean(p_called_by_form) THEN
604: APP_EXCEPTION.Raise_Exception;
605: ELSE
606: x_msg_data := FND_MESSAGE.Get;
607: END IF;

Line 612: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

608: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
609: ROLLBACK TO SAVEPOINT Lock_Row;
610: x_return_status := 'L';
611: x_oracle_error := APP_EXCEPTION.Get_Code;
612: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
613: FND_MESSAGE.SET_NAME('GR',
614: 'GR_ROW_IS_LOCKED');
615: x_msg_data := FND_MESSAGE.Get;
616: END IF;

Line 627: IF FND_API.To_Boolean(p_called_by_form) THEN

623: 'GR_UNEXPECTED_ERROR');
624: FND_MESSAGE.SET_TOKEN('TEXT',
625: l_msg_data,
626: FALSE);
627: IF FND_API.To_Boolean(p_called_by_form) THEN
628: APP_EXCEPTION.Raise_Exception;
629: ELSE
630: x_msg_data := FND_MESSAGE.Get;
631: END IF;

Line 688: IF FND_API.TO_Boolean(p_commit) THEN

684: WHERE rowid = p_rowid;
685:
686: /* Check the commit flag and if set, then commit the work. */
687:
688: IF FND_API.TO_Boolean(p_commit) THEN
689: COMMIT WORK;
690: END IF;
691:
692: EXCEPTION

Line 698: IF FND_API.To_Boolean(p_called_by_form) THEN

694: WHEN Check_Integrity_Error THEN
695: ROLLBACK TO SAVEPOINT Delete_Row;
696: x_return_status := l_return_status;
697: x_oracle_error := l_oracle_error;
698: IF FND_API.To_Boolean(p_called_by_form) THEN
699: APP_EXCEPTION.Raise_Exception;
700: ELSE
701: x_msg_data := FND_MESSAGE.Get;
702: END IF;

Line 713: IF FND_API.To_Boolean(p_called_by_form) THEN

709: 'GR_RECORD_NOT_FOUND');
710: FND_MESSAGE.SET_TOKEN('CODE',
711: p_document_code,
712: FALSE);
713: IF FND_API.To_Boolean(p_called_by_form) THEN
714: APP_EXCEPTION.Raise_Exception;
715: ELSE
716: x_msg_data := FND_MESSAGE.Get;
717: END IF;

Line 729: IF FND_API.To_Boolean(p_called_by_form) THEN

725: 'GR_UNEXPECTED_ERROR');
726: FND_MESSAGE.SET_TOKEN('TEXT',
727: l_msg_data,
728: FALSE);
729: IF FND_API.To_Boolean(p_called_by_form) THEN
730: APP_EXCEPTION.Raise_Exception;
731: ELSE
732: x_msg_data := FND_MESSAGE.Get;
733: END IF;

Line 771: IF FND_API.To_Boolean(p_commit) THEN

767:
768: DELETE FROM gr_document_codes_tl
769: WHERE document_code = p_document_code;
770:
771: IF FND_API.To_Boolean(p_commit) THEN
772: COMMIT WORK;
773: END IF;
774:
775: EXCEPTION

Line 787: IF FND_API.To_Boolean(p_called_by_form) THEN

783: 'GR_UNEXPECTED_ERROR');
784: FND_MESSAGE.SET_TOKEN('TEXT',
785: l_msg_token||SQLERRM,
786: FALSE);
787: IF FND_API.To_Boolean(p_called_by_form) THEN
788: APP_EXCEPTION.Raise_Exception;
789: ELSE
790: x_msg_data := FND_MESSAGE.Get;
791: END IF;

Line 951: IF FND_API.To_Boolean(p_called_by_form) THEN

947: 'GR_INSTALLED_LANG');
948: FND_MESSAGE.SET_TOKEN('CODE',
949: p_language,
950: FALSE);
951: IF FND_API.To_Boolean(p_called_by_form) THEN
952: APP_EXCEPTION.Raise_Exception;
953: ELSE
954: x_msg_data := FND_MESSAGE.Get;
955: END IF;

Line 967: IF FND_API.To_Boolean(p_called_by_form) THEN

963: 'GR_UNEXPECTED_ERROR');
964: FND_MESSAGE.SET_TOKEN('TEXT',
965: l_msg_data,
966: FALSE);
967: IF FND_API.To_Boolean(p_called_by_form) THEN
968: APP_EXCEPTION.Raise_Exception;
969: ELSE
970: x_msg_data := FND_MESSAGE.Get;
971: END IF;

Line 1016: IF FND_API.To_Boolean(p_called_by_form) THEN

1012: 'GR_UNEXPECTED_ERROR');
1013: FND_MESSAGE.SET_TOKEN('TEXT',
1014: l_msg_data,
1015: FALSE);
1016: IF FND_API.To_Boolean(p_called_by_form) THEN
1017: APP_EXCEPTION.Raise_Exception;
1018: END IF;
1019:
1020: END Check_Primary_Key;