DBA Data[Home] [Help]

APPS.GR_DOCUMENT_HEADINGS_PKG dependencies on FND_API

Line 76: IF FND_API.To_Boolean(l_key_exists) THEN

72: 'F',
73: l_rowid,
74: l_key_exists);
75:
76: IF FND_API.To_Boolean(l_key_exists) THEN
77: RAISE Label_Exists_Error;
78: END IF;
79:
80: INSERT INTO gr_document_headings

Line 119: IF FND_API.To_Boolean(l_key_exists) THEN

115: 'F',
116: l_rowid,
117: l_key_exists);
118:
119: IF FND_API.To_Boolean(l_key_exists) THEN
120: x_rowid := l_rowid;
121: x_current_seq := l_current_seq;
122: ELSE
123: RAISE Row_Missing_Error;

Line 128: IF FND_API.To_Boolean(p_commit) THEN

124: END IF;
125:
126: /* Check the commit flag and if set, then commit the work. */
127:
128: IF FND_API.To_Boolean(p_commit) THEN
129: COMMIT WORK;
130: END IF;
131:
132: EXCEPTION

Line 143: IF FND_API.To_Boolean(p_called_by_form) THEN

139: 'GR_FOREIGN_KEY_ERROR');
140: FND_MESSAGE.SET_TOKEN('TEXT',
141: l_msg_data,
142: FALSE);
143: IF FND_API.To_Boolean(p_called_by_form) THEN
144: APP_EXCEPTION.Raise_Exception;
145: ELSE
146: x_msg_data := FND_MESSAGE.Get;
147: END IF;

Line 158: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 173: IF FND_API.To_Boolean(p_called_by_form) THEN

169: 'GR_NO_RECORD_INSERTED');
170: FND_MESSAGE.SET_TOKEN('CODE',
171: p_document_code,
172: FALSE);
173: IF FND_API.To_Boolean(p_called_by_form) THEN
174: APP_EXCEPTION.Raise_Exception;
175: ELSE
176: x_msg_data := FND_MESSAGE.Get;
177: END IF;

Line 189: IF FND_API.To_Boolean(p_called_by_form) THEN

185: 'GR_UNEXPECTED_ERROR');
186: FND_MESSAGE.SET_TOKEN('TEXT',
187: l_msg_data,
188: FALSE);
189: IF FND_API.To_Boolean(p_called_by_form) THEN
190: APP_EXCEPTION.Raise_Exception;
191: ELSE
192: x_msg_data := FND_MESSAGE.Get;
193: END IF;

Line 276: IF FND_API.To_Boolean(p_commit) THEN

272: END IF;
273:
274: /* Check the commit flag and if set, then commit the work. */
275:
276: IF FND_API.To_Boolean(p_commit) THEN
277: COMMIT WORK;
278: END IF;
279:
280: EXCEPTION

Line 291: IF FND_API.To_Boolean(p_called_by_form) THEN

287: 'GR_FOREIGN_KEY_ERROR');
288: FND_MESSAGE.SET_TOKEN('TEXT',
289: l_msg_data,
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 306: IF FND_API.To_Boolean(p_called_by_form) THEN

302: 'GR_NO_RECORD_INSERTED');
303: FND_MESSAGE.SET_TOKEN('CODE',
304: p_document_code,
305: FALSE);
306: IF FND_API.To_Boolean(p_called_by_form) THEN
307: APP_EXCEPTION.Raise_Exception;
308: ELSE
309: x_msg_data := FND_MESSAGE.Get;
310: END IF;

Line 322: IF FND_API.To_Boolean(p_called_by_form) THEN

318: 'GR_UNEXPECTED_ERROR');
319: FND_MESSAGE.SET_TOKEN('TEXT',
320: l_msg_data,
321: FALSE);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;
324: ELSE
325: x_msg_data := FND_MESSAGE.Get;
326: END IF;

Line 384: IF FND_API.To_Boolean(p_commit) THEN

380: END IF;
381:
382: /* Check the commit flag and if set, then commit the work. */
383:
384: IF FND_API.To_Boolean(p_commit) THEN
385: COMMIT WORK;
386: END IF;
387:
388: EXCEPTION

Line 399: IF FND_API.To_Boolean(p_called_by_form) THEN

395: 'GR_NO_RECORD_INSERTED');
396: FND_MESSAGE.SET_TOKEN('CODE',
397: p_document_headings_seqno,
398: FALSE);
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;
401: ELSE
402: x_msg_data := FND_MESSAGE.Get;
403: END IF;

Line 415: IF FND_API.To_Boolean(p_called_by_form) THEN

411: 'GR_UNEXPECTED_ERROR');
412: FND_MESSAGE.SET_TOKEN('TEXT',
413: l_msg_data,
414: FALSE);
415: IF FND_API.To_Boolean(p_called_by_form) THEN
416: APP_EXCEPTION.Raise_Exception;
417: ELSE
418: x_msg_data := FND_MESSAGE.Get;
419: END IF;

Line 488: IF FND_API.To_Boolean(p_commit) THEN

484: RAISE No_Data_Found_Error;
485: END IF;
486: CLOSE c_lock_document;
487:
488: IF FND_API.To_Boolean(p_commit) THEN
489: COMMIT WORK;
490: END IF;
491:
492: EXCEPTION

Line 502: IF FND_API.To_Boolean(p_called_by_form) THEN

498: 'GR_RECORD_NOT_FOUND');
499: FND_MESSAGE.SET_TOKEN('CODE',
500: p_document_code,
501: FALSE);
502: IF FND_API.To_Boolean(p_called_by_form) THEN
503: APP_EXCEPTION.Raise_Exception;
504: ELSE
505: x_msg_data := FND_MESSAGE.Get;
506: END IF;

Line 514: IF FND_API.To_Boolean(p_called_by_form) THEN

510: x_return_status := 'E';
511: x_oracle_error := APP_EXCEPTION.Get_Code;
512: FND_MESSAGE.SET_NAME('GR',
513: 'GR_ROW_IS_LOCKED');
514: IF FND_API.To_Boolean(p_called_by_form) THEN
515: APP_EXCEPTION.Raise_Exception;
516: ELSE
517: x_msg_data := FND_MESSAGE.Get;
518: END IF;

Line 530: IF FND_API.To_Boolean(p_called_by_form) THEN

526: 'GR_UNEXPECTED_ERROR');
527: FND_MESSAGE.SET_TOKEN('TEXT',
528: l_msg_data,
529: FALSE);
530: IF FND_API.To_Boolean(p_called_by_form) THEN
531: APP_EXCEPTION.Raise_Exception;
532: ELSE
533: x_msg_data := FND_MESSAGE.Get;
534: END IF;

Line 608: IF FND_API.TO_Boolean(p_commit) THEN

604: WHERE document_headings_seqno = p_document_headings_seqno;
605:
606: /* Check the commit flag and if set, then commit the work. */
607:
608: IF FND_API.TO_Boolean(p_commit) THEN
609: COMMIT WORK;
610: END IF;
611:
612: EXCEPTION

Line 618: IF FND_API.To_Boolean(p_called_by_form) THEN

614: WHEN Check_Integrity_Error THEN
615: ROLLBACK TO SAVEPOINT Delete_Row;
616: x_return_status := l_return_status;
617: x_oracle_error := l_oracle_error;
618: IF FND_API.To_Boolean(p_called_by_form) THEN
619: APP_EXCEPTION.Raise_Exception;
620: ELSE
621: x_msg_data := FND_MESSAGE.Get;
622: END IF;

Line 633: IF FND_API.To_Boolean(p_called_by_form) THEN

629: 'GR_RECORD_NOT_FOUND');
630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_document_code,
632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;
635: ELSE
636: x_msg_data := FND_MESSAGE.Get;
637: END IF;

Line 650: IF FND_API.To_Boolean(p_called_by_form) THEN

646: 'GR_UNEXPECTED_ERROR');
647: FND_MESSAGE.SET_TOKEN('TEXT',
648: l_msg_data,
649: FALSE);
650: IF FND_API.To_Boolean(p_called_by_form) THEN
651: APP_EXCEPTION.Raise_Exception;
652: ELSE
653: x_msg_data := FND_MESSAGE.Get;
654: END IF;

Line 692: IF FND_API.To_Boolean(p_commit) THEN

688:
689: DELETE FROM gr_document_headings
690: WHERE document_code = p_document_code;
691:
692: IF FND_API.To_Boolean(p_commit) THEN
693: COMMIT WORK;
694: END IF;
695:
696: EXCEPTION

Line 708: IF FND_API.To_Boolean(p_called_by_form) THEN

704: 'GR_UNEXPECTED_ERROR');
705: FND_MESSAGE.SET_TOKEN('TEXT',
706: l_msg_token,
707: FALSE);
708: IF FND_API.To_Boolean(p_called_by_form) THEN
709: APP_EXCEPTION.Raise_Exception;
710: ELSE
711: x_msg_data := FND_MESSAGE.Get;
712: END IF;

Line 898: IF FND_API.To_Boolean(p_called_by_form) THEN

894: 'GR_UNEXPECTED_ERROR');
895: FND_MESSAGE.SET_TOKEN('TEXT',
896: l_msg_data,
897: FALSE);
898: IF FND_API.To_Boolean(p_called_by_form) THEN
899: APP_EXCEPTION.Raise_Exception;
900: ELSE
901: x_msg_data := FND_MESSAGE.Get;
902: END IF;

Line 954: IF FND_API.To_Boolean(p_called_by_form) THEN

950: 'GR_UNEXPECTED_ERROR');
951: FND_MESSAGE.SET_TOKEN('TEXT',
952: l_msg_data,
953: FALSE);
954: IF FND_API.To_Boolean(p_called_by_form) THEN
955: APP_EXCEPTION.Raise_Exception;
956: END IF;
957:
958: END Check_Primary_Key;