DBA Data[Home] [Help]

APPS.GR_RISK_COMBINATIONS_PKG dependencies on FND_API

Line 74: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 115: IF FND_API.To_Boolean(l_key_exists) THEN

111: 'F',
112: l_rowid,
113: l_key_exists);
114:
115: IF FND_API.To_Boolean(l_key_exists) THEN
116: x_rowid := l_rowid;
117: ELSE
118: RAISE Row_Missing_Error;
119: END IF;

Line 123: IF FND_API.To_Boolean(p_commit) THEN

119: END IF;
120:
121: /* Check the commit flag and if set, then commit the work. */
122:
123: IF FND_API.To_Boolean(p_commit) THEN
124: COMMIT WORK;
125: END IF;
126:
127: EXCEPTION

Line 138: IF FND_API.To_Boolean(p_called_by_form) THEN

134: 'GR_FOREIGN_KEY_ERROR');
135: FND_MESSAGE.SET_TOKEN('TEXT',
136: l_msg_data,
137: FALSE);
138: IF FND_API.To_Boolean(p_called_by_form) THEN
139: APP_EXCEPTION.Raise_Exception;
140: ELSE
141: x_msg_data := FND_MESSAGE.Get;
142: END IF;

Line 153: IF FND_API.To_Boolean(p_called_by_form) THEN

149: 'GR_RECORD_EXISTS');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_risk_phrase_code,
152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;
155: ELSE
156: x_msg_data := FND_MESSAGE.Get;
157: END IF;

Line 168: IF FND_API.To_Boolean(p_called_by_form) THEN

164: 'GR_NO_RECORD_INSERTED');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_risk_phrase_code,
167: FALSE);
168: IF FND_API.To_Boolean(p_called_by_form) THEN
169: APP_EXCEPTION.Raise_Exception;
170: ELSE
171: x_msg_data := FND_MESSAGE.Get;
172: END IF;

Line 184: IF FND_API.To_Boolean(p_called_by_form) THEN

180: 'GR_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('TEXT',
182: l_msg_data,
183: FALSE);
184: IF FND_API.To_Boolean(p_called_by_form) THEN
185: APP_EXCEPTION.Raise_Exception;
186: ELSE
187: x_msg_data := FND_MESSAGE.Get;
188: END IF;

Line 267: IF FND_API.To_Boolean(p_commit) THEN

263: END IF;
264:
265: /* Check the commit flag and if set, then commit the work. */
266:
267: IF FND_API.To_Boolean(p_commit) THEN
268: COMMIT WORK;
269: END IF;
270:
271: EXCEPTION

Line 282: IF FND_API.To_Boolean(p_called_by_form) THEN

278: 'GR_FOREIGN_KEY_ERROR');
279: FND_MESSAGE.SET_TOKEN('TEXT',
280: l_msg_data,
281: FALSE);
282: IF FND_API.To_Boolean(p_called_by_form) THEN
283: APP_EXCEPTION.Raise_Exception;
284: ELSE
285: x_msg_data := FND_MESSAGE.Get;
286: END IF;

Line 297: IF FND_API.To_Boolean(p_called_by_form) THEN

293: 'GR_NO_RECORD_INSERTED');
294: FND_MESSAGE.SET_TOKEN('CODE',
295: p_risk_phrase_code,
296: FALSE);
297: IF FND_API.To_Boolean(p_called_by_form) THEN
298: APP_EXCEPTION.Raise_Exception;
299: ELSE
300: x_msg_data := FND_MESSAGE.Get;
301: END IF;

Line 313: IF FND_API.To_Boolean(p_called_by_form) THEN

309: 'GR_UNEXPECTED_ERROR');
310: FND_MESSAGE.SET_TOKEN('TEXT',
311: l_msg_data,
312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;
315: ELSE
316: x_msg_data := FND_MESSAGE.Get;
317: END IF;

Line 383: IF FND_API.To_Boolean(p_commit) THEN

379: RAISE No_Data_Found_Error;
380: END IF;
381: CLOSE c_lock_combinations;
382:
383: IF FND_API.To_Boolean(p_commit) THEN
384: COMMIT WORK;
385: END IF;
386:
387: EXCEPTION

Line 397: IF FND_API.To_Boolean(p_called_by_form) THEN

393: 'GR_RECORD_NOT_FOUND');
394: FND_MESSAGE.SET_TOKEN('CODE',
395: p_risk_phrase_code,
396: FALSE);
397: IF FND_API.To_Boolean(p_called_by_form) THEN
398: APP_EXCEPTION.Raise_Exception;
399: ELSE
400: x_msg_data := FND_MESSAGE.Get;
401: END IF;

Line 409: IF FND_API.To_Boolean(p_called_by_form) THEN

405: x_return_status := 'E';
406: x_oracle_error := APP_EXCEPTION.Get_Code;
407: FND_MESSAGE.SET_NAME('GR',
408: 'GR_ROW_IS_LOCKED');
409: IF FND_API.To_Boolean(p_called_by_form) THEN
410: APP_EXCEPTION.Raise_Exception;
411: ELSE
412: x_msg_data := FND_MESSAGE.Get;
413: END IF;

Line 425: IF FND_API.To_Boolean(p_called_by_form) THEN

421: 'GR_UNEXPECTED_ERROR');
422: FND_MESSAGE.SET_TOKEN('TEXT',
423: l_msg_data,
424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;
427: ELSE
428: x_msg_data := FND_MESSAGE.Get;
429: END IF;

Line 500: IF FND_API.TO_Boolean(p_commit) THEN

496: WHERE rowid = p_rowid;
497:
498: /* Check the commit flag and if set, then commit the work. */
499:
500: IF FND_API.TO_Boolean(p_commit) THEN
501: COMMIT WORK;
502: END IF;
503:
504: EXCEPTION

Line 511: IF FND_API.To_Boolean(p_called_by_form) THEN

507: ROLLBACK TO SAVEPOINT Delete_Row;
508: x_return_status := l_return_status;
509: x_oracle_error := l_oracle_error;
510: x_msg_data := l_msg_data;
511: IF FND_API.To_Boolean(p_called_by_form) THEN
512: APP_EXCEPTION.Raise_Exception;
513: END IF;
514:
515: WHEN Row_Missing_Error THEN

Line 524: IF FND_API.To_Boolean(p_called_by_form) THEN

520: 'GR_RECORD_NOT_FOUND');
521: FND_MESSAGE.SET_TOKEN('CODE',
522: p_risk_phrase_code,
523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;
526: ELSE
527: x_msg_data := FND_MESSAGE.Get;
528: END IF;

Line 541: IF FND_API.To_Boolean(p_called_by_form) THEN

537: 'GR_UNEXPECTED_ERROR');
538: FND_MESSAGE.SET_TOKEN('TEXT',
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 583: IF FND_API.To_Boolean(p_commit) THEN

579:
580: DELETE FROM gr_risk_combinations
581: WHERE risk_phrase_code = p_risk_phrase_code;
582:
583: IF FND_API.To_Boolean(p_commit) THEN
584: COMMIT WORK;
585: END IF;
586:
587: EXCEPTION

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

643: 'F',
644: l_rowid,
645: l_key_exists);
646:
647: IF NOT FND_API.To_Boolean(l_key_exists) THEN
648: FND_MESSAGE.SET_NAME('GR',
649: 'GR_RECORD_NOT_FOUND');
650: FND_MESSAGE.SET_TOKEN('CODE',
651: l_risk_phrase,

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

662: 'F',
663: l_rowid,
664: l_key_exists);
665:
666: IF NOT FND_API.To_Boolean(l_key_exists) THEN
667: FND_MESSAGE.SET_NAME('GR',
668: 'GR_RECORD_NOT_FOUND');
669: FND_MESSAGE.SET_TOKEN('CODE',
670: l_risk_phrase,

Line 751: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 806: IF FND_API.To_Boolean(p_called_by_form) THEN

802: 'GR_UNEXPECTED_ERROR');
803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,
805: FALSE);
806: IF FND_API.To_Boolean(p_called_by_form) THEN
807: APP_EXCEPTION.Raise_Exception;
808: END IF;
809:
810: END Check_Primary_Key;