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;
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;
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;
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;
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:
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;
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;
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;
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;
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:
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;
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;
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:
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;
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;
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:
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;
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;
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;
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:
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:
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,
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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: