DBA Data[Home] [Help]

APPS.GR_MAIN_HEADINGS_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_main_headings_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 145: IF FND_API.To_Boolean(p_called_by_form) THEN

141: 'GR_RECORD_EXISTS');
142: FND_MESSAGE.SET_TOKEN('CODE',
143: l_msg_token,
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_NO_RECORD_INSERTED');
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 178: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 261: IF FND_API.To_Boolean(p_commit) THEN

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

Line 276: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 291: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 307: IF FND_API.To_Boolean(p_called_by_form) THEN

303: 'GR_UNEXPECTED_ERROR');
304: FND_MESSAGE.SET_TOKEN('TEXT',
305: l_msg_token,
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 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,
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 577: IF FND_API.To_Boolean(p_commit) THEN

573: RAISE No_Data_Found_Error;
574: END IF;
575: CLOSE c_lock_main_hdgs_tl;
576:
577: IF FND_API.To_Boolean(p_commit) THEN
578: COMMIT WORK;
579: END IF;
580:
581: EXCEPTION

Line 591: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 603: IF FND_API.To_Boolean(p_called_by_form) THEN

599: x_return_status := 'E';
600: x_oracle_error := APP_EXCEPTION.Get_Code;
601: FND_MESSAGE.SET_NAME('GR',
602: 'GR_ROW_IS_LOCKED');
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 619: IF FND_API.To_Boolean(p_called_by_form) THEN

615: 'GR_UNEXPECTED_ERROR');
616: FND_MESSAGE.SET_TOKEN('TEXT',
617: l_msg_token,
618: FALSE);
619: IF FND_API.To_Boolean(p_called_by_form) THEN
620: APP_EXCEPTION.Raise_Exception;
621: ELSE
622: x_msg_data := FND_MESSAGE.Get;
623: END IF;

Line 696: IF FND_API.TO_Boolean(p_commit) THEN

692: WHERE rowid = p_rowid;
693:
694: /* Check the commit flag and if set, then commit the work. */
695:
696: IF FND_API.TO_Boolean(p_commit) THEN
697: COMMIT WORK;
698: END IF;
699:
700: EXCEPTION

Line 706: IF FND_API.To_Boolean(p_called_by_form) THEN

702: WHEN Check_Integrity_Error THEN
703: ROLLBACK TO SAVEPOINT Delete_Row;
704: x_return_status := l_return_status;
705: x_oracle_error := l_oracle_error;
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 721: IF FND_API.To_Boolean(p_called_by_form) THEN

717: 'GR_RECORD_NOT_FOUND');
718: FND_MESSAGE.SET_TOKEN('CODE',
719: l_msg_token,
720: FALSE);
721: IF FND_API.To_Boolean(p_called_by_form) THEN
722: APP_EXCEPTION.Raise_Exception;
723: ELSE
724: x_msg_data := FND_MESSAGE.Get;
725: END IF;

Line 737: IF FND_API.To_Boolean(p_called_by_form) THEN

733: 'GR_UNEXPECTED_ERROR');
734: FND_MESSAGE.SET_TOKEN('TEXT',
735: l_msg_data,
736: FALSE);
737: IF FND_API.To_Boolean(p_called_by_form) THEN
738: APP_EXCEPTION.Raise_Exception;
739: ELSE
740: x_msg_data := FND_MESSAGE.Get;
741: END IF;

Line 779: IF FND_API.To_Boolean(p_commit) THEN

775:
776: DELETE FROM gr_main_headings_tl
777: WHERE main_heading_code = p_main_heading_code;
778:
779: IF FND_API.To_Boolean(p_commit) THEN
780: COMMIT WORK;
781: END IF;
782:
783: EXCEPTION

Line 795: IF FND_API.To_Boolean(p_called_by_form) THEN

791: 'GR_UNEXPECTED_ERROR');
792: FND_MESSAGE.SET_TOKEN('TEXT',
793: l_msg_token,
794: FALSE);
795: IF FND_API.To_Boolean(p_called_by_form) THEN
796: APP_EXCEPTION.Raise_Exception;
797: ELSE
798: x_msg_data := FND_MESSAGE.Get;
799: END IF;

Line 962: IF FND_API.To_Boolean(p_called_by_form) THEN

958: 'GR_INSTALLED_LANG');
959: FND_MESSAGE.SET_TOKEN('CODE',
960: p_language,
961: FALSE);
962: IF FND_API.To_Boolean(p_called_by_form) THEN
963: APP_EXCEPTION.Raise_Exception;
964: ELSE
965: x_msg_data := FND_MESSAGE.Get;
966: END IF;

Line 978: IF FND_API.To_Boolean(p_called_by_form) THEN

974: 'GR_UNEXPECTED_ERROR');
975: FND_MESSAGE.SET_TOKEN('TEXT',
976: l_msg_data,
977: FALSE);
978: IF FND_API.To_Boolean(p_called_by_form) THEN
979: APP_EXCEPTION.Raise_Exception;
980: ELSE
981: x_msg_data := FND_MESSAGE.Get;
982: END IF;

Line 1038: IF FND_API.To_Boolean(p_called_by_form) THEN

1034: 'GR_UNEXPECTED_ERROR');
1035: FND_MESSAGE.SET_TOKEN('TEXT',
1036: l_msg_data,
1037: FALSE);
1038: IF FND_API.To_Boolean(p_called_by_form) THEN
1039: APP_EXCEPTION.Raise_Exception;
1040: END IF;
1041:
1042: END Check_Primary_Key;