DBA Data[Home] [Help]

APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on FND_MESSAGE

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

316:
317: EXCEPTION
318: WHEN OTHERS THEN
319: IF (SQLCODE <> -20001) THEN
320: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
321: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
322: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeEmpVerificationss');
323: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
324: errbuf := FND_MESSAGE.Get;

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

317: EXCEPTION
318: WHEN OTHERS THEN
319: IF (SQLCODE <> -20001) THEN
320: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
321: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
322: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeEmpVerificationss');
323: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
324: errbuf := FND_MESSAGE.Get;
325: retcode := 2;

Line 322: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeEmpVerificationss');

318: WHEN OTHERS THEN
319: IF (SQLCODE <> -20001) THEN
320: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
321: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
322: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeEmpVerificationss');
323: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
324: errbuf := FND_MESSAGE.Get;
325: retcode := 2;
326: END IF;

Line 323: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

319: IF (SQLCODE <> -20001) THEN
320: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
321: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
322: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeEmpVerificationss');
323: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
324: errbuf := FND_MESSAGE.Get;
325: retcode := 2;
326: END IF;
327: END DistributeEmpVerifications;

Line 324: errbuf := FND_MESSAGE.Get;

320: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
321: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
322: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeEmpVerificationss');
323: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
324: errbuf := FND_MESSAGE.Get;
325: retcode := 2;
326: END IF;
327: END DistributeEmpVerifications;
328:

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

631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: IF (SQLCODE <> -20001) THEN
635: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
636: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
637: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeManagerApprovals');
638: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
639: errbuf := FND_MESSAGE.Get;

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

632: EXCEPTION
633: WHEN OTHERS THEN
634: IF (SQLCODE <> -20001) THEN
635: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
636: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
637: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeManagerApprovals');
638: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
639: errbuf := FND_MESSAGE.Get;
640: retcode := 2;

Line 637: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeManagerApprovals');

633: WHEN OTHERS THEN
634: IF (SQLCODE <> -20001) THEN
635: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
636: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
637: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeManagerApprovals');
638: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
639: errbuf := FND_MESSAGE.Get;
640: retcode := 2;
641: END IF;

Line 638: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

634: IF (SQLCODE <> -20001) THEN
635: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
636: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
637: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeManagerApprovals');
638: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
639: errbuf := FND_MESSAGE.Get;
640: retcode := 2;
641: END IF;
642: END DistributeManagerApprovals;

Line 639: errbuf := FND_MESSAGE.Get;

635: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
636: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
637: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DistributeManagerApprovals');
638: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
639: errbuf := FND_MESSAGE.Get;
640: retcode := 2;
641: END IF;
642: END DistributeManagerApprovals;
643:

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

738:
739: EXCEPTION
740: WHEN OTHERS THEN
741: IF (SQLCODE <> -20001) THEN
742: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
743: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
744: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'EmpVfyPCardSetOrgContext');
745: END IF;
746: APP_EXCEPTION.RAISE_EXCEPTION;

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

739: EXCEPTION
740: WHEN OTHERS THEN
741: IF (SQLCODE <> -20001) THEN
742: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
743: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
744: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'EmpVfyPCardSetOrgContext');
745: END IF;
746: APP_EXCEPTION.RAISE_EXCEPTION;
747: END EmpVfyPCardSetOrgContext;

Line 744: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'EmpVfyPCardSetOrgContext');

740: WHEN OTHERS THEN
741: IF (SQLCODE <> -20001) THEN
742: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
743: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
744: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'EmpVfyPCardSetOrgContext');
745: END IF;
746: APP_EXCEPTION.RAISE_EXCEPTION;
747: END EmpVfyPCardSetOrgContext;
748:

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

763:
764: EXCEPTION
765: WHEN OTHERS THEN
766: IF (SQLCODE <> -20001) THEN
767: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
768: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
769: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MgrAprvlPCardSetOrgContext');
770: END IF;
771: APP_EXCEPTION.RAISE_EXCEPTION;

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

764: EXCEPTION
765: WHEN OTHERS THEN
766: IF (SQLCODE <> -20001) THEN
767: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
768: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
769: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MgrAprvlPCardSetOrgContext');
770: END IF;
771: APP_EXCEPTION.RAISE_EXCEPTION;
772: END MgrAprvlPCardSetOrgContext;

Line 769: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MgrAprvlPCardSetOrgContext');

765: WHEN OTHERS THEN
766: IF (SQLCODE <> -20001) THEN
767: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
768: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
769: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MgrAprvlPCardSetOrgContext');
770: END IF;
771: APP_EXCEPTION.RAISE_EXCEPTION;
772: END MgrAprvlPCardSetOrgContext;
773:

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

1010:
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: IF (SQLCODE <> -20001) THEN
1014: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1015: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','CheckEmpVerificationComplete');
1017: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1018: END IF;

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

1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: IF (SQLCODE <> -20001) THEN
1014: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1015: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','CheckEmpVerificationComplete');
1017: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1018: END IF;
1019: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','CheckEmpVerificationComplete');

1012: WHEN OTHERS THEN
1013: IF (SQLCODE <> -20001) THEN
1014: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1015: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','CheckEmpVerificationComplete');
1017: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1018: END IF;
1019: APP_EXCEPTION.RAISE_EXCEPTION;
1020: END CheckEmpVerificationComplete;

Line 1017: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1013: IF (SQLCODE <> -20001) THEN
1014: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1015: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','CheckEmpVerificationComplete');
1017: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1018: END IF;
1019: APP_EXCEPTION.RAISE_EXCEPTION;
1020: END CheckEmpVerificationComplete;
1021:

Line 1110: fnd_message.set_name('SQLAP', l_message_name);

1106: NULL;
1107:
1108: END IF;
1109:
1110: fnd_message.set_name('SQLAP', l_message_name);
1111: l_message_text := FND_MESSAGE.Get;
1112: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'EMPLOYEE_VERIFICATION_ID',l_emp_verification_id);
1113: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1114:

Line 1111: l_message_text := FND_MESSAGE.Get;

1107:
1108: END IF;
1109:
1110: fnd_message.set_name('SQLAP', l_message_name);
1111: l_message_text := FND_MESSAGE.Get;
1112: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'EMPLOYEE_VERIFICATION_ID',l_emp_verification_id);
1113: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1114:
1115: WF_ENGINE.SetItemAttrText(p_item_type,

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

1275:
1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: IF (SQLCODE <> -20001) THEN
1279: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1280: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CheckManagerApprovalMethod');
1282: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1283: END IF;

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

1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: IF (SQLCODE <> -20001) THEN
1279: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1280: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CheckManagerApprovalMethod');
1282: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1283: END IF;
1284: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CheckManagerApprovalMethod');

1277: WHEN OTHERS THEN
1278: IF (SQLCODE <> -20001) THEN
1279: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1280: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CheckManagerApprovalMethod');
1282: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1283: END IF;
1284: APP_EXCEPTION.RAISE_EXCEPTION;
1285: END CheckManagerApprovalMethod;

Line 1282: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1278: IF (SQLCODE <> -20001) THEN
1279: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1280: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CheckManagerApprovalMethod');
1282: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1283: END IF;
1284: APP_EXCEPTION.RAISE_EXCEPTION;
1285: END CheckManagerApprovalMethod;
1286:

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

1334:
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: IF (SQLCODE <> -20001) THEN
1338: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1339: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsRejected');
1341: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1342: END IF;

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

1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: IF (SQLCODE <> -20001) THEN
1338: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1339: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsRejected');
1341: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1342: END IF;
1343: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsRejected');

1336: WHEN OTHERS THEN
1337: IF (SQLCODE <> -20001) THEN
1338: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1339: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsRejected');
1341: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1342: END IF;
1343: APP_EXCEPTION.RAISE_EXCEPTION;
1344: END MarkTransactionsAsRejected;

Line 1341: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1337: IF (SQLCODE <> -20001) THEN
1338: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1339: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsRejected');
1341: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1342: END IF;
1343: APP_EXCEPTION.RAISE_EXCEPTION;
1344: END MarkTransactionsAsRejected;
1345:

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

1391:
1392: EXCEPTION
1393: WHEN OTHERS THEN
1394: IF (SQLCODE <> -20001) THEN
1395: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1396: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsApproved');
1398: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1399: END IF;

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

1392: EXCEPTION
1393: WHEN OTHERS THEN
1394: IF (SQLCODE <> -20001) THEN
1395: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1396: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsApproved');
1398: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1399: END IF;
1400: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsApproved');

1393: WHEN OTHERS THEN
1394: IF (SQLCODE <> -20001) THEN
1395: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1396: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsApproved');
1398: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1399: END IF;
1400: APP_EXCEPTION.RAISE_EXCEPTION;
1401: END MarkTransactionsAsApproved;

Line 1398: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1394: IF (SQLCODE <> -20001) THEN
1395: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1396: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MarkTransactionsAsApproved');
1398: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1399: END IF;
1400: APP_EXCEPTION.RAISE_EXCEPTION;
1401: END MarkTransactionsAsApproved;
1402: