40: EXCEPTION
41: WHEN OTHERS then
42:
43: IF (SQLCODE <> -20001) THEN
44: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
45: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
46: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
47: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
48: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
41: WHEN OTHERS then
42:
43: IF (SQLCODE <> -20001) THEN
44: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
45: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
46: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
47: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
48: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
49: p_checkrun_name);
42:
43: IF (SQLCODE <> -20001) THEN
44: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
45: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
46: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
47: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
48: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
49: p_checkrun_name);
50:
43: IF (SQLCODE <> -20001) THEN
44: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
45: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
46: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
47: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
48: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
49: p_checkrun_name);
50:
51: END IF;
44: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
45: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
46: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
47: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
48: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
49: p_checkrun_name);
50:
51: END IF;
52: APP_EXCEPTION.RAISE_EXCEPTION;
419: exception
420: WHEN OTHERS then
421:
422: IF (SQLCODE <> -20001) THEN
423: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
424: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
426: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
427: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
420: WHEN OTHERS then
421:
422: IF (SQLCODE <> -20001) THEN
423: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
424: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
426: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
427: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
428: to_char(p_checkrun_id));
421:
422: IF (SQLCODE <> -20001) THEN
423: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
424: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
426: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
427: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
428: to_char(p_checkrun_id));
429:
422: IF (SQLCODE <> -20001) THEN
423: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
424: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
426: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
427: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
428: to_char(p_checkrun_id));
429:
430: END IF;
423: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
424: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
426: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
427: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
428: to_char(p_checkrun_id));
429:
430: END IF;
431: APP_EXCEPTION.RAISE_EXCEPTION;
466: exception
467: WHEN OTHERS then
468:
469: IF (SQLCODE <> -20001) THEN
470: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
471: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
473: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
474: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
467: WHEN OTHERS then
468:
469: IF (SQLCODE <> -20001) THEN
470: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
471: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
473: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
474: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
475: to_char(p_checkrun_id));
468:
469: IF (SQLCODE <> -20001) THEN
470: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
471: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
473: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
474: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
475: to_char(p_checkrun_id));
476:
469: IF (SQLCODE <> -20001) THEN
470: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
471: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
473: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
474: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
475: to_char(p_checkrun_id));
476:
477: END IF;
470: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
471: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
473: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
474: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
475: to_char(p_checkrun_id));
476:
477: END IF;
478: APP_EXCEPTION.RAISE_EXCEPTION;
568: exception
569: WHEN OTHERS then
570:
571: IF (SQLCODE <> -20001) THEN
572: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
573: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
576: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
569: WHEN OTHERS then
570:
571: IF (SQLCODE <> -20001) THEN
572: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
573: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
576: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
577: to_char(p_checkrun_id));
570:
571: IF (SQLCODE <> -20001) THEN
572: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
573: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
576: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
577: to_char(p_checkrun_id));
578:
571: IF (SQLCODE <> -20001) THEN
572: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
573: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
576: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
577: to_char(p_checkrun_id));
578:
579: END IF;
572: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
573: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
576: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
577: to_char(p_checkrun_id));
578:
579: END IF;
580: APP_EXCEPTION.RAISE_EXCEPTION;
914: EXCEPTION
915: WHEN OTHERS THEN
916:
917: IF (SQLCODE <> -20001) THEN
918: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
919: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
920: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
921: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
922: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
915: WHEN OTHERS THEN
916:
917: IF (SQLCODE <> -20001) THEN
918: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
919: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
920: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
921: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
922: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
923: p_payment_process_request_name);
916:
917: IF (SQLCODE <> -20001) THEN
918: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
919: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
920: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
921: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
922: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
923: p_payment_process_request_name);
924:
917: IF (SQLCODE <> -20001) THEN
918: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
919: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
920: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
921: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
922: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
923: p_payment_process_request_name);
924:
925:
918: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
919: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
920: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
921: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
922: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
923: p_payment_process_request_name);
924:
925:
926: END IF;
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343:
1344: IF (SQLCODE <> -20001) THEN
1345: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1346: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1347: END IF;
1348: APP_EXCEPTION.RAISE_EXCEPTION;
1349:
1342: WHEN OTHERS THEN
1343:
1344: IF (SQLCODE <> -20001) THEN
1345: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1346: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1347: END IF;
1348: APP_EXCEPTION.RAISE_EXCEPTION;
1349:
1350: END GROUP_INTEREST_CREDITS;
1576: EXCEPTION
1577: WHEN OTHERS THEN
1578:
1579: IF (SQLCODE <> -20001) THEN
1580: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1581: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1582: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1583: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1584: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
1577: WHEN OTHERS THEN
1578:
1579: IF (SQLCODE <> -20001) THEN
1580: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1581: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1582: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1583: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1584: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
1585: to_char(p_template_id));
1578:
1579: IF (SQLCODE <> -20001) THEN
1580: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1581: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1582: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1583: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1584: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
1585: to_char(p_template_id));
1586:
1579: IF (SQLCODE <> -20001) THEN
1580: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1581: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1582: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1583: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1584: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
1585: to_char(p_template_id));
1586:
1587:
1580: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1581: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1582: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1583: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1584: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
1585: to_char(p_template_id));
1586:
1587:
1588: END IF;
4024:
4025: WHEN OTHERS then
4026:
4027: IF (SQLCODE <> -20001) THEN
4028: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4029: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4030: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4032: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
4025: WHEN OTHERS then
4026:
4027: IF (SQLCODE <> -20001) THEN
4028: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4029: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4030: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4032: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
4033: ||',P_template_id '||P_template_id
4026:
4027: IF (SQLCODE <> -20001) THEN
4028: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4029: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4030: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4032: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
4033: ||',P_template_id '||P_template_id
4034: ||',p_payment_date '||p_payment_date
4027: IF (SQLCODE <> -20001) THEN
4028: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4029: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4030: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4032: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
4033: ||',P_template_id '||P_template_id
4034: ||',p_payment_date '||p_payment_date
4035: ||',p_pay_thru_date '||p_pay_thru_date
4028: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4029: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4030: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4032: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
4033: ||',P_template_id '||P_template_id
4034: ||',p_payment_date '||p_payment_date
4035: ||',p_pay_thru_date '||p_pay_thru_date
4036: ||',p_pay_from_date '||p_pay_from_date);
4541: exception
4542: WHEN OTHERS then
4543:
4544: IF (SQLCODE <> -20001) THEN
4545: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4546: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4547: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4548: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4549: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4542: WHEN OTHERS then
4543:
4544: IF (SQLCODE <> -20001) THEN
4545: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4546: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4547: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4548: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4549: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4550: to_char(p_checkrun_id));
4543:
4544: IF (SQLCODE <> -20001) THEN
4545: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4546: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4547: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4548: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4549: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4550: to_char(p_checkrun_id));
4551:
4544: IF (SQLCODE <> -20001) THEN
4545: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4546: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4547: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4548: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4549: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4550: to_char(p_checkrun_id));
4551:
4552: END IF;
4545: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4546: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4547: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4548: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4549: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4550: to_char(p_checkrun_id));
4551:
4552: END IF;
4553: APP_EXCEPTION.RAISE_EXCEPTION;
4645: exception
4646: WHEN OTHERS then
4647:
4648: IF (SQLCODE <> -20001) THEN
4649: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4650: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4652: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4653: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4646: WHEN OTHERS then
4647:
4648: IF (SQLCODE <> -20001) THEN
4649: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4650: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4652: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4653: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4654: to_char(p_checkrun_id));
4647:
4648: IF (SQLCODE <> -20001) THEN
4649: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4650: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4652: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4653: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4654: to_char(p_checkrun_id));
4655:
4648: IF (SQLCODE <> -20001) THEN
4649: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4650: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4652: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4653: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4654: to_char(p_checkrun_id));
4655:
4656: END IF;
4649: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4650: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4652: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4653: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
4654: to_char(p_checkrun_id));
4655:
4656: END IF;
4657: APP_EXCEPTION.RAISE_EXCEPTION;
4769:
4770: WHEN OTHERS then
4771:
4772: IF (SQLCODE <> -20001) THEN
4773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4776: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4777: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
4770: WHEN OTHERS then
4771:
4772: IF (SQLCODE <> -20001) THEN
4773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4776: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4777: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
4778:
4771:
4772: IF (SQLCODE <> -20001) THEN
4773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4776: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4777: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
4778:
4779:
4772: IF (SQLCODE <> -20001) THEN
4773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4776: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4777: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
4778:
4779:
4780:
4773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
4776: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
4777: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
4778:
4779:
4780:
4781: END IF;