DBA Data[Home] [Help]

APPS.GR_RISK_PHRASES_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_risk_phrases_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_THERE');
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 475: IF FND_API.To_Boolean(p_commit) THEN

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

Line 490: IF FND_API.To_Boolean(p_called_by_form) THEN

486: 'GR_RECORD_NOT_FOUND');
487: FND_MESSAGE.SET_TOKEN('CODE',
488: l_msg_token,
489: FALSE);
490: IF FND_API.To_Boolean(p_called_by_form) THEN
491: APP_EXCEPTION.Raise_Exception;
492: ELSE
493: x_msg_data := FND_MESSAGE.Get;
494: 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 581: IF FND_API.To_Boolean(p_commit) THEN

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

Line 595: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 606: IF FND_API.To_Boolean(p_called_by_form) THEN

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

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

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

Line 632: IF FND_API.To_Boolean(p_called_by_form) THEN

628: 'GR_UNEXPECTED_ERROR');
629: FND_MESSAGE.SET_TOKEN('TEXT',
630: l_msg_token,
631: FALSE);
632: IF FND_API.To_Boolean(p_called_by_form) THEN
633: APP_EXCEPTION.Raise_Exception;
634: ELSE
635: x_msg_data := FND_MESSAGE.Get;
636: END IF;

Line 709: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 720: IF FND_API.To_Boolean(p_called_by_form) THEN

716: ROLLBACK TO SAVEPOINT Delete_Row;
717: x_return_status := l_return_status;
718: x_oracle_error := l_oracle_error;
719: x_msg_data := l_msg_data;
720: IF FND_API.To_Boolean(p_called_by_form) THEN
721: APP_EXCEPTION.Raise_Exception;
722: END IF;
723:
724: WHEN Row_Missing_Error THEN

Line 733: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 749: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 791: IF FND_API.To_Boolean(p_commit) THEN

787:
788: DELETE FROM gr_risk_phrases_tl
789: WHERE risk_phrase_code = p_risk_phrase_code;
790:
791: IF FND_API.To_Boolean(p_commit) THEN
792: COMMIT WORK;
793: END IF;
794:
795: EXCEPTION

Line 964: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 980: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 1040: IF FND_API.To_Boolean(p_called_by_form) THEN

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