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.JAI_AP_TDS_OLD_PKG dependencies on FND_REQUEST

Line 825: result := Fnd_Request.set_mode(TRUE);

821:
822:
823: IF v_flag = 'Y' THEN --2
824:
825: result := Fnd_Request.set_mode(TRUE);
826: lv_statement_no := '11';
827:
828: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221
829:

Line 830: req_id := Fnd_Request.submit_request

826: lv_statement_no := '11';
827:
828: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221
829:
830: req_id := Fnd_Request.submit_request
831: (
832: 'SQLAP',
833: 'APXIIMPT',
834: 'Localization Payables Open Interface Import',

Line 865: result := Fnd_Request.set_mode(TRUE);

861: OPEN Fetch_App_Inv_Flag_Cur(for_std_invoice_rec.vendor_id,for_std_invoice_rec.vendor_site_id);
862: FETCH Fetch_App_Inv_Flag_Cur INTO v_approve_flag;
863: CLOSE Fetch_App_Inv_Flag_Cur;
864: IF NVL(v_approve_flag, 'N') = 'Y' THEN
865: result := Fnd_Request.set_mode(TRUE);
866: */
867:
868: -- above block commented by Aparajita on 29/07/2002 for bug # 2475416, and the block below added.
869:

Line 904: result := Fnd_Request.set_mode(TRUE);

900: IF v_Approved_Invoice_Flag = 'Y' THEN
901:
902: lv_statement_no := '13';
903:
904: result := Fnd_Request.set_mode(TRUE);
905: req1_id := Fnd_Request.submit_request
906: (
907: 'JA', 'JAINAPIN', 'Approval of TDS and CM',
908: SYSDATE, FALSE, req_id, for_std_invoice_rec.vendor_id,

Line 905: req1_id := Fnd_Request.submit_request

901:
902: lv_statement_no := '13';
903:
904: result := Fnd_Request.set_mode(TRUE);
905: req1_id := Fnd_Request.submit_request
906: (
907: 'JA', 'JAINAPIN', 'Approval of TDS and CM',
908: SYSDATE, FALSE, req_id, for_std_invoice_rec.vendor_id,
909: for_std_invoice_rec.vendor_site_id, cancelled_invoices_rec.invoice_id,

Line 1722: result := Fnd_Request.set_mode(TRUE);

1718: p_parent_inv_payment_priority => ln_prnt_pay_priority,
1719: p_parent_inv_exchange_rate => ln_prnt_exchange_rate
1720: );
1721:
1722: result := Fnd_Request.set_mode(TRUE);
1723:
1724: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221
1725:
1726: req_id := Fnd_Request.submit_request(

Line 1726: req_id := Fnd_Request.submit_request(

1722: result := Fnd_Request.set_mode(TRUE);
1723:
1724: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221
1725:
1726: req_id := Fnd_Request.submit_request(
1727: 'SQLAP',
1728: 'APXIIMPT',
1729: 'Localization Payables Open Interface Import',
1730: '',

Line 1810: result := Fnd_Request.set_mode(TRUE);

1806:
1807: -- end addition by Aparajita on 29/07/2002 for bug # 2475416
1808: IF v_Approved_Invoice_Flag = 'Y' THEN
1809:
1810: result := Fnd_Request.set_mode(TRUE);
1811: req1_id := Fnd_Request.submit_request( 'JA', 'JAINAPIN', 'Approval OF TDS AND CM - Localization',
1812: SYSDATE, FALSE, req_id, for_std_invoice_rec.vendor_id,
1813: for_std_invoice_rec.vendor_site_id, p_invoice_Id ,
1814: v_tds_inv_num || ';' || v_sup_cm_num , 'UNAPPLY' );

Line 1811: req1_id := Fnd_Request.submit_request( 'JA', 'JAINAPIN', 'Approval OF TDS AND CM - Localization',

1807: -- end addition by Aparajita on 29/07/2002 for bug # 2475416
1808: IF v_Approved_Invoice_Flag = 'Y' THEN
1809:
1810: result := Fnd_Request.set_mode(TRUE);
1811: req1_id := Fnd_Request.submit_request( 'JA', 'JAINAPIN', 'Approval OF TDS AND CM - Localization',
1812: SYSDATE, FALSE, req_id, for_std_invoice_rec.vendor_id,
1813: for_std_invoice_rec.vendor_site_id, p_invoice_Id ,
1814: v_tds_inv_num || ';' || v_sup_cm_num , 'UNAPPLY' );
1815:

Line 2983: result := Fnd_Request.set_mode(TRUE);

2979:
2980:
2981: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting the Payables OPEN INTERFACE Import concurrent request 1');
2982: v_stage:=11;
2983: result := Fnd_Request.set_mode(TRUE);
2984:
2985: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221
2986:
2987: req_id := Fnd_Request.submit_request

Line 2987: req_id := Fnd_Request.submit_request

2983: result := Fnd_Request.set_mode(TRUE);
2984:
2985: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221
2986:
2987: req_id := Fnd_Request.submit_request
2988: (
2989: 'SQLAP',
2990: 'APXIIMPT',
2991: 'Localization Payables OPEN INTERFACE Import',

Line 3071: result := Fnd_Request.set_mode(TRUE);

3067: IF v_Approved_Invoice_Flag = 'Y' THEN
3068:
3069: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting the Approval OF TDS AND CM concurrent request FOR invoice id '|| p_invoice_id);
3070: v_stage:=12;
3071: result := Fnd_Request.set_mode(TRUE);
3072: req1_id := Fnd_Request.submit_request
3073: (
3074: 'JA',
3075: 'JAINAPIN',

Line 3072: req1_id := Fnd_Request.submit_request

3068:
3069: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting the Approval OF TDS AND CM concurrent request FOR invoice id '|| p_invoice_id);
3070: v_stage:=12;
3071: result := Fnd_Request.set_mode(TRUE);
3072: req1_id := Fnd_Request.submit_request
3073: (
3074: 'JA',
3075: 'JAINAPIN',
3076: 'Approval OF TDS AND CM - Localization)',

Line 3419: result := Fnd_Request.set_mode(TRUE);

3415: p_parent_inv_exchange_rate => ln_prnt_exchange_rate
3416: );
3417:
3418: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting Payables OPEN INTERFACE Import concurrent request 2');
3419: result := Fnd_Request.set_mode(TRUE);
3420:
3421: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221
3422:
3423: req_id := Fnd_Request.submit_request

Line 3423: req_id := Fnd_Request.submit_request

3419: result := Fnd_Request.set_mode(TRUE);
3420:
3421: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221
3422:
3423: req_id := Fnd_Request.submit_request
3424: (
3425: 'SQLAP',
3426: 'APXIIMPT',
3427: 'Localization Payables OPEN INTERFACE Import',

Line 3505: result := Fnd_Request.set_mode(TRUE);

3501:
3502:
3503: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting Approval OF TDS AND CM concurrent request FOR invoice id ' || p_invoice_id);
3504: v_stage:=16;
3505: result := Fnd_Request.set_mode(TRUE);
3506: req1_id := Fnd_Request.submit_request
3507: (
3508: 'JA',
3509: 'JAINAPIN',

Line 3506: req1_id := Fnd_Request.submit_request

3502:
3503: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting Approval OF TDS AND CM concurrent request FOR invoice id ' || p_invoice_id);
3504: v_stage:=16;
3505: result := Fnd_Request.set_mode(TRUE);
3506: req1_id := Fnd_Request.submit_request
3507: (
3508: 'JA',
3509: 'JAINAPIN',
3510: 'Approval OF TDS AND CM - Localization',

Line 3786: result := Fnd_Request.set_mode(TRUE);

3782: OPEN check_dist_type(p_invoice_id, 'PREPAY');
3783: FETCH check_dist_type INTO check_dist_type_r;
3784:
3785: IF check_dist_type%FOUND THEN
3786: result := Fnd_Request.set_mode(TRUE);
3787: req_id := Fnd_Request.submit_request('JA','JAINPREP','To Insert Prepayment Distributions',
3788: '',FALSE,check_dist_type_r.invoice_id,check_dist_type_r.invoice_distribution_id,
3789: ABS(check_dist_type_r.amount),check_dist_type_r.last_updated_by,check_dist_type_r.last_update_date,
3790: check_dist_type_r.created_by,check_dist_type_r.creation_date,check_dist_type_r.org_id,

Line 3787: req_id := Fnd_Request.submit_request('JA','JAINPREP','To Insert Prepayment Distributions',

3783: FETCH check_dist_type INTO check_dist_type_r;
3784:
3785: IF check_dist_type%FOUND THEN
3786: result := Fnd_Request.set_mode(TRUE);
3787: req_id := Fnd_Request.submit_request('JA','JAINPREP','To Insert Prepayment Distributions',
3788: '',FALSE,check_dist_type_r.invoice_id,check_dist_type_r.invoice_distribution_id,
3789: ABS(check_dist_type_r.amount),check_dist_type_r.last_updated_by,check_dist_type_r.last_update_date,
3790: check_dist_type_r.created_by,check_dist_type_r.creation_date,check_dist_type_r.org_id,
3791: check_dist_type_r.prepay_distribution_id,'U','ATTRIBUTE1');

Line 3807: result := Fnd_request.set_mode(TRUE);

3803: /* IF p_invoice_num IS NOT NULL AND p_inv_type = 'RTN' THEN --10
3804: OPEN Fetch_Inv_Id_Cur( p_invoice_num, p_vendor_id, p_vendor_site_id );
3805: FETCH Fetch_Inv_Id_Cur INTO v_rtn_inv;
3806: CLOSE Fetch_Inv_Id_Cur;
3807: result := Fnd_request.set_mode(TRUE);
3808: v_request_id := FND_REQUEST.SUBMIT_REQUEST ( 'SQLAP',
3809: 'APPRVL',
3810: 'Payables Approval Localization -- RTN Invoice',
3811: SYSDATE,

Line 3808: v_request_id := FND_REQUEST.SUBMIT_REQUEST ( 'SQLAP',

3804: OPEN Fetch_Inv_Id_Cur( p_invoice_num, p_vendor_id, p_vendor_site_id );
3805: FETCH Fetch_Inv_Id_Cur INTO v_rtn_inv;
3806: CLOSE Fetch_Inv_Id_Cur;
3807: result := Fnd_request.set_mode(TRUE);
3808: v_request_id := FND_REQUEST.SUBMIT_REQUEST ( 'SQLAP',
3809: 'APPRVL',
3810: 'Payables Approval Localization -- RTN Invoice',
3811: SYSDATE,
3812: FALSE,

Line 3833: result := Fnd_Request.set_mode(TRUE);

3829: OPEN Fetch_Inv_Id_Cur('CAN/'||SUBSTR(i.dm_invoice_num, 1, 47), p_vendor_id, p_vendor_site_id);
3830: FETCH Fetch_Inv_Id_Cur INTO v_can_inv;
3831: CLOSE Fetch_Inv_Id_Cur;
3832:
3833: result := Fnd_Request.set_mode(TRUE);
3834: /* Bug 5378544. Added by Lakshmi Gopalsami
3835: * Included org_id and commit size.
3836: */
3837: v_request_id := Fnd_Request.SUBMIT_REQUEST ( 'SQLAP',

Line 3837: v_request_id := Fnd_Request.SUBMIT_REQUEST ( 'SQLAP',

3833: result := Fnd_Request.set_mode(TRUE);
3834: /* Bug 5378544. Added by Lakshmi Gopalsami
3835: * Included org_id and commit size.
3836: */
3837: v_request_id := Fnd_Request.SUBMIT_REQUEST ( 'SQLAP',
3838: 'APPRVL',
3839: 'TDS Invoice (Cancellation)- Localization ',
3840: SYSDATE,
3841: FALSE,

Line 3875: result := Fnd_Request.set_mode(TRUE);

3871: FETCH c_get_invoice INTO v_uap_inv_id, v_uap_vendor_id;
3872: CLOSE c_get_invoice;
3873:
3874: IF v_uap_inv_id IS NOT NULL THEN
3875: result := Fnd_Request.set_mode(TRUE);
3876: /* Bug 5378544. Added by Lakshmi Gopalsami
3877: * Included org_id and commit size.
3878: */
3879: v_request_id := Fnd_Request.SUBMIT_REQUEST ( 'SQLAP',

Line 3879: v_request_id := Fnd_Request.SUBMIT_REQUEST ( 'SQLAP',

3875: result := Fnd_Request.set_mode(TRUE);
3876: /* Bug 5378544. Added by Lakshmi Gopalsami
3877: * Included org_id and commit size.
3878: */
3879: v_request_id := Fnd_Request.SUBMIT_REQUEST ( 'SQLAP',
3880: 'APPRVL',
3881: 'Return TDS Invoice(Unapply Prepayment)- Localization ',
3882: SYSDATE,
3883: FALSE,

Line 3911: result := Fnd_Request.set_mode(TRUE);

3907: FETCH c_get_invoice INTO v_uap_inv_id, v_uap_vendor_id;
3908: CLOSE c_get_invoice;
3909:
3910: IF v_uap_inv_id IS NOT NULL THEN
3911: result := Fnd_Request.set_mode(TRUE);
3912: /* Bug 5378544. Added by Lakshmi Gopalsami
3913: * Included org_id and commit size.
3914: */
3915: v_request_id := Fnd_Request.SUBMIT_REQUEST (

Line 3915: v_request_id := Fnd_Request.SUBMIT_REQUEST (

3911: result := Fnd_Request.set_mode(TRUE);
3912: /* Bug 5378544. Added by Lakshmi Gopalsami
3913: * Included org_id and commit size.
3914: */
3915: v_request_id := Fnd_Request.SUBMIT_REQUEST (
3916: 'SQLAP',
3917: 'APPRVL',
3918: 'Credit Note Supplier(Unapply Prepayment)- Localization ',
3919: SYSDATE,

Line 3957: result := Fnd_Request.set_mode(TRUE);

3953: FETCH c_get_invoice INTO v_ap_inv_id, v_ap_vendor_id;
3954: CLOSE c_get_invoice;
3955:
3956: IF v_ap_inv_id IS NOT NULL THEN
3957: result := Fnd_Request.set_mode(TRUE);
3958: /* Bug 5378544. Added by Lakshmi Gopalsami
3959: * Included org_id and commit size.
3960: */
3961: v_request_id := Fnd_Request.SUBMIT_REQUEST (

Line 3961: v_request_id := Fnd_Request.SUBMIT_REQUEST (

3957: result := Fnd_Request.set_mode(TRUE);
3958: /* Bug 5378544. Added by Lakshmi Gopalsami
3959: * Included org_id and commit size.
3960: */
3961: v_request_id := Fnd_Request.SUBMIT_REQUEST (
3962: 'SQLAP',
3963: 'APPRVL',
3964: 'TDS Credit Note(Apply Prepayment)- Localization ',
3965: SYSDATE,

Line 3994: result := Fnd_Request.set_mode(TRUE);

3990: FETCH c_get_invoice INTO v_ap_inv_id, v_ap_vendor_id;
3991: CLOSE c_get_invoice;
3992:
3993: IF v_ap_inv_id IS NOT NULL THEN
3994: result := Fnd_Request.set_mode(TRUE);
3995: /* Bug 5378544. Added by Lakshmi Gopalsami
3996: * Included org_id and commit size.
3997: */
3998: v_request_id := Fnd_Request.SUBMIT_REQUEST (

Line 3998: v_request_id := Fnd_Request.SUBMIT_REQUEST (

3994: result := Fnd_Request.set_mode(TRUE);
3995: /* Bug 5378544. Added by Lakshmi Gopalsami
3996: * Included org_id and commit size.
3997: */
3998: v_request_id := Fnd_Request.SUBMIT_REQUEST (
3999: 'SQLAP',
4000: 'APPRVL',
4001: 'Return Invoice Supplier(Apply Prepayment)- Localization ',
4002: SYSDATE,

Line 4054: result := Fnd_Request.set_mode(TRUE);

4050: CLOSE Fetch_Inv_Id_Cur;
4051:
4052: --END LOOP;
4053:
4054: result := Fnd_Request.set_mode(TRUE);
4055: /* Bug 5378544. Added by Lakshmi Gopalsami
4056: * Included org_id and commit size.
4057: */
4058: v_request_id := Fnd_Request.SUBMIT_REQUEST (

Line 4058: v_request_id := Fnd_Request.SUBMIT_REQUEST (

4054: result := Fnd_Request.set_mode(TRUE);
4055: /* Bug 5378544. Added by Lakshmi Gopalsami
4056: * Included org_id and commit size.
4057: */
4058: v_request_id := Fnd_Request.SUBMIT_REQUEST (
4059: 'SQLAP',
4060: 'APPRVL',
4061: 'TDS Invoice - Localization ',
4062: SYSDATE,

Line 4077: result := Fnd_Request.set_mode(TRUE);

4073: TO_CHAR( v_set_of_books_id ),
4074: 'N',
4075: ''); -- commit size
4076:
4077: result := Fnd_Request.set_mode(TRUE);
4078: /* Bug 5378544. Added by Lakshmi Gopalsami
4079: * Included org_id and commit size.
4080: */
4081: v_request_id := Fnd_Request.SUBMIT_REQUEST (

Line 4081: v_request_id := Fnd_Request.SUBMIT_REQUEST (

4077: result := Fnd_Request.set_mode(TRUE);
4078: /* Bug 5378544. Added by Lakshmi Gopalsami
4079: * Included org_id and commit size.
4080: */
4081: v_request_id := Fnd_Request.SUBMIT_REQUEST (
4082: 'SQLAP',
4083: 'APPRVL',
4084: 'Credit Memo - Localization',
4085: SYSDATE,

Line 4114: result := Fnd_Request.set_mode(TRUE);

4110:
4111: v_vendor_id := Vendor_Rec.Vendor_id;
4112:
4113: IF v_tds_cm_inv_id IS NOT NULL THEN
4114: result := Fnd_Request.set_mode(TRUE);
4115: /* Bug 5378544. Added by Lakshmi Gopalsami
4116: * Included org_id and commit size.
4117: */
4118: v_request_id := Fnd_Request.SUBMIT_REQUEST (

Line 4118: v_request_id := Fnd_Request.SUBMIT_REQUEST (

4114: result := Fnd_Request.set_mode(TRUE);
4115: /* Bug 5378544. Added by Lakshmi Gopalsami
4116: * Included org_id and commit size.
4117: */
4118: v_request_id := Fnd_Request.SUBMIT_REQUEST (
4119: 'SQLAP',
4120: 'APPRVL',
4121: 'Credit Memo For Excess TDS - Localization' ,
4122: SYSDATE,

Line 4143: result := Fnd_Request.set_mode(TRUE);

4139: FETCH Fetch_Like_Inv_Id_Cur INTO v_rtn_inv;
4140: CLOSE Fetch_Like_Inv_Id_Cur;
4141:
4142: IF v_rtn_inv IS NOT NULL THEN
4143: result := Fnd_Request.set_mode(TRUE);
4144: /* Bug 5378544. Added by Lakshmi Gopalsami
4145: * Included org_id and commit size.
4146: */
4147: v_request_id := Fnd_Request.SUBMIT_REQUEST (

Line 4147: v_request_id := Fnd_Request.SUBMIT_REQUEST (

4143: result := Fnd_Request.set_mode(TRUE);
4144: /* Bug 5378544. Added by Lakshmi Gopalsami
4145: * Included org_id and commit size.
4146: */
4147: v_request_id := Fnd_Request.SUBMIT_REQUEST (
4148: 'SQLAP',
4149: 'APPRVL',
4150: 'RTN Invoice -- Localization ',
4151: SYSDATE,