eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_AR_AP_AWT_REPORTS_PKG dependencies on JL_AR_AP_AWT_CERTIF

Line 112: UPDATE jl_ar_ap_awt_certif

108: -- Logging Infra: Statement level
109: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Checkrun_id:'||l_checkrun_id);
110: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Check_number:'||l_check_number);
111:
112: UPDATE jl_ar_ap_awt_certif
113: set status = 'VOID'
114: where checkrun_id = l_checkrun_id
115: and check_number = l_check_number;
116:

Line 172: | JL_AR_AP_AWT_CERTIF. This table is used for create the |

168: | |
169: | NOTES |
170: | This module is called from Wrapper to IBY Callout PMt. |
171: | The package will insert records into the table |
172: | JL_AR_AP_AWT_CERTIF. This table is used for create the |
173: | Withholding Certificates. |
174: | Check runname is the Payment Innstruction |
175: | Check ID id the payment ID |
176: | |

Line 338: FUNCTION INS_INTO_JL_AR_AP_AWT_CERTIF(

334: Where ipa.payment_instruction_id = p_payment_instruction_id
335: And org.organization_id = ipa.org_id;
336: -- Bug 10157541 End
337: ------------------------------------------------------------------------------------------
338: FUNCTION INS_INTO_JL_AR_AP_AWT_CERTIF(
339: v_next_certificate_number IN NUMBER ,
340: v_bank_account_num IN VARCHAR2 ,
341: v_payment_document_name IN VARCHAR2 ,
342: v_check_number IN NUMBER ,

Line 365: l_procedure_name CONSTANT VARCHAR2(30) := 'INS_INTO_JL_AR_AP_AWT_CERTIF';

361: /* bug 14798548 - Will use x_org_id var now
362: v_org_id NUMBER(15); */
363:
364: -- Logging Infra
365: l_procedure_name CONSTANT VARCHAR2(30) := 'INS_INTO_JL_AR_AP_AWT_CERTIF';
366: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
367: -- Logging Infra
368:
369: BEGIN

Line 447: l_log_msg := 'Getting next sequence from jl_ar_ap_awt_certif_s';

443:
444:
445: -- Logging Infra: Statement level
446: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
447: l_log_msg := 'Getting next sequence from jl_ar_ap_awt_certif_s';
448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
449: END IF;
450: -- Logging Infra: Statement level
451:

Line 453: SELECT jl_ar_ap_awt_certif_s.nextval

449: END IF;
450: -- Logging Infra: Statement level
451:
452:
453: SELECT jl_ar_ap_awt_certif_s.nextval
454: INTO v_table_id
455: FROM dual ;
456:
457: --Bug 6504015. added code for setting the org-id while insert.

Line 473: l_log_msg := 'Inserting into jl_ar_ap_awt_certif_all table ';

469:
470:
471: -- Logging Infra: Statement level
472: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
473: l_log_msg := 'Inserting into jl_ar_ap_awt_certif_all table ';
474: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
475: END IF;
476: -- Logging Infra: Statement level
477:

Line 479: INSERT INTO jl_ar_ap_awt_certif_all

475: END IF;
476: -- Logging Infra: Statement level
477:
478:
479: INSERT INTO jl_ar_ap_awt_certif_all
480: (certificate_id ,
481: certificate_number ,
482: bank_account_num ,
483: payment_document_name ,

Line 552: ||v_column_required||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';

548:
549: EXCEPTION
550: WHEN column_required THEN
551: p_errmsg := 'Column constraint NOT NULL in the column '
552: ||v_column_required||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';
553:
554: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
555: l_log_msg := 'EXCEPTION: '||p_errmsg;
556: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 563: p_errmsg := p_errmsg||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';

559: RETURN(FALSE);
560:
561: WHEN OTHERS THEN
562: p_errmsg := SUBSTR(SQLERRM, 1, 100);
563: p_errmsg := p_errmsg||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';
564: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
565: l_log_msg := 'EXCEPTION: '||p_errmsg;
566: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
567: END IF;

Line 708: FROM jl_ar_ap_awt_certif_all jaaac1

704:
705:
706: SELECT jaaac1.certificate_number
707: INTO max_number
708: FROM jl_ar_ap_awt_certif_all jaaac1
709: WHERE jaaac1.awt_type_code = p_awt_type_code
710: AND jaaac1.org_id = x_org_id --bug 14798548
711: AND jaaac1.certificate_number = (select max(jaaac2.certificate_number)
712: from jl_ar_ap_awt_certif_all jaaac2

Line 712: from jl_ar_ap_awt_certif_all jaaac2

708: FROM jl_ar_ap_awt_certif_all jaaac1
709: WHERE jaaac1.awt_type_code = p_awt_type_code
710: AND jaaac1.org_id = x_org_id --bug 14798548
711: AND jaaac1.certificate_number = (select max(jaaac2.certificate_number)
712: from jl_ar_ap_awt_certif_all jaaac2
713: where jaaac2.awt_type_code = p_awt_type_code
714: and jaaac2.org_id = x_org_id ) --bug 14798548
715: FOR UPDATE;
716:

Line 1039: v_return := INS_INTO_JL_AR_AP_AWT_CERTIF(

1035: v_credit_amount);
1036:
1037: -- check_return (v_return);
1038:
1039: v_return := INS_INTO_JL_AR_AP_AWT_CERTIF(
1040: v_next_certificate_number ,
1041: v_prev_bank_account_num ,
1042: v_prev_pay_document_name ,
1043: v_prev_check_number ,

Line 1144: v_return := INS_INTO_JL_AR_AP_AWT_CERTIF(

1140:
1141: -- check_return (v_return);
1142:
1143:
1144: v_return := INS_INTO_JL_AR_AP_AWT_CERTIF(
1145: v_next_certificate_number ,
1146: v_prev_bank_account_num ,
1147: v_prev_pay_document_name ,
1148: v_prev_check_number ,