DBA Data[Home] [Help]

APPS.GR_ITEM_DOCUMENT_DTLS_PKG dependencies on FND_API

Line 84: IF FND_API.To_Boolean(l_key_exists) THEN

80: 'F',
81: l_rowid,
82: l_key_exists);
83:
84: IF FND_API.To_Boolean(l_key_exists) THEN
85: RAISE Label_Exists_Error;
86: END IF;
87:
88: INSERT INTO gr_item_document_dtls

Line 130: IF FND_API.To_Boolean(l_key_exists) THEN

126: 'F',
127: l_rowid,
128: l_key_exists);
129:
130: IF FND_API.To_Boolean(l_key_exists) THEN
131: x_rowid := l_rowid;
132: ELSE
133: RAISE Row_Missing_Error;
134: END IF;

Line 138: IF FND_API.To_Boolean(p_commit) THEN

134: END IF;
135:
136: /* Check the commit flag and if set, then commit the work. */
137:
138: IF FND_API.To_Boolean(p_commit) THEN
139: COMMIT WORK;
140: END IF;
141:
142: EXCEPTION

Line 153: IF FND_API.To_Boolean(p_called_by_form) THEN

149: 'GR_FOREIGN_KEY_ERROR');
150: FND_MESSAGE.SET_TOKEN('TEXT',
151: l_msg_data,
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_RECORD_EXISTS');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_item_code || ' ' || p_document_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_NO_RECORD_INSERTED');
181: FND_MESSAGE.SET_TOKEN('CODE',
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 200: IF FND_API.To_Boolean(p_called_by_form) THEN

196: 'GR_UNEXPECTED_ERROR');
197: FND_MESSAGE.SET_TOKEN('TEXT',
198: l_msg_data,
199: FALSE);
200: IF FND_API.To_Boolean(p_called_by_form) THEN
201: APP_EXCEPTION.Raise_Exception;
202: ELSE
203: x_msg_data := FND_MESSAGE.Get;
204: END IF;

Line 296: IF FND_API.To_Boolean(p_commit) THEN

292: END IF;
293:
294: /* Check the commit flag and if set, then commit the work. */
295:
296: IF FND_API.To_Boolean(p_commit) THEN
297: COMMIT WORK;
298: END IF;
299:
300: EXCEPTION

Line 311: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 327: IF FND_API.To_Boolean(p_called_by_form) THEN

323: 'GR_NO_RECORD_INSERTED');
324: FND_MESSAGE.SET_TOKEN('CODE',
325: l_msg_data,
326: FALSE);
327: IF FND_API.To_Boolean(p_called_by_form) THEN
328: APP_EXCEPTION.Raise_Exception;
329: ELSE
330: x_msg_data := FND_MESSAGE.Get;
331: END IF;

Line 343: IF FND_API.To_Boolean(p_called_by_form) THEN

339: 'GR_UNEXPECTED_ERROR');
340: FND_MESSAGE.SET_TOKEN('TEXT',
341: l_msg_data,
342: FALSE);
343: IF FND_API.To_Boolean(p_called_by_form) THEN
344: APP_EXCEPTION.Raise_Exception;
345: ELSE
346: x_msg_data := FND_MESSAGE.Get;
347: END IF;

Line 418: IF FND_API.To_Boolean(p_commit) THEN

414: RAISE No_Data_Found_Error;
415: END IF;
416: CLOSE c_lock_item_doc_dtls;
417:
418: IF FND_API.To_Boolean(p_commit) THEN
419: COMMIT WORK;
420: END IF;
421:
422: EXCEPTION

Line 433: IF FND_API.To_Boolean(p_called_by_form) THEN

429: 'GR_RECORD_NOT_FOUND');
430: FND_MESSAGE.SET_TOKEN('CODE',
431: l_msg_data,
432: FALSE);
433: IF FND_API.To_Boolean(p_called_by_form) THEN
434: APP_EXCEPTION.Raise_Exception;
435: ELSE
436: x_msg_data := FND_MESSAGE.Get;
437: END IF;

Line 445: IF FND_API.To_Boolean(p_called_by_form) THEN

441: x_return_status := 'E';
442: x_oracle_error := APP_EXCEPTION.Get_Code;
443: FND_MESSAGE.SET_NAME('GR',
444: 'GR_ROW_IS_LOCKED');
445: IF FND_API.To_Boolean(p_called_by_form) THEN
446: APP_EXCEPTION.Raise_Exception;
447: ELSE
448: x_msg_data := FND_MESSAGE.Get;
449: END IF;

Line 461: IF FND_API.To_Boolean(p_called_by_form) THEN

457: 'GR_UNEXPECTED_ERROR');
458: FND_MESSAGE.SET_TOKEN('TEXT',
459: l_msg_data,
460: FALSE);
461: IF FND_API.To_Boolean(p_called_by_form) THEN
462: APP_EXCEPTION.Raise_Exception;
463: ELSE
464: x_msg_data := FND_MESSAGE.Get;
465: END IF;

Line 544: IF FND_API.TO_Boolean(p_commit) THEN

540: WHERE rowid = p_rowid;
541:
542: /* Check the commit flag and if set, then commit the work. */
543:
544: IF FND_API.TO_Boolean(p_commit) THEN
545: COMMIT WORK;
546: END IF;
547:
548: EXCEPTION

Line 554: IF FND_API.To_Boolean(p_called_by_form) THEN

550: WHEN Check_Integrity_Error THEN
551: ROLLBACK TO SAVEPOINT Delete_Row;
552: x_return_status := l_return_status;
553: x_oracle_error := l_oracle_error;
554: IF FND_API.To_Boolean(p_called_by_form) THEN
555: APP_EXCEPTION.Raise_Exception;
556: ELSE
557: x_msg_data := FND_MESSAGE.Get;
558: END IF;

Line 570: IF FND_API.To_Boolean(p_called_by_form) THEN

566: 'GR_RECORD_NOT_FOUND');
567: FND_MESSAGE.SET_TOKEN('CODE',
568: l_msg_data,
569: FALSE);
570: IF FND_API.To_Boolean(p_called_by_form) THEN
571: APP_EXCEPTION.Raise_Exception;
572: ELSE
573: x_msg_data := FND_MESSAGE.Get;
574: END IF;

Line 587: IF FND_API.To_Boolean(p_called_by_form) THEN

583: 'GR_UNEXPECTED_ERROR');
584: FND_MESSAGE.SET_TOKEN('TEXT',
585: l_msg_data,
586: FALSE);
587: IF FND_API.To_Boolean(p_called_by_form) THEN
588: APP_EXCEPTION.Raise_Exception;
589: ELSE
590: x_msg_data := FND_MESSAGE.Get;
591: END IF;

Line 669: IF FND_API.To_Boolean(p_commit) THEN

665: WHERE phrase_code = p_phrase_code;
666: END IF;
667: END IF;
668:
669: IF FND_API.To_Boolean(p_commit) THEN
670: COMMIT WORK;
671: END IF;
672:
673: EXCEPTION

Line 683: IF FND_API.To_Boolean(p_called_by_form) THEN

679: 'GR_NULL_VALUE');
680: FND_MESSAGE.SET_TOKEN('CODE',
681: l_msg_token,
682: FALSE);
683: IF FND_API.To_Boolean(p_called_by_form) THEN
684: APP_EXCEPTION.Raise_Exception;
685: ELSE
686: x_msg_data := FND_MESSAGE.Get;
687: END IF;

Line 699: IF FND_API.To_Boolean(p_called_by_form) THEN

695: 'GR_UNEXPECTED_ERROR');
696: FND_MESSAGE.SET_TOKEN('TEXT',
697: l_msg_token,
698: FALSE);
699: IF FND_API.To_Boolean(p_called_by_form) THEN
700: APP_EXCEPTION.Raise_Exception;
701: ELSE
702: x_msg_data := FND_MESSAGE.Get;
703: END IF;

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

766: 'F',
767: l_rowid,
768: l_key_exists);
769:
770: IF NOT FND_API.To_Boolean(l_key_exists) THEN
771: x_return_status := 'E';
772: FND_MESSAGE.SET_NAME('GR',
773: 'GR_RECORD_NOT_FOUND');
774: FND_MESSAGE.SET_TOKEN('CODE',

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

785: 'F',
786: l_rowid,
787: l_key_exists);
788:
789: IF NOT FND_API.To_Boolean(l_key_exists) THEN
790: x_return_status := 'E';
791: FND_MESSAGE.SET_NAME('GR',
792: 'GR_RECORD_NOT_FOUND');
793: FND_MESSAGE.SET_TOKEN('CODE',

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

805: 'F',
806: l_rowid,
807: l_key_exists);
808:
809: IF NOT FND_API.To_Boolean(l_key_exists) THEN
810: x_return_status := 'E';
811: FND_MESSAGE.SET_NAME('GR',
812: 'GR_RECORD_NOT_FOUND');
813: FND_MESSAGE.SET_TOKEN('CODE',

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

858: 'F',
859: l_rowid,
860: l_key_exists);
861:
862: IF NOT FND_API.To_Boolean(l_key_exists) THEN
863: x_return_status := 'E';
864: FND_MESSAGE.SET_NAME('GR',
865: 'GR_RECORD_NOT_FOUND');
866: FND_MESSAGE.SET_TOKEN('CODE',

Line 953: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 1018: IF FND_API.To_Boolean(p_called_by_form) THEN

1014: 'GR_UNEXPECTED_ERROR');
1015: FND_MESSAGE.SET_TOKEN('TEXT',
1016: l_msg_data,
1017: FALSE);
1018: IF FND_API.To_Boolean(p_called_by_form) THEN
1019: APP_EXCEPTION.Raise_Exception;
1020: END IF;
1021:
1022: END Check_Primary_Key;