DBA Data[Home] [Help]

APPS.GR_ITEM_GROUPS_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_item_groups_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 476: IF FND_API.To_Boolean(p_commit) THEN

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

Line 491: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 506: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 578: IF FND_API.To_Boolean(p_commit) THEN

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

Line 592: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 604: IF FND_API.To_Boolean(p_called_by_form) THEN

600: x_return_status := 'E';
601: x_oracle_error := APP_EXCEPTION.Get_Code;
602: FND_MESSAGE.SET_NAME('GR',
603: 'GR_ROW_IS_LOCKED');
604: IF FND_API.To_Boolean(p_called_by_form) THEN
605: APP_EXCEPTION.Raise_Exception;
606: ELSE
607: x_msg_data := FND_MESSAGE.Get;
608: END IF;

Line 620: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 705: IF FND_API.TO_Boolean(p_commit) THEN

701: WHERE rowid = p_rowid;
702:
703: /* Check the commit flag and if set, then commit the work. */
704:
705: IF FND_API.TO_Boolean(p_commit) THEN
706: COMMIT WORK;
707: END IF;
708:
709: EXCEPTION

Line 715: IF FND_API.To_Boolean(p_called_by_form) THEN

711: WHEN Check_Integrity_Error THEN
712: ROLLBACK TO SAVEPOINT Delete_Row;
713: x_return_status := l_return_status;
714: x_oracle_error := l_oracle_error;
715: IF FND_API.To_Boolean(p_called_by_form) THEN
716: APP_EXCEPTION.Raise_Exception;
717: ELSE
718: x_msg_data := FND_MESSAGE.Get;
719: END IF;

Line 730: IF FND_API.To_Boolean(p_called_by_form) THEN

726: 'GR_RECORD_NOT_FOUND');
727: FND_MESSAGE.SET_TOKEN('CODE',
728: l_msg_token,
729: FALSE);
730: IF FND_API.To_Boolean(p_called_by_form) THEN
731: APP_EXCEPTION.Raise_Exception;
732: ELSE
733: x_msg_data := FND_MESSAGE.Get;
734: END IF;

Line 747: IF FND_API.To_Boolean(p_called_by_form) THEN

743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_token,
746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;
749: ELSE
750: x_msg_data := FND_MESSAGE.Get;
751: END IF;

Line 789: IF FND_API.To_Boolean(p_commit) THEN

785:
786: DELETE FROM gr_item_groups_tl
787: WHERE item_group_code = p_item_group_code;
788:
789: IF FND_API.To_Boolean(p_commit) THEN
790: COMMIT WORK;
791: END IF;
792:
793: EXCEPTION

Line 805: IF FND_API.To_Boolean(p_called_by_form) THEN

801: 'GR_UNEXPECTED_ERROR');
802: FND_MESSAGE.SET_TOKEN('TEXT',
803: l_msg_token,
804: FALSE);
805: IF FND_API.To_Boolean(p_called_by_form) THEN
806: APP_EXCEPTION.Raise_Exception;
807: ELSE
808: x_msg_data := FND_MESSAGE.Get;
809: END IF;

Line 972: IF FND_API.To_Boolean(p_called_by_form) THEN

968: 'GR_INSTALLED_LANG');
969: FND_MESSAGE.SET_TOKEN('CODE',
970: p_language,
971: FALSE);
972: IF FND_API.To_Boolean(p_called_by_form) THEN
973: APP_EXCEPTION.Raise_Exception;
974: ELSE
975: x_msg_data := FND_MESSAGE.Get;
976: END IF;

Line 988: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 1048: IF FND_API.To_Boolean(p_called_by_form) THEN

1044: 'GR_UNEXPECTED_ERROR');
1045: FND_MESSAGE.SET_TOKEN('TEXT',
1046: l_msg_data,
1047: FALSE);
1048: IF FND_API.To_Boolean(p_called_by_form) THEN
1049: APP_EXCEPTION.Raise_Exception;
1050: END IF;
1051:
1052: END Check_Primary_Key;