DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on FND_MESSAGE

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

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: '||

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

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);

Line 46: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

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

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;

Line 48: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||

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;

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

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: '||

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

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));

Line 425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

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

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;

Line 427: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

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

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: '||

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

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));

Line 472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

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

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;

Line 474: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

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

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: '||

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

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));

Line 574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

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

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;

Line 576: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

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

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: '||

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

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);

Line 920: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

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

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:

Line 922: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||

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;

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

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:

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

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;

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

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= '||

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

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));

Line 1582: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

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

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:

Line 1584: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||

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;

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

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

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

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

Line 4030: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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

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

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

Line 4032: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id

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);

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

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: '||

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

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));

Line 4547: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

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

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;

Line 4549: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

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

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: '||

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

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));

Line 4651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

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

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;

Line 4653: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

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

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);

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

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:

Line 4775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

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

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:

Line 4777: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);

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;