DBA Data[Home] [Help]

APPS.AP_BATCHES_PKG dependencies on FND_MESSAGE

Line 65: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');

61: where batch_name = X_BATCH_NAME
62: and ((X_ROWID is null) or (rowid <> X_ROWID));
63:
64: if (dummy >= 1) then
65: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
66: app_exception.raise_exception;
67: end if;
68:
69: EXCEPTION

Line 72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

68:
69: EXCEPTION
70: WHEN OTHERS THEN
71: IF (SQLCODE <> -20001) THEN
72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
73: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
74: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
75: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
76: ', BATCH_NAME = ' || X_BATCH_NAME);

Line 73: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

69: EXCEPTION
70: WHEN OTHERS THEN
71: IF (SQLCODE <> -20001) THEN
72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
73: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
74: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
75: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
76: ', BATCH_NAME = ' || X_BATCH_NAME);
77: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 74: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

70: WHEN OTHERS THEN
71: IF (SQLCODE <> -20001) THEN
72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
73: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
74: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
75: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
76: ', BATCH_NAME = ' || X_BATCH_NAME);
77: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
78: END IF;

Line 75: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||

71: IF (SQLCODE <> -20001) THEN
72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
73: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
74: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
75: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
76: ', BATCH_NAME = ' || X_BATCH_NAME);
77: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
78: END IF;
79: APP_EXCEPTION.RAISE_EXCEPTION;

Line 77: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

73: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
74: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
75: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
76: ', BATCH_NAME = ' || X_BATCH_NAME);
77: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
78: END IF;
79: APP_EXCEPTION.RAISE_EXCEPTION;
80:
81:

Line 239: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

235:
236: EXCEPTION
237: WHEN OTHERS THEN
238: IF (SQLCODE <> -20001) THEN
239: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
240: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
241: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
242: FND_MESSAGE.SET_TOKEN('PARAMETERS','BATCH_ID = ' || TO_CHAR(X_Batch_Id) ||
243: ', ROWID = ' || X_Rowid);

Line 240: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

236: EXCEPTION
237: WHEN OTHERS THEN
238: IF (SQLCODE <> -20001) THEN
239: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
240: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
241: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
242: FND_MESSAGE.SET_TOKEN('PARAMETERS','BATCH_ID = ' || TO_CHAR(X_Batch_Id) ||
243: ', ROWID = ' || X_Rowid);
244: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 241: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

237: WHEN OTHERS THEN
238: IF (SQLCODE <> -20001) THEN
239: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
240: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
241: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
242: FND_MESSAGE.SET_TOKEN('PARAMETERS','BATCH_ID = ' || TO_CHAR(X_Batch_Id) ||
243: ', ROWID = ' || X_Rowid);
244: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
245: END IF;

Line 242: FND_MESSAGE.SET_TOKEN('PARAMETERS','BATCH_ID = ' || TO_CHAR(X_Batch_Id) ||

238: IF (SQLCODE <> -20001) THEN
239: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
240: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
241: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
242: FND_MESSAGE.SET_TOKEN('PARAMETERS','BATCH_ID = ' || TO_CHAR(X_Batch_Id) ||
243: ', ROWID = ' || X_Rowid);
244: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
245: END IF;
246: APP_EXCEPTION.RAISE_EXCEPTION;

Line 244: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

240: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
241: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
242: FND_MESSAGE.SET_TOKEN('PARAMETERS','BATCH_ID = ' || TO_CHAR(X_Batch_Id) ||
243: ', ROWID = ' || X_Rowid);
244: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
245: END IF;
246: APP_EXCEPTION.RAISE_EXCEPTION;
247:
248: END Insert_Row;

Line 309: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

305: FETCH C INTO Recinfo;
306: if (C%NOTFOUND) then
307: debug_info := 'Close cursor C - ROW NOTFOUND';
308: CLOSE C;
309: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
310: APP_EXCEPTION.Raise_Exception;
311: end if;
312: debug_info := 'Close cursor C';
313: CLOSE C;

Line 412: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

408: AND (X_org_id IS NULL)))
409: ) then
410: return;
411: else
412: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
413: APP_EXCEPTION.Raise_Exception;
414: end if;
415:
416: EXCEPTION

Line 420: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');

416: EXCEPTION
417: WHEN OTHERS THEN
418: IF (SQLCODE <> -20001) THEN
419: IF (SQLCODE = -54) THEN
420: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
421: ELSE
422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

Line 422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

418: IF (SQLCODE <> -20001) THEN
419: IF (SQLCODE = -54) THEN
420: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
421: ELSE
422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));

Line 423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

419: IF (SQLCODE = -54) THEN
420: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
421: ELSE
422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));
427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

420: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
421: ELSE
422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));
427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
428: END IF;

Line 425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

421: ELSE
422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));
427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
428: END IF;
429: END IF;

Line 427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));
427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
428: END IF;
429: END IF;
430: APP_EXCEPTION.RAISE_EXCEPTION;
431:

Line 537: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

533:
534: EXCEPTION
535: WHEN OTHERS THEN
536: IF (SQLCODE <> -20001) THEN
537: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
538: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
539: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
540: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
541: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));

Line 538: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

534: EXCEPTION
535: WHEN OTHERS THEN
536: IF (SQLCODE <> -20001) THEN
537: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
538: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
539: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
540: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
541: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));
542: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 539: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

535: WHEN OTHERS THEN
536: IF (SQLCODE <> -20001) THEN
537: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
538: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
539: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
540: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
541: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));
542: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
543: END IF;

Line 540: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

536: IF (SQLCODE <> -20001) THEN
537: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
538: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
539: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
540: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
541: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));
542: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
543: END IF;
544: APP_EXCEPTION.RAISE_EXCEPTION;

Line 542: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

538: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
539: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
540: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
541: ', BATCH_ID = ' || TO_CHAR(X_Batch_Id));
542: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
543: END IF;
544: APP_EXCEPTION.RAISE_EXCEPTION;
545:
546: END Update_Row;

Line 568: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

564:
565: EXCEPTION
566: WHEN OTHERS THEN
567: IF (SQLCODE <> -20001) THEN
568: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
569: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
570: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
571: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid );
572: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 569: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

565: EXCEPTION
566: WHEN OTHERS THEN
567: IF (SQLCODE <> -20001) THEN
568: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
569: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
570: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
571: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid );
572: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
573: END IF;

Line 570: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

566: WHEN OTHERS THEN
567: IF (SQLCODE <> -20001) THEN
568: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
569: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
570: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
571: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid );
572: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
573: END IF;
574: APP_EXCEPTION.RAISE_EXCEPTION;

Line 571: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid );

567: IF (SQLCODE <> -20001) THEN
568: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
569: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
570: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
571: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid );
572: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
573: END IF;
574: APP_EXCEPTION.RAISE_EXCEPTION;
575:

Line 572: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

568: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
569: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
570: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
571: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid );
572: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
573: END IF;
574: APP_EXCEPTION.RAISE_EXCEPTION;
575:
576: END Delete_Row;