869: x_packetid => g_packet_id,
870: x_mode => l_fc_mode,
871: x_override => 'N',
872: x_partial => l_partial_mode,
873: x_user_id => fnd_global.user_id,
874: x_user_resp_id => fnd_global.resp_id,
875: x_execute => 'Y',
876: x_return_code => l_return_code,
877: x_e_code => l_err_code,
870: x_mode => l_fc_mode,
871: x_override => 'N',
872: x_partial => l_partial_mode,
873: x_user_id => fnd_global.user_id,
874: x_user_resp_id => fnd_global.resp_id,
875: x_execute => 'Y',
876: x_return_code => l_return_code,
877: x_e_code => l_err_code,
878: x_e_stage => l_err_buf) THEN
1529: x_packetid => g_packet_id,
1530: x_mode => l_fc_mode,
1531: x_override => 'N',
1532: x_partial => l_partial_mode,
1533: x_user_id => fnd_global.user_id,
1534: x_user_resp_id => fnd_global.resp_id,
1535: x_execute => 'Y',
1536: x_return_code => l_return_code,
1537: x_e_code => l_err_code,
1530: x_mode => l_fc_mode,
1531: x_override => 'N',
1532: x_partial => l_partial_mode,
1533: x_user_id => fnd_global.user_id,
1534: x_user_resp_id => fnd_global.resp_id,
1535: x_execute => 'Y',
1536: x_return_code => l_return_code,
1537: x_e_code => l_err_code,
1538: x_e_stage => l_err_buf) THEN
1764: l_actual_flag,
1765: l_status_code,
1766: 'N',
1767: l_last_update,
1768: fnd_global.user_id,
1769: fnd_global.user_id,
1770: l_last_update,
1771: fnd_global.login_id,
1772: g_set_of_books_id,
1765: l_status_code,
1766: 'N',
1767: l_last_update,
1768: fnd_global.user_id,
1769: fnd_global.user_id,
1770: l_last_update,
1771: fnd_global.login_id,
1772: g_set_of_books_id,
1773: decode(t_system_linkage_function(i),
1767: l_last_update,
1768: fnd_global.user_id,
1769: fnd_global.user_id,
1770: l_last_update,
1771: fnd_global.login_id,
1772: g_set_of_books_id,
1773: decode(t_system_linkage_function(i),
1774: 'OT', 'Labor Cost',
1775: 'ST', 'Labor Cost',
1880: p_bc_pkt.request_id,
1881: p_bc_pkt.ind_compiled_set_id,
1882: p_bc_pkt.effect_on_funds_code,
1883: l_last_update,
1884: fnd_global.user_id,
1885: fnd_global.user_id,
1886: l_last_update,
1887: fnd_global.login_id,
1888: p_bc_pkt.gl_bc_packets_rowid,
1881: p_bc_pkt.ind_compiled_set_id,
1882: p_bc_pkt.effect_on_funds_code,
1883: l_last_update,
1884: fnd_global.user_id,
1885: fnd_global.user_id,
1886: l_last_update,
1887: fnd_global.login_id,
1888: p_bc_pkt.gl_bc_packets_rowid,
1889: p_bc_pkt.vendor_id,
1883: l_last_update,
1884: fnd_global.user_id,
1885: fnd_global.user_id,
1886: l_last_update,
1887: fnd_global.login_id,
1888: p_bc_pkt.gl_bc_packets_rowid,
1889: p_bc_pkt.vendor_id,
1890: p_bc_pkt.expenditure_category, --Bug: 5003642
1891: p_bc_pkt.revenue_category); --Bug: 5003642
2014: 'ER', 3,
2015: 'VI', 4),
2016: g_request_id,
2017: sysdate,
2018: fnd_global.user_id,
2019: fnd_global.user_id,
2020: sysdate,
2021: fnd_global.login_id
2022: );
2015: 'VI', 4),
2016: g_request_id,
2017: sysdate,
2018: fnd_global.user_id,
2019: fnd_global.user_id,
2020: sysdate,
2021: fnd_global.login_id
2022: );
2023:
2017: sysdate,
2018: fnd_global.user_id,
2019: fnd_global.user_id,
2020: sysdate,
2021: fnd_global.login_id
2022: );
2023:
2024: end;
2025:
2186: last_updated_by)
2187: VALUES (x_packetid,
2188: x_arrival_order_seq,
2189: SYSDATE,
2190: fnd_global.user_id);
2191:
2192: END insert_arrival_order_seq;
2193:
2194: -------------------------------------------------------------------------------
2381: IF g_debug_context = 'Y' THEN
2382: gms_error_pkg.gms_debug (g_error_stage, 'C');
2383: END IF;
2384: --Variables used in insert ..
2385: v_login := fnd_global.login_id;
2386: v_date := sysdate;
2387: v_userid := fnd_global.user_id;
2388:
2389: if (p_process = 'Costing') then
2383: END IF;
2384: --Variables used in insert ..
2385: v_login := fnd_global.login_id;
2386: v_date := sysdate;
2387: v_userid := fnd_global.user_id;
2388:
2389: if (p_process = 'Costing') then
2390:
2391: open first_adls;
3269: v_userid number;
3270: v_date date;
3271: begin
3272: --Variables used in insert ..
3273: v_login := fnd_global.login_id;
3274: v_date := sysdate;
3275: v_userid := fnd_global.user_id;
3276:
3277: g_error_stage := 'TieBack_Xface: Net_zero_adls starts here';
3271: begin
3272: --Variables used in insert ..
3273: v_login := fnd_global.login_id;
3274: v_date := sysdate;
3275: v_userid := fnd_global.user_id;
3276:
3277: g_error_stage := 'TieBack_Xface: Net_zero_adls starts here';
3278: IF g_debug_context = 'Y' THEN
3279: gms_error_pkg.gms_debug (g_error_stage, 'C');