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.

[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on FND_GLOBAL

Line 106: request_id = fnd_global.conc_request_id,

102: P_DEBUG_INFO => L_DEBUG_INFO
103: ) ;
104: UPDATE inl_ship_lines_int
105: SET processing_status_code = 'ERROR' ,
106: request_id = fnd_global.conc_request_id,
107: last_updated_by = fnd_global.user_id ,
108: last_update_date = SYSDATE ,
109: last_update_login = fnd_global.login_id ,
110: program_id = fnd_global.conc_program_id,

Line 107: last_updated_by = fnd_global.user_id ,

103: ) ;
104: UPDATE inl_ship_lines_int
105: SET processing_status_code = 'ERROR' ,
106: request_id = fnd_global.conc_request_id,
107: last_updated_by = fnd_global.user_id ,
108: last_update_date = SYSDATE ,
109: last_update_login = fnd_global.login_id ,
110: program_id = fnd_global.conc_program_id,
111: program_update_date = SYSDATE ,

Line 109: last_update_login = fnd_global.login_id ,

105: SET processing_status_code = 'ERROR' ,
106: request_id = fnd_global.conc_request_id,
107: last_updated_by = fnd_global.user_id ,
108: last_update_date = SYSDATE ,
109: last_update_login = fnd_global.login_id ,
110: program_id = fnd_global.conc_program_id,
111: program_update_date = SYSDATE ,
112: program_application_id = fnd_global.prog_appl_id
113: WHERE ship_line_int_id = p_parent_table_id

Line 110: program_id = fnd_global.conc_program_id,

106: request_id = fnd_global.conc_request_id,
107: last_updated_by = fnd_global.user_id ,
108: last_update_date = SYSDATE ,
109: last_update_login = fnd_global.login_id ,
110: program_id = fnd_global.conc_program_id,
111: program_update_date = SYSDATE ,
112: program_application_id = fnd_global.prog_appl_id
113: WHERE ship_line_int_id = p_parent_table_id
114: AND processing_status_code <> 'ERROR';

Line 112: program_application_id = fnd_global.prog_appl_id

108: last_update_date = SYSDATE ,
109: last_update_login = fnd_global.login_id ,
110: program_id = fnd_global.conc_program_id,
111: program_update_date = SYSDATE ,
112: program_application_id = fnd_global.prog_appl_id
113: WHERE ship_line_int_id = p_parent_table_id
114: AND processing_status_code <> 'ERROR';
115: SELECT ship_header_int_id
116: INTO l_ship_header_int_id

Line 128: request_id = fnd_global.conc_request_id,

124: p_debug_info => l_debug_info
125: ) ;
126: UPDATE inl_matches_int
127: SET processing_status_code = 'ERROR' ,
128: request_id = fnd_global.conc_request_id,
129: last_updated_by = fnd_global.user_id ,
130: last_update_date = SYSDATE ,
131: last_update_login = fnd_global.login_id ,
132: program_id = fnd_global.conc_program_id,

Line 129: last_updated_by = fnd_global.user_id ,

125: ) ;
126: UPDATE inl_matches_int
127: SET processing_status_code = 'ERROR' ,
128: request_id = fnd_global.conc_request_id,
129: last_updated_by = fnd_global.user_id ,
130: last_update_date = SYSDATE ,
131: last_update_login = fnd_global.login_id ,
132: program_id = fnd_global.conc_program_id,
133: program_update_date = SYSDATE ,

Line 131: last_update_login = fnd_global.login_id ,

127: SET processing_status_code = 'ERROR' ,
128: request_id = fnd_global.conc_request_id,
129: last_updated_by = fnd_global.user_id ,
130: last_update_date = SYSDATE ,
131: last_update_login = fnd_global.login_id ,
132: program_id = fnd_global.conc_program_id,
133: program_update_date = SYSDATE ,
134: program_application_id = fnd_global.prog_appl_id
135: WHERE match_int_id = p_parent_table_id

Line 132: program_id = fnd_global.conc_program_id,

128: request_id = fnd_global.conc_request_id,
129: last_updated_by = fnd_global.user_id ,
130: last_update_date = SYSDATE ,
131: last_update_login = fnd_global.login_id ,
132: program_id = fnd_global.conc_program_id,
133: program_update_date = SYSDATE ,
134: program_application_id = fnd_global.prog_appl_id
135: WHERE match_int_id = p_parent_table_id
136: AND processing_status_code <> 'ERROR';

Line 134: program_application_id = fnd_global.prog_appl_id

130: last_update_date = SYSDATE ,
131: last_update_login = fnd_global.login_id ,
132: program_id = fnd_global.conc_program_id,
133: program_update_date = SYSDATE ,
134: program_application_id = fnd_global.prog_appl_id
135: WHERE match_int_id = p_parent_table_id
136: AND processing_status_code <> 'ERROR';
137: ELSIF p_parent_table_name = 'INL_MATCH_AMOUNTS_INT' THEN
138: l_debug_info := 'Set Match Amounts Interface status to ERROR.';

Line 146: request_id = fnd_global.conc_request_id,

142: p_debug_info => l_debug_info
143: ) ;
144: UPDATE inl_match_amounts_int
145: SET processing_status_code = 'ERROR' ,
146: request_id = fnd_global.conc_request_id,
147: last_updated_by = fnd_global.user_id ,
148: last_update_date = SYSDATE ,
149: last_update_login = fnd_global.login_id ,
150: program_id = fnd_global.conc_program_id,

Line 147: last_updated_by = fnd_global.user_id ,

143: ) ;
144: UPDATE inl_match_amounts_int
145: SET processing_status_code = 'ERROR' ,
146: request_id = fnd_global.conc_request_id,
147: last_updated_by = fnd_global.user_id ,
148: last_update_date = SYSDATE ,
149: last_update_login = fnd_global.login_id ,
150: program_id = fnd_global.conc_program_id,
151: program_update_date = SYSDATE ,

Line 149: last_update_login = fnd_global.login_id ,

145: SET processing_status_code = 'ERROR' ,
146: request_id = fnd_global.conc_request_id,
147: last_updated_by = fnd_global.user_id ,
148: last_update_date = SYSDATE ,
149: last_update_login = fnd_global.login_id ,
150: program_id = fnd_global.conc_program_id,
151: program_update_date = SYSDATE ,
152: program_application_id = fnd_global.prog_appl_id
153: WHERE match_amount_int_id = p_parent_table_id

Line 150: program_id = fnd_global.conc_program_id,

146: request_id = fnd_global.conc_request_id,
147: last_updated_by = fnd_global.user_id ,
148: last_update_date = SYSDATE ,
149: last_update_login = fnd_global.login_id ,
150: program_id = fnd_global.conc_program_id,
151: program_update_date = SYSDATE ,
152: program_application_id = fnd_global.prog_appl_id
153: WHERE match_amount_int_id = p_parent_table_id
154: AND processing_status_code <> 'ERROR';

Line 152: program_application_id = fnd_global.prog_appl_id

148: last_update_date = SYSDATE ,
149: last_update_login = fnd_global.login_id ,
150: program_id = fnd_global.conc_program_id,
151: program_update_date = SYSDATE ,
152: program_application_id = fnd_global.prog_appl_id
153: WHERE match_amount_int_id = p_parent_table_id
154: AND processing_status_code <> 'ERROR';
155: END IF;
156: IF p_parent_table_name = 'INL_SHIP_HEADERS_INT' OR l_ship_header_int_id IS NOT NULL THEN

Line 165: request_id = fnd_global.conc_request_id,

161: p_debug_info => l_debug_info
162: ) ;
163: UPDATE inl_ship_headers_int
164: SET processing_status_code = 'ERROR' ,
165: request_id = fnd_global.conc_request_id,
166: last_updated_by = fnd_global.user_id ,
167: last_update_date = SYSDATE ,
168: last_update_login = fnd_global.login_id ,
169: program_id = fnd_global.conc_program_id,

Line 166: last_updated_by = fnd_global.user_id ,

162: ) ;
163: UPDATE inl_ship_headers_int
164: SET processing_status_code = 'ERROR' ,
165: request_id = fnd_global.conc_request_id,
166: last_updated_by = fnd_global.user_id ,
167: last_update_date = SYSDATE ,
168: last_update_login = fnd_global.login_id ,
169: program_id = fnd_global.conc_program_id,
170: program_update_date = SYSDATE ,

Line 168: last_update_login = fnd_global.login_id ,

164: SET processing_status_code = 'ERROR' ,
165: request_id = fnd_global.conc_request_id,
166: last_updated_by = fnd_global.user_id ,
167: last_update_date = SYSDATE ,
168: last_update_login = fnd_global.login_id ,
169: program_id = fnd_global.conc_program_id,
170: program_update_date = SYSDATE ,
171: program_application_id = fnd_global.prog_appl_id
172: WHERE ship_header_int_id = NVL(l_ship_header_int_id, p_parent_table_id)

Line 169: program_id = fnd_global.conc_program_id,

165: request_id = fnd_global.conc_request_id,
166: last_updated_by = fnd_global.user_id ,
167: last_update_date = SYSDATE ,
168: last_update_login = fnd_global.login_id ,
169: program_id = fnd_global.conc_program_id,
170: program_update_date = SYSDATE ,
171: program_application_id = fnd_global.prog_appl_id
172: WHERE ship_header_int_id = NVL(l_ship_header_int_id, p_parent_table_id)
173: AND processing_status_code <> 'ERROR';

Line 171: program_application_id = fnd_global.prog_appl_id

167: last_update_date = SYSDATE ,
168: last_update_login = fnd_global.login_id ,
169: program_id = fnd_global.conc_program_id,
170: program_update_date = SYSDATE ,
171: program_application_id = fnd_global.prog_appl_id
172: WHERE ship_header_int_id = NVL(l_ship_header_int_id, p_parent_table_id)
173: AND processing_status_code <> 'ERROR';
174: END IF;
175: l_debug_info := 'Insert detailed error message into Interface Error table.';

Line 233: fnd_global.user_id, /21/

229: p_token5_name, /*17*/
230: p_token5_value, /*18*/
231: p_token6_name, /*19*/
232: p_token6_value, /*20*/
233: fnd_global.user_id, /*21*/
234: SYSDATE, /*22*/
235: fnd_global.user_id, /*23*/
236: SYSDATE, /*24*/
237: fnd_global.user_id, /*25*/

Line 235: fnd_global.user_id, /23/

231: p_token6_name, /*19*/
232: p_token6_value, /*20*/
233: fnd_global.user_id, /*21*/
234: SYSDATE, /*22*/
235: fnd_global.user_id, /*23*/
236: SYSDATE, /*24*/
237: fnd_global.user_id, /*25*/
238: fnd_global.conc_program_id, /*26*/
239: fnd_global.prog_appl_id, /*27*/

Line 237: fnd_global.user_id, /25/

233: fnd_global.user_id, /*21*/
234: SYSDATE, /*22*/
235: fnd_global.user_id, /*23*/
236: SYSDATE, /*24*/
237: fnd_global.user_id, /*25*/
238: fnd_global.conc_program_id, /*26*/
239: fnd_global.prog_appl_id, /*27*/
240: SYSDATE, /*28*/
241: fnd_global.conc_request_id /*29*/

Line 238: fnd_global.conc_program_id, /26/

234: SYSDATE, /*22*/
235: fnd_global.user_id, /*23*/
236: SYSDATE, /*24*/
237: fnd_global.user_id, /*25*/
238: fnd_global.conc_program_id, /*26*/
239: fnd_global.prog_appl_id, /*27*/
240: SYSDATE, /*28*/
241: fnd_global.conc_request_id /*29*/
242: );

Line 239: fnd_global.prog_appl_id, /27/

235: fnd_global.user_id, /*23*/
236: SYSDATE, /*24*/
237: fnd_global.user_id, /*25*/
238: fnd_global.conc_program_id, /*26*/
239: fnd_global.prog_appl_id, /*27*/
240: SYSDATE, /*28*/
241: fnd_global.conc_request_id /*29*/
242: );
243: -- Standard End of Procedure/Function Logging

Line 241: fnd_global.conc_request_id /29/

237: fnd_global.user_id, /*25*/
238: fnd_global.conc_program_id, /*26*/
239: fnd_global.prog_appl_id, /*27*/
240: SYSDATE, /*28*/
241: fnd_global.conc_request_id /*29*/
242: );
243: -- Standard End of Procedure/Function Logging
244: INL_LOGGING_PVT.Log_EndProc(
245: p_module_name => g_module_name,

Line 2431: request_id = fnd_global.conc_request_id,

2427: -- Set processing status code to 'COMPLETED' for all lines
2428: -- related to the current and imported Shipment Header
2429: UPDATE inl_ship_lines_int
2430: SET processing_status_code = 'COMPLETED' ,
2431: request_id = fnd_global.conc_request_id,
2432: last_updated_by = fnd_global.user_id ,
2433: last_update_date = SYSDATE ,
2434: last_update_login = fnd_global.login_id ,
2435: program_id = fnd_global.conc_program_id,

Line 2432: last_updated_by = fnd_global.user_id ,

2428: -- related to the current and imported Shipment Header
2429: UPDATE inl_ship_lines_int
2430: SET processing_status_code = 'COMPLETED' ,
2431: request_id = fnd_global.conc_request_id,
2432: last_updated_by = fnd_global.user_id ,
2433: last_update_date = SYSDATE ,
2434: last_update_login = fnd_global.login_id ,
2435: program_id = fnd_global.conc_program_id,
2436: program_update_date = SYSDATE ,

Line 2434: last_update_login = fnd_global.login_id ,

2430: SET processing_status_code = 'COMPLETED' ,
2431: request_id = fnd_global.conc_request_id,
2432: last_updated_by = fnd_global.user_id ,
2433: last_update_date = SYSDATE ,
2434: last_update_login = fnd_global.login_id ,
2435: program_id = fnd_global.conc_program_id,
2436: program_update_date = SYSDATE ,
2437: program_application_id = fnd_global.prog_appl_id
2438: WHERE ship_header_int_id = validHeaders_List(iHead) .ship_header_int_id;

Line 2435: program_id = fnd_global.conc_program_id,

2431: request_id = fnd_global.conc_request_id,
2432: last_updated_by = fnd_global.user_id ,
2433: last_update_date = SYSDATE ,
2434: last_update_login = fnd_global.login_id ,
2435: program_id = fnd_global.conc_program_id,
2436: program_update_date = SYSDATE ,
2437: program_application_id = fnd_global.prog_appl_id
2438: WHERE ship_header_int_id = validHeaders_List(iHead) .ship_header_int_id;
2439: ELSE

Line 2437: program_application_id = fnd_global.prog_appl_id

2433: last_update_date = SYSDATE ,
2434: last_update_login = fnd_global.login_id ,
2435: program_id = fnd_global.conc_program_id,
2436: program_update_date = SYSDATE ,
2437: program_application_id = fnd_global.prog_appl_id
2438: WHERE ship_header_int_id = validHeaders_List(iHead) .ship_header_int_id;
2439: ELSE
2440: l_debug_info := 'Check if Shipment Number is setup as Automatic or Manual';
2441: INL_LOGGING_PVT.Log_Statement(

Line 2474: last_updated_by = fnd_global.user_id , -- 20

2470: ship_header_int_id = validHeaders_List(iHead) .ship_header_int_id , -- 14
2471: interface_source_code = validHeaders_List(iHead) .interface_source_code , -- 15
2472: interface_source_table = validHeaders_List(iHead) .interface_source_table , -- 16
2473: interface_source_line_id = validHeaders_List(iHead) .interface_source_line_id , -- 17
2474: last_updated_by = fnd_global.user_id , -- 20
2475: last_update_date = SYSDATE , -- 21
2476: last_update_login = fnd_global.login_id , -- 22
2477: program_id = fnd_global.conc_program_id , -- 23
2478: program_update_date = SYSDATE , -- 24

Line 2476: last_update_login = fnd_global.login_id , -- 22

2472: interface_source_table = validHeaders_List(iHead) .interface_source_table , -- 16
2473: interface_source_line_id = validHeaders_List(iHead) .interface_source_line_id , -- 17
2474: last_updated_by = fnd_global.user_id , -- 20
2475: last_update_date = SYSDATE , -- 21
2476: last_update_login = fnd_global.login_id , -- 22
2477: program_id = fnd_global.conc_program_id , -- 23
2478: program_update_date = SYSDATE , -- 24
2479: program_application_id = fnd_global.prog_appl_id , -- 25
2480: request_id = fnd_global.conc_request_id , -- 26

Line 2477: program_id = fnd_global.conc_program_id , -- 23

2473: interface_source_line_id = validHeaders_List(iHead) .interface_source_line_id , -- 17
2474: last_updated_by = fnd_global.user_id , -- 20
2475: last_update_date = SYSDATE , -- 21
2476: last_update_login = fnd_global.login_id , -- 22
2477: program_id = fnd_global.conc_program_id , -- 23
2478: program_update_date = SYSDATE , -- 24
2479: program_application_id = fnd_global.prog_appl_id , -- 25
2480: request_id = fnd_global.conc_request_id , -- 26
2481: attribute_category = validHeaders_List(iHead) .attribute_category , -- 27

Line 2479: program_application_id = fnd_global.prog_appl_id , -- 25

2475: last_update_date = SYSDATE , -- 21
2476: last_update_login = fnd_global.login_id , -- 22
2477: program_id = fnd_global.conc_program_id , -- 23
2478: program_update_date = SYSDATE , -- 24
2479: program_application_id = fnd_global.prog_appl_id , -- 25
2480: request_id = fnd_global.conc_request_id , -- 26
2481: attribute_category = validHeaders_List(iHead) .attribute_category , -- 27
2482: attribute1 = validHeaders_List(iHead) .attribute1 , -- 28
2483: attribute2 = validHeaders_List(iHead) .attribute2 , -- 29

Line 2480: request_id = fnd_global.conc_request_id , -- 26

2476: last_update_login = fnd_global.login_id , -- 22
2477: program_id = fnd_global.conc_program_id , -- 23
2478: program_update_date = SYSDATE , -- 24
2479: program_application_id = fnd_global.prog_appl_id , -- 25
2480: request_id = fnd_global.conc_request_id , -- 26
2481: attribute_category = validHeaders_List(iHead) .attribute_category , -- 27
2482: attribute1 = validHeaders_List(iHead) .attribute1 , -- 28
2483: attribute2 = validHeaders_List(iHead) .attribute2 , -- 29
2484: attribute3 = validHeaders_List(iHead) .attribute3 , -- 30

Line 2527: last_updated_by = fnd_global.user_id ,

2523: IF l_user_defined_ship_num_code = 'AUTOMATIC' THEN
2524: l_ship_num := l_next_ship_num;
2525: UPDATE inl_parameters
2526: SET next_ship_num = l_next_ship_num + 1,
2527: last_updated_by = fnd_global.user_id ,
2528: last_update_date = SYSDATE ,
2529: last_update_login = fnd_global.login_id
2530: WHERE organization_id = validHeaders_List(iHead).organization_id;
2531: ELSIF l_user_defined_ship_num_code = 'MANUAL' THEN

Line 2529: last_update_login = fnd_global.login_id

2525: UPDATE inl_parameters
2526: SET next_ship_num = l_next_ship_num + 1,
2527: last_updated_by = fnd_global.user_id ,
2528: last_update_date = SYSDATE ,
2529: last_update_login = fnd_global.login_id
2530: WHERE organization_id = validHeaders_List(iHead).organization_id;
2531: ELSIF l_user_defined_ship_num_code = 'MANUAL' THEN
2532: l_ship_num := validHeaders_List(iHead).ship_num;
2533: END IF;

Line 2609: fnd_global.user_id , -- 18

2605: validHeaders_List(iHead) .interface_source_code , -- 15
2606: validHeaders_List(iHead) .interface_source_table , -- 16
2607: validHeaders_List(iHead) .interface_source_line_id , -- 17
2608: 0 , -- 17a
2609: fnd_global.user_id , -- 18
2610: SYSDATE , -- 19
2611: fnd_global.user_id , -- 20
2612: SYSDATE , -- 21
2613: fnd_global.login_id , -- 22

Line 2611: fnd_global.user_id , -- 20

2607: validHeaders_List(iHead) .interface_source_line_id , -- 17
2608: 0 , -- 17a
2609: fnd_global.user_id , -- 18
2610: SYSDATE , -- 19
2611: fnd_global.user_id , -- 20
2612: SYSDATE , -- 21
2613: fnd_global.login_id , -- 22
2614: fnd_global.conc_program_id , -- 23
2615: SYSDATE , -- 24

Line 2613: fnd_global.login_id , -- 22

2609: fnd_global.user_id , -- 18
2610: SYSDATE , -- 19
2611: fnd_global.user_id , -- 20
2612: SYSDATE , -- 21
2613: fnd_global.login_id , -- 22
2614: fnd_global.conc_program_id , -- 23
2615: SYSDATE , -- 24
2616: fnd_global.prog_appl_id , -- 25
2617: fnd_global.conc_request_id , -- 26

Line 2614: fnd_global.conc_program_id , -- 23

2610: SYSDATE , -- 19
2611: fnd_global.user_id , -- 20
2612: SYSDATE , -- 21
2613: fnd_global.login_id , -- 22
2614: fnd_global.conc_program_id , -- 23
2615: SYSDATE , -- 24
2616: fnd_global.prog_appl_id , -- 25
2617: fnd_global.conc_request_id , -- 26
2618: validHeaders_List(iHead) .attribute_category , -- 27

Line 2616: fnd_global.prog_appl_id , -- 25

2612: SYSDATE , -- 21
2613: fnd_global.login_id , -- 22
2614: fnd_global.conc_program_id , -- 23
2615: SYSDATE , -- 24
2616: fnd_global.prog_appl_id , -- 25
2617: fnd_global.conc_request_id , -- 26
2618: validHeaders_List(iHead) .attribute_category , -- 27
2619: validHeaders_List(iHead) .attribute1 , -- 28
2620: validHeaders_List(iHead) .attribute2 , -- 29

Line 2617: fnd_global.conc_request_id , -- 26

2613: fnd_global.login_id , -- 22
2614: fnd_global.conc_program_id , -- 23
2615: SYSDATE , -- 24
2616: fnd_global.prog_appl_id , -- 25
2617: fnd_global.conc_request_id , -- 26
2618: validHeaders_List(iHead) .attribute_category , -- 27
2619: validHeaders_List(iHead) .attribute1 , -- 28
2620: validHeaders_List(iHead) .attribute2 , -- 29
2621: validHeaders_List(iHead) .attribute3 , -- 30

Line 2648: request_id = fnd_global.conc_request_id ,

2644: -- for the current and imported Shipment Header
2645: UPDATE inl_ship_headers_int
2646: SET processing_status_code = 'COMPLETED' ,
2647: ship_header_id = validHeaders_List(iHead).ship_header_id,
2648: request_id = fnd_global.conc_request_id ,
2649: last_updated_by = fnd_global.user_id ,
2650: last_update_date = SYSDATE ,
2651: last_update_login = fnd_global.login_id ,
2652: program_id = fnd_global.conc_program_id ,

Line 2649: last_updated_by = fnd_global.user_id ,

2645: UPDATE inl_ship_headers_int
2646: SET processing_status_code = 'COMPLETED' ,
2647: ship_header_id = validHeaders_List(iHead).ship_header_id,
2648: request_id = fnd_global.conc_request_id ,
2649: last_updated_by = fnd_global.user_id ,
2650: last_update_date = SYSDATE ,
2651: last_update_login = fnd_global.login_id ,
2652: program_id = fnd_global.conc_program_id ,
2653: program_update_date = SYSDATE ,

Line 2651: last_update_login = fnd_global.login_id ,

2647: ship_header_id = validHeaders_List(iHead).ship_header_id,
2648: request_id = fnd_global.conc_request_id ,
2649: last_updated_by = fnd_global.user_id ,
2650: last_update_date = SYSDATE ,
2651: last_update_login = fnd_global.login_id ,
2652: program_id = fnd_global.conc_program_id ,
2653: program_update_date = SYSDATE ,
2654: program_application_id = fnd_global.prog_appl_id
2655: WHERE ship_header_int_id = validHeaders_List(iHead).ship_header_int_id;

Line 2652: program_id = fnd_global.conc_program_id ,

2648: request_id = fnd_global.conc_request_id ,
2649: last_updated_by = fnd_global.user_id ,
2650: last_update_date = SYSDATE ,
2651: last_update_login = fnd_global.login_id ,
2652: program_id = fnd_global.conc_program_id ,
2653: program_update_date = SYSDATE ,
2654: program_application_id = fnd_global.prog_appl_id
2655: WHERE ship_header_int_id = validHeaders_List(iHead).ship_header_int_id;
2656: END LOOP;

Line 2654: program_application_id = fnd_global.prog_appl_id

2650: last_update_date = SYSDATE ,
2651: last_update_login = fnd_global.login_id ,
2652: program_id = fnd_global.conc_program_id ,
2653: program_update_date = SYSDATE ,
2654: program_application_id = fnd_global.prog_appl_id
2655: WHERE ship_header_int_id = validHeaders_List(iHead).ship_header_int_id;
2656: END LOOP;
2657: END IF;
2658: -- Standard End of Procedure/Function Logging

Line 2883: fnd_global.user_id, /* 12 */

2879: rec_ship_line_groups.source_organization_id, /* 08 */
2880: validLines_List(p_line_index) .ship_line_int_id, /* 09 */
2881: validLines_List(p_line_index) .interface_source_table, /* 10 */
2882: validLines_List(p_line_index) .interface_source_line_id,/* 11 */
2883: fnd_global.user_id, /* 12 */
2884: SYSDATE, /* 13 */
2885: fnd_global.user_id, /* 14 */
2886: SYSDATE, /* 15 */
2887: fnd_global.login_id, /* 16 */

Line 2885: fnd_global.user_id, /* 14 */

2881: validLines_List(p_line_index) .interface_source_table, /* 10 */
2882: validLines_List(p_line_index) .interface_source_line_id,/* 11 */
2883: fnd_global.user_id, /* 12 */
2884: SYSDATE, /* 13 */
2885: fnd_global.user_id, /* 14 */
2886: SYSDATE, /* 15 */
2887: fnd_global.login_id, /* 16 */
2888: fnd_global.conc_program_id, /* 17 */
2889: SYSDATE, /* 18 */

Line 2887: fnd_global.login_id, /* 16 */

2883: fnd_global.user_id, /* 12 */
2884: SYSDATE, /* 13 */
2885: fnd_global.user_id, /* 14 */
2886: SYSDATE, /* 15 */
2887: fnd_global.login_id, /* 16 */
2888: fnd_global.conc_program_id, /* 17 */
2889: SYSDATE, /* 18 */
2890: fnd_global.prog_appl_id, /* 19 */
2891: fnd_global.conc_request_id, /* 20 */

Line 2888: fnd_global.conc_program_id, /* 17 */

2884: SYSDATE, /* 13 */
2885: fnd_global.user_id, /* 14 */
2886: SYSDATE, /* 15 */
2887: fnd_global.login_id, /* 16 */
2888: fnd_global.conc_program_id, /* 17 */
2889: SYSDATE, /* 18 */
2890: fnd_global.prog_appl_id, /* 19 */
2891: fnd_global.conc_request_id, /* 20 */
2892: validLines_List(p_line_index) .attribute_category_lg, /* 21 */

Line 2890: fnd_global.prog_appl_id, /* 19 */

2886: SYSDATE, /* 15 */
2887: fnd_global.login_id, /* 16 */
2888: fnd_global.conc_program_id, /* 17 */
2889: SYSDATE, /* 18 */
2890: fnd_global.prog_appl_id, /* 19 */
2891: fnd_global.conc_request_id, /* 20 */
2892: validLines_List(p_line_index) .attribute_category_lg, /* 21 */
2893: validLines_List(p_line_index) .attribute1_lg, /* 22 */
2894: validLines_List(p_line_index) .attribute2_lg, /* 23 */

Line 2891: fnd_global.conc_request_id, /* 20 */

2887: fnd_global.login_id, /* 16 */
2888: fnd_global.conc_program_id, /* 17 */
2889: SYSDATE, /* 18 */
2890: fnd_global.prog_appl_id, /* 19 */
2891: fnd_global.conc_request_id, /* 20 */
2892: validLines_List(p_line_index) .attribute_category_lg, /* 21 */
2893: validLines_List(p_line_index) .attribute1_lg, /* 22 */
2894: validLines_List(p_line_index) .attribute2_lg, /* 23 */
2895: validLines_List(p_line_index) .attribute3_lg, /* 24 */

Line 3228: fnd_global.user_id, /* 57 */

3224: validLines_List(iLine).org_id, /* 53 */
3225: validLines_List(iLine).ship_line_int_id, /* 54 */
3226: validLines_List(iLine).interface_source_table, /* 55 */
3227: validLines_List(iLine).interface_source_line_id, /* 56 */
3228: fnd_global.user_id, /* 57 */
3229: SYSDATE, /* 58 */
3230: fnd_global.user_id, /* 59 */
3231: SYSDATE, /* 60 */
3232: fnd_global.login_id, /* 61 */

Line 3230: fnd_global.user_id, /* 59 */

3226: validLines_List(iLine).interface_source_table, /* 55 */
3227: validLines_List(iLine).interface_source_line_id, /* 56 */
3228: fnd_global.user_id, /* 57 */
3229: SYSDATE, /* 58 */
3230: fnd_global.user_id, /* 59 */
3231: SYSDATE, /* 60 */
3232: fnd_global.login_id, /* 61 */
3233: fnd_global.conc_program_id, /* 62 */
3234: SYSDATE, /* 63 */

Line 3232: fnd_global.login_id, /* 61 */

3228: fnd_global.user_id, /* 57 */
3229: SYSDATE, /* 58 */
3230: fnd_global.user_id, /* 59 */
3231: SYSDATE, /* 60 */
3232: fnd_global.login_id, /* 61 */
3233: fnd_global.conc_program_id, /* 62 */
3234: SYSDATE, /* 63 */
3235: fnd_global.prog_appl_id, /* 64 */
3236: fnd_global.conc_request_id, /* 65 */

Line 3233: fnd_global.conc_program_id, /* 62 */

3229: SYSDATE, /* 58 */
3230: fnd_global.user_id, /* 59 */
3231: SYSDATE, /* 60 */
3232: fnd_global.login_id, /* 61 */
3233: fnd_global.conc_program_id, /* 62 */
3234: SYSDATE, /* 63 */
3235: fnd_global.prog_appl_id, /* 64 */
3236: fnd_global.conc_request_id, /* 65 */
3237: validLines_List(iLine).attribute_category_sl, /* 66 */

Line 3235: fnd_global.prog_appl_id, /* 64 */

3231: SYSDATE, /* 60 */
3232: fnd_global.login_id, /* 61 */
3233: fnd_global.conc_program_id, /* 62 */
3234: SYSDATE, /* 63 */
3235: fnd_global.prog_appl_id, /* 64 */
3236: fnd_global.conc_request_id, /* 65 */
3237: validLines_List(iLine).attribute_category_sl, /* 66 */
3238: validLines_List(iLine).attribute1_sl, /* 67 */
3239: validLines_List(iLine).attribute2_sl, /* 68 */

Line 3236: fnd_global.conc_request_id, /* 65 */

3232: fnd_global.login_id, /* 61 */
3233: fnd_global.conc_program_id, /* 62 */
3234: SYSDATE, /* 63 */
3235: fnd_global.prog_appl_id, /* 64 */
3236: fnd_global.conc_request_id, /* 65 */
3237: validLines_List(iLine).attribute_category_sl, /* 66 */
3238: validLines_List(iLine).attribute1_sl, /* 67 */
3239: validLines_List(iLine).attribute2_sl, /* 68 */
3240: validLines_List(iLine).attribute3_sl, /* 69 */

Line 3310: last_updated_by = fnd_global.user_id, /* 57 */

3306: org_id = validLines_List(iLine).org_id, /* 53 */
3307: ship_line_int_id = validLines_List(iLine).ship_line_int_id, /* 54 */
3308: interface_source_table = validLines_List(iLine).interface_source_table, /* 55 */
3309: interface_source_line_id = validLines_List(iLine).interface_source_line_id, /* 56 */
3310: last_updated_by = fnd_global.user_id, /* 57 */
3311: last_update_date = SYSDATE, /* 58 */
3312: last_update_login = fnd_global.login_id, /* 59 */
3313: program_id = fnd_global.conc_program_id, /* 60 */
3314: program_update_date = SYSDATE, /* 61 */

Line 3312: last_update_login = fnd_global.login_id, /* 59 */

3308: interface_source_table = validLines_List(iLine).interface_source_table, /* 55 */
3309: interface_source_line_id = validLines_List(iLine).interface_source_line_id, /* 56 */
3310: last_updated_by = fnd_global.user_id, /* 57 */
3311: last_update_date = SYSDATE, /* 58 */
3312: last_update_login = fnd_global.login_id, /* 59 */
3313: program_id = fnd_global.conc_program_id, /* 60 */
3314: program_update_date = SYSDATE, /* 61 */
3315: program_application_id = fnd_global.prog_appl_id, /* 62 */
3316: request_id = fnd_global.conc_request_id, /* 63 */

Line 3313: program_id = fnd_global.conc_program_id, /* 60 */

3309: interface_source_line_id = validLines_List(iLine).interface_source_line_id, /* 56 */
3310: last_updated_by = fnd_global.user_id, /* 57 */
3311: last_update_date = SYSDATE, /* 58 */
3312: last_update_login = fnd_global.login_id, /* 59 */
3313: program_id = fnd_global.conc_program_id, /* 60 */
3314: program_update_date = SYSDATE, /* 61 */
3315: program_application_id = fnd_global.prog_appl_id, /* 62 */
3316: request_id = fnd_global.conc_request_id, /* 63 */
3317: attribute_category = validLines_List(iLine).attribute_category_sl, /* 64 */

Line 3315: program_application_id = fnd_global.prog_appl_id, /* 62 */

3311: last_update_date = SYSDATE, /* 58 */
3312: last_update_login = fnd_global.login_id, /* 59 */
3313: program_id = fnd_global.conc_program_id, /* 60 */
3314: program_update_date = SYSDATE, /* 61 */
3315: program_application_id = fnd_global.prog_appl_id, /* 62 */
3316: request_id = fnd_global.conc_request_id, /* 63 */
3317: attribute_category = validLines_List(iLine).attribute_category_sl, /* 64 */
3318: attribute1 = validLines_List(iLine).attribute1_sl, /* 65 */
3319: attribute2 = validLines_List(iLine).attribute2_sl, /* 66 */

Line 3316: request_id = fnd_global.conc_request_id, /* 63 */

3312: last_update_login = fnd_global.login_id, /* 59 */
3313: program_id = fnd_global.conc_program_id, /* 60 */
3314: program_update_date = SYSDATE, /* 61 */
3315: program_application_id = fnd_global.prog_appl_id, /* 62 */
3316: request_id = fnd_global.conc_request_id, /* 63 */
3317: attribute_category = validLines_List(iLine).attribute_category_sl, /* 64 */
3318: attribute1 = validLines_List(iLine).attribute1_sl, /* 65 */
3319: attribute2 = validLines_List(iLine).attribute2_sl, /* 66 */
3320: attribute3 = validLines_List(iLine).attribute3_sl, /* 67 */

Line 3347: request_id = fnd_global.conc_request_id ,

3343: UPDATE inl_ship_lines_int
3344: SET processing_status_code = 'COMPLETED' ,
3345: ship_header_id = headersToProcess_List(iHead).ship_header_id,
3346: ship_line_id = l_ship_line_id ,
3347: request_id = fnd_global.conc_request_id ,
3348: last_updated_by = fnd_global.user_id ,
3349: last_update_date = SYSDATE ,
3350: last_update_login = fnd_global.login_id ,
3351: program_id = fnd_global.conc_program_id ,

Line 3348: last_updated_by = fnd_global.user_id ,

3344: SET processing_status_code = 'COMPLETED' ,
3345: ship_header_id = headersToProcess_List(iHead).ship_header_id,
3346: ship_line_id = l_ship_line_id ,
3347: request_id = fnd_global.conc_request_id ,
3348: last_updated_by = fnd_global.user_id ,
3349: last_update_date = SYSDATE ,
3350: last_update_login = fnd_global.login_id ,
3351: program_id = fnd_global.conc_program_id ,
3352: program_update_date = SYSDATE ,

Line 3350: last_update_login = fnd_global.login_id ,

3346: ship_line_id = l_ship_line_id ,
3347: request_id = fnd_global.conc_request_id ,
3348: last_updated_by = fnd_global.user_id ,
3349: last_update_date = SYSDATE ,
3350: last_update_login = fnd_global.login_id ,
3351: program_id = fnd_global.conc_program_id ,
3352: program_update_date = SYSDATE ,
3353: program_application_id = fnd_global.prog_appl_id
3354: WHERE ship_line_int_id = validLines_List(iLine).ship_line_int_id;

Line 3351: program_id = fnd_global.conc_program_id ,

3347: request_id = fnd_global.conc_request_id ,
3348: last_updated_by = fnd_global.user_id ,
3349: last_update_date = SYSDATE ,
3350: last_update_login = fnd_global.login_id ,
3351: program_id = fnd_global.conc_program_id ,
3352: program_update_date = SYSDATE ,
3353: program_application_id = fnd_global.prog_appl_id
3354: WHERE ship_line_int_id = validLines_List(iLine).ship_line_int_id;
3355: END LOOP;

Line 3353: program_application_id = fnd_global.prog_appl_id

3349: last_update_date = SYSDATE ,
3350: last_update_login = fnd_global.login_id ,
3351: program_id = fnd_global.conc_program_id ,
3352: program_update_date = SYSDATE ,
3353: program_application_id = fnd_global.prog_appl_id
3354: WHERE ship_line_int_id = validLines_List(iLine).ship_line_int_id;
3355: END LOOP;
3356: END IF;
3357: END LOOP;

Line 4107: fnd_global.conc_program_id ,

4103: matchAmountsToProcess_List(iMatch).matched_curr_conversion_type ,
4104: matchAmountsToProcess_List(iMatch).matched_curr_conversion_date ,
4105: matchAmountsToProcess_List(iMatch).matched_curr_conversion_rate ,
4106: matchAmountsToProcess_List(iMatch).match_amount_int_id ,
4107: fnd_global.conc_program_id ,
4108: SYSDATE ,
4109: fnd_global.prog_appl_id ,
4110: fnd_global.conc_request_id ,
4111: fnd_global.user_id ,

Line 4109: fnd_global.prog_appl_id ,

4105: matchAmountsToProcess_List(iMatch).matched_curr_conversion_rate ,
4106: matchAmountsToProcess_List(iMatch).match_amount_int_id ,
4107: fnd_global.conc_program_id ,
4108: SYSDATE ,
4109: fnd_global.prog_appl_id ,
4110: fnd_global.conc_request_id ,
4111: fnd_global.user_id ,
4112: SYSDATE ,
4113: fnd_global.user_id ,

Line 4110: fnd_global.conc_request_id ,

4106: matchAmountsToProcess_List(iMatch).match_amount_int_id ,
4107: fnd_global.conc_program_id ,
4108: SYSDATE ,
4109: fnd_global.prog_appl_id ,
4110: fnd_global.conc_request_id ,
4111: fnd_global.user_id ,
4112: SYSDATE ,
4113: fnd_global.user_id ,
4114: SYSDATE ,

Line 4111: fnd_global.user_id ,

4107: fnd_global.conc_program_id ,
4108: SYSDATE ,
4109: fnd_global.prog_appl_id ,
4110: fnd_global.conc_request_id ,
4111: fnd_global.user_id ,
4112: SYSDATE ,
4113: fnd_global.user_id ,
4114: SYSDATE ,
4115: fnd_global.login_id

Line 4113: fnd_global.user_id ,

4109: fnd_global.prog_appl_id ,
4110: fnd_global.conc_request_id ,
4111: fnd_global.user_id ,
4112: SYSDATE ,
4113: fnd_global.user_id ,
4114: SYSDATE ,
4115: fnd_global.login_id
4116: );
4117: END IF;

Line 4115: fnd_global.login_id

4111: fnd_global.user_id ,
4112: SYSDATE ,
4113: fnd_global.user_id ,
4114: SYSDATE ,
4115: fnd_global.login_id
4116: );
4117: END IF;
4118: l_debug_info := 'Set Shipment Line Interface status and imported Ids';
4119: INL_LOGGING_PVT.Log_Statement(

Line 4128: m.request_id = fnd_global.conc_request_id,

4124: -- Set processing status to COMPLETED for
4125: -- the current and imported Match Line
4126: UPDATE inl_match_Amounts_int m
4127: SET m.processing_status_code = 'COMPLETED' ,
4128: m.request_id = fnd_global.conc_request_id,
4129: m.last_updated_by = fnd_global.user_id ,
4130: m.last_update_date = SYSDATE ,
4131: m.last_update_login = fnd_global.login_id ,
4132: m.program_id = fnd_global.conc_program_id,

Line 4129: m.last_updated_by = fnd_global.user_id ,

4125: -- the current and imported Match Line
4126: UPDATE inl_match_Amounts_int m
4127: SET m.processing_status_code = 'COMPLETED' ,
4128: m.request_id = fnd_global.conc_request_id,
4129: m.last_updated_by = fnd_global.user_id ,
4130: m.last_update_date = SYSDATE ,
4131: m.last_update_login = fnd_global.login_id ,
4132: m.program_id = fnd_global.conc_program_id,
4133: m.program_update_date = SYSDATE ,

Line 4131: m.last_update_login = fnd_global.login_id ,

4127: SET m.processing_status_code = 'COMPLETED' ,
4128: m.request_id = fnd_global.conc_request_id,
4129: m.last_updated_by = fnd_global.user_id ,
4130: m.last_update_date = SYSDATE ,
4131: m.last_update_login = fnd_global.login_id ,
4132: m.program_id = fnd_global.conc_program_id,
4133: m.program_update_date = SYSDATE ,
4134: m.program_application_id = fnd_global.prog_appl_id
4135: WHERE m.match_Amount_int_id = matchAmountsToProcess_List(iMatch).match_Amount_int_id;

Line 4132: m.program_id = fnd_global.conc_program_id,

4128: m.request_id = fnd_global.conc_request_id,
4129: m.last_updated_by = fnd_global.user_id ,
4130: m.last_update_date = SYSDATE ,
4131: m.last_update_login = fnd_global.login_id ,
4132: m.program_id = fnd_global.conc_program_id,
4133: m.program_update_date = SYSDATE ,
4134: m.program_application_id = fnd_global.prog_appl_id
4135: WHERE m.match_Amount_int_id = matchAmountsToProcess_List(iMatch).match_Amount_int_id;
4136: END LOOP;

Line 4134: m.program_application_id = fnd_global.prog_appl_id

4130: m.last_update_date = SYSDATE ,
4131: m.last_update_login = fnd_global.login_id ,
4132: m.program_id = fnd_global.conc_program_id,
4133: m.program_update_date = SYSDATE ,
4134: m.program_application_id = fnd_global.prog_appl_id
4135: WHERE m.match_Amount_int_id = matchAmountsToProcess_List(iMatch).match_Amount_int_id;
4136: END LOOP;
4137: END IF;
4138:

Line 4303: fnd_global.conc_program_id , /* 27 */

4299: WHERE ima.match_amount_int_id =
4300: matchesToProcess_List(iMatch).match_amount_int_id)
4301: ), /* 25 */
4302: matchesToProcess_List(iMatch).match_int_id , /* 26 */
4303: fnd_global.conc_program_id , /* 27 */
4304: SYSDATE , /* 28 */
4305: fnd_global.prog_appl_id , /* 29 */
4306: fnd_global.conc_request_id , /* 30 */
4307: fnd_global.user_id , /* 31 */

Line 4305: fnd_global.prog_appl_id , /* 29 */

4301: ), /* 25 */
4302: matchesToProcess_List(iMatch).match_int_id , /* 26 */
4303: fnd_global.conc_program_id , /* 27 */
4304: SYSDATE , /* 28 */
4305: fnd_global.prog_appl_id , /* 29 */
4306: fnd_global.conc_request_id , /* 30 */
4307: fnd_global.user_id , /* 31 */
4308: SYSDATE , /* 32 */
4309: fnd_global.user_id , /* 33 */

Line 4306: fnd_global.conc_request_id , /* 30 */

4302: matchesToProcess_List(iMatch).match_int_id , /* 26 */
4303: fnd_global.conc_program_id , /* 27 */
4304: SYSDATE , /* 28 */
4305: fnd_global.prog_appl_id , /* 29 */
4306: fnd_global.conc_request_id , /* 30 */
4307: fnd_global.user_id , /* 31 */
4308: SYSDATE , /* 32 */
4309: fnd_global.user_id , /* 33 */
4310: SYSDATE , /* 34 */

Line 4307: fnd_global.user_id , /* 31 */

4303: fnd_global.conc_program_id , /* 27 */
4304: SYSDATE , /* 28 */
4305: fnd_global.prog_appl_id , /* 29 */
4306: fnd_global.conc_request_id , /* 30 */
4307: fnd_global.user_id , /* 31 */
4308: SYSDATE , /* 32 */
4309: fnd_global.user_id , /* 33 */
4310: SYSDATE , /* 34 */
4311: fnd_global.login_id /* 35 */

Line 4309: fnd_global.user_id , /* 33 */

4305: fnd_global.prog_appl_id , /* 29 */
4306: fnd_global.conc_request_id , /* 30 */
4307: fnd_global.user_id , /* 31 */
4308: SYSDATE , /* 32 */
4309: fnd_global.user_id , /* 33 */
4310: SYSDATE , /* 34 */
4311: fnd_global.login_id /* 35 */
4312: );
4313: -- Set Shipment Header's pending_matching_flag to 'Y'

Line 4311: fnd_global.login_id /* 35 */

4307: fnd_global.user_id , /* 31 */
4308: SYSDATE , /* 32 */
4309: fnd_global.user_id , /* 33 */
4310: SYSDATE , /* 34 */
4311: fnd_global.login_id /* 35 */
4312: );
4313: -- Set Shipment Header's pending_matching_flag to 'Y'
4314: l_debug_info := 'Set LCM Shipment pending_matching_flag to Y';
4315: INL_LOGGING_PVT.Log_Statement(

Line 4323: sH.request_id = fnd_global.conc_request_id,

4319: );
4320: -- Set Pending Matching Flag = 'Y' to the current Shipment Header
4321: UPDATE inl_ship_headers sH
4322: SET sH.pending_matching_flag = 'Y',
4323: sH.request_id = fnd_global.conc_request_id,
4324: sH.last_updated_by = fnd_global.user_id,
4325: sH.last_update_date = SYSDATE,
4326: sH.last_update_login = fnd_global.login_id,
4327: sH.program_id = fnd_global.conc_program_id,

Line 4324: sH.last_updated_by = fnd_global.user_id,

4320: -- Set Pending Matching Flag = 'Y' to the current Shipment Header
4321: UPDATE inl_ship_headers sH
4322: SET sH.pending_matching_flag = 'Y',
4323: sH.request_id = fnd_global.conc_request_id,
4324: sH.last_updated_by = fnd_global.user_id,
4325: sH.last_update_date = SYSDATE,
4326: sH.last_update_login = fnd_global.login_id,
4327: sH.program_id = fnd_global.conc_program_id,
4328: sH.program_update_date = SYSDATE,

Line 4326: sH.last_update_login = fnd_global.login_id,

4322: SET sH.pending_matching_flag = 'Y',
4323: sH.request_id = fnd_global.conc_request_id,
4324: sH.last_updated_by = fnd_global.user_id,
4325: sH.last_update_date = SYSDATE,
4326: sH.last_update_login = fnd_global.login_id,
4327: sH.program_id = fnd_global.conc_program_id,
4328: sH.program_update_date = SYSDATE,
4329: sH.program_application_id = fnd_global.prog_appl_id
4330: WHERE sH.ship_header_id = l_ship_header_id

Line 4327: sH.program_id = fnd_global.conc_program_id,

4323: sH.request_id = fnd_global.conc_request_id,
4324: sH.last_updated_by = fnd_global.user_id,
4325: sH.last_update_date = SYSDATE,
4326: sH.last_update_login = fnd_global.login_id,
4327: sH.program_id = fnd_global.conc_program_id,
4328: sH.program_update_date = SYSDATE,
4329: sH.program_application_id = fnd_global.prog_appl_id
4330: WHERE sH.ship_header_id = l_ship_header_id
4331: ;

Line 4329: sH.program_application_id = fnd_global.prog_appl_id

4325: sH.last_update_date = SYSDATE,
4326: sH.last_update_login = fnd_global.login_id,
4327: sH.program_id = fnd_global.conc_program_id,
4328: sH.program_update_date = SYSDATE,
4329: sH.program_application_id = fnd_global.prog_appl_id
4330: WHERE sH.ship_header_id = l_ship_header_id
4331: ;
4332: END IF;
4333: l_debug_info := 'Set Shipment Line Interface status and imported Ids';

Line 4343: m.request_id = fnd_global.conc_request_id,

4339: -- Set processing status to COMPLETED for
4340: -- the current and imported Match Line
4341: UPDATE inl_matches_int m
4342: SET m.processing_status_code = 'COMPLETED' ,
4343: m.request_id = fnd_global.conc_request_id,
4344: m.last_updated_by = fnd_global.user_id ,
4345: m.last_update_date = SYSDATE ,
4346: m.last_update_login = fnd_global.login_id ,
4347: m.program_id = fnd_global.conc_program_id,

Line 4344: m.last_updated_by = fnd_global.user_id ,

4340: -- the current and imported Match Line
4341: UPDATE inl_matches_int m
4342: SET m.processing_status_code = 'COMPLETED' ,
4343: m.request_id = fnd_global.conc_request_id,
4344: m.last_updated_by = fnd_global.user_id ,
4345: m.last_update_date = SYSDATE ,
4346: m.last_update_login = fnd_global.login_id ,
4347: m.program_id = fnd_global.conc_program_id,
4348: m.program_update_date = SYSDATE ,

Line 4346: m.last_update_login = fnd_global.login_id ,

4342: SET m.processing_status_code = 'COMPLETED' ,
4343: m.request_id = fnd_global.conc_request_id,
4344: m.last_updated_by = fnd_global.user_id ,
4345: m.last_update_date = SYSDATE ,
4346: m.last_update_login = fnd_global.login_id ,
4347: m.program_id = fnd_global.conc_program_id,
4348: m.program_update_date = SYSDATE ,
4349: m.program_application_id = fnd_global.prog_appl_id
4350: WHERE m.match_int_id = matchesToProcess_List(iMatch) .match_int_id;

Line 4347: m.program_id = fnd_global.conc_program_id,

4343: m.request_id = fnd_global.conc_request_id,
4344: m.last_updated_by = fnd_global.user_id ,
4345: m.last_update_date = SYSDATE ,
4346: m.last_update_login = fnd_global.login_id ,
4347: m.program_id = fnd_global.conc_program_id,
4348: m.program_update_date = SYSDATE ,
4349: m.program_application_id = fnd_global.prog_appl_id
4350: WHERE m.match_int_id = matchesToProcess_List(iMatch) .match_int_id;
4351: END LOOP;

Line 4349: m.program_application_id = fnd_global.prog_appl_id

4345: m.last_update_date = SYSDATE ,
4346: m.last_update_login = fnd_global.login_id ,
4347: m.program_id = fnd_global.conc_program_id,
4348: m.program_update_date = SYSDATE ,
4349: m.program_application_id = fnd_global.prog_appl_id
4350: WHERE m.match_int_id = matchesToProcess_List(iMatch) .match_int_id;
4351: END LOOP;
4352: END IF;
4353: -- Standard End of Procedure/Function Logging

Line 4637: request_id = fnd_global.conc_request_id ,

4633: poa_party_id = toDeriveLines_list(i) .poa_party_id ,
4634: poa_party_site_id = toDeriveLines_list(i) .poa_party_site_id ,
4635: poo_organization_id = toDeriveLines_list(i) .poo_organization_id ,
4636: poo_location_id = toDeriveLines_list(i) .poo_location_id ,
4637: request_id = fnd_global.conc_request_id ,
4638: last_updated_by = fnd_global.user_id ,
4639: last_update_date = SYSDATE ,
4640: last_update_login = fnd_global.login_id ,
4641: program_id = fnd_global.conc_program_id ,

Line 4638: last_updated_by = fnd_global.user_id ,

4634: poa_party_site_id = toDeriveLines_list(i) .poa_party_site_id ,
4635: poo_organization_id = toDeriveLines_list(i) .poo_organization_id ,
4636: poo_location_id = toDeriveLines_list(i) .poo_location_id ,
4637: request_id = fnd_global.conc_request_id ,
4638: last_updated_by = fnd_global.user_id ,
4639: last_update_date = SYSDATE ,
4640: last_update_login = fnd_global.login_id ,
4641: program_id = fnd_global.conc_program_id ,
4642: program_update_date = SYSDATE ,

Line 4640: last_update_login = fnd_global.login_id ,

4636: poo_location_id = toDeriveLines_list(i) .poo_location_id ,
4637: request_id = fnd_global.conc_request_id ,
4638: last_updated_by = fnd_global.user_id ,
4639: last_update_date = SYSDATE ,
4640: last_update_login = fnd_global.login_id ,
4641: program_id = fnd_global.conc_program_id ,
4642: program_update_date = SYSDATE ,
4643: program_application_id = fnd_global.prog_appl_id
4644: WHERE ship_line_int_id = toDeriveLines_list(i) .ship_line_int_id;

Line 4641: program_id = fnd_global.conc_program_id ,

4637: request_id = fnd_global.conc_request_id ,
4638: last_updated_by = fnd_global.user_id ,
4639: last_update_date = SYSDATE ,
4640: last_update_login = fnd_global.login_id ,
4641: program_id = fnd_global.conc_program_id ,
4642: program_update_date = SYSDATE ,
4643: program_application_id = fnd_global.prog_appl_id
4644: WHERE ship_line_int_id = toDeriveLines_list(i) .ship_line_int_id;
4645: END IF;

Line 4643: program_application_id = fnd_global.prog_appl_id

4639: last_update_date = SYSDATE ,
4640: last_update_login = fnd_global.login_id ,
4641: program_id = fnd_global.conc_program_id ,
4642: program_update_date = SYSDATE ,
4643: program_application_id = fnd_global.prog_appl_id
4644: WHERE ship_line_int_id = toDeriveLines_list(i) .ship_line_int_id;
4645: END IF;
4646: END LOOP;
4647: END IF;

Line 7800: request_id = fnd_global.conc_request_id ,

7796: UPDATE inl_matches_int
7797: SET processing_status_code = 'RUNNING' ,
7798: party_id = match_int_list(i).party_id ,
7799: party_site_id = match_int_list(i).party_site_id,
7800: request_id = fnd_global.conc_request_id ,
7801: last_updated_by = fnd_global.user_id ,
7802: last_update_date = SYSDATE ,
7803: last_update_login = fnd_global.login_id ,
7804: program_id = fnd_global.conc_program_id ,

Line 7801: last_updated_by = fnd_global.user_id ,

7797: SET processing_status_code = 'RUNNING' ,
7798: party_id = match_int_list(i).party_id ,
7799: party_site_id = match_int_list(i).party_site_id,
7800: request_id = fnd_global.conc_request_id ,
7801: last_updated_by = fnd_global.user_id ,
7802: last_update_date = SYSDATE ,
7803: last_update_login = fnd_global.login_id ,
7804: program_id = fnd_global.conc_program_id ,
7805: program_update_date = SYSDATE ,

Line 7803: last_update_login = fnd_global.login_id ,

7799: party_site_id = match_int_list(i).party_site_id,
7800: request_id = fnd_global.conc_request_id ,
7801: last_updated_by = fnd_global.user_id ,
7802: last_update_date = SYSDATE ,
7803: last_update_login = fnd_global.login_id ,
7804: program_id = fnd_global.conc_program_id ,
7805: program_update_date = SYSDATE ,
7806: program_application_id = fnd_global.prog_appl_id
7807: WHERE match_int_id = match_int_list(i).match_int_id;

Line 7804: program_id = fnd_global.conc_program_id ,

7800: request_id = fnd_global.conc_request_id ,
7801: last_updated_by = fnd_global.user_id ,
7802: last_update_date = SYSDATE ,
7803: last_update_login = fnd_global.login_id ,
7804: program_id = fnd_global.conc_program_id ,
7805: program_update_date = SYSDATE ,
7806: program_application_id = fnd_global.prog_appl_id
7807: WHERE match_int_id = match_int_list(i).match_int_id;
7808:

Line 7806: program_application_id = fnd_global.prog_appl_id

7802: last_update_date = SYSDATE ,
7803: last_update_login = fnd_global.login_id ,
7804: program_id = fnd_global.conc_program_id ,
7805: program_update_date = SYSDATE ,
7806: program_application_id = fnd_global.prog_appl_id
7807: WHERE match_int_id = match_int_list(i).match_int_id;
7808:
7809: END IF;
7810:

Line 7919: request_id = fnd_global.conc_request_id ,

7915: UPDATE inl_matches_int
7916: SET processing_status_code = l_processing_status_code ,
7917: party_id = match_int_list(i) .party_id ,
7918: party_site_id = match_int_list(i) .party_site_id,
7919: request_id = fnd_global.conc_request_id ,
7920: last_updated_by = fnd_global.user_id ,
7921: last_update_date = SYSDATE ,
7922: last_update_login = fnd_global.login_id ,
7923: program_id = fnd_global.conc_program_id ,

Line 7920: last_updated_by = fnd_global.user_id ,

7916: SET processing_status_code = l_processing_status_code ,
7917: party_id = match_int_list(i) .party_id ,
7918: party_site_id = match_int_list(i) .party_site_id,
7919: request_id = fnd_global.conc_request_id ,
7920: last_updated_by = fnd_global.user_id ,
7921: last_update_date = SYSDATE ,
7922: last_update_login = fnd_global.login_id ,
7923: program_id = fnd_global.conc_program_id ,
7924: program_update_date = SYSDATE ,

Line 7922: last_update_login = fnd_global.login_id ,

7918: party_site_id = match_int_list(i) .party_site_id,
7919: request_id = fnd_global.conc_request_id ,
7920: last_updated_by = fnd_global.user_id ,
7921: last_update_date = SYSDATE ,
7922: last_update_login = fnd_global.login_id ,
7923: program_id = fnd_global.conc_program_id ,
7924: program_update_date = SYSDATE ,
7925: program_application_id = fnd_global.prog_appl_id
7926: WHERE match_int_id = match_int_list(i) .match_int_id;

Line 7923: program_id = fnd_global.conc_program_id ,

7919: request_id = fnd_global.conc_request_id ,
7920: last_updated_by = fnd_global.user_id ,
7921: last_update_date = SYSDATE ,
7922: last_update_login = fnd_global.login_id ,
7923: program_id = fnd_global.conc_program_id ,
7924: program_update_date = SYSDATE ,
7925: program_application_id = fnd_global.prog_appl_id
7926: WHERE match_int_id = match_int_list(i) .match_int_id;
7927: END IF;

Line 7925: program_application_id = fnd_global.prog_appl_id

7921: last_update_date = SYSDATE ,
7922: last_update_login = fnd_global.login_id ,
7923: program_id = fnd_global.conc_program_id ,
7924: program_update_date = SYSDATE ,
7925: program_application_id = fnd_global.prog_appl_id
7926: WHERE match_int_id = match_int_list(i) .match_int_id;
7927: END IF;
7928: END LOOP;
7929: END IF;

Line 8342: request_id = fnd_global.conc_request_id,

8338: p_debug_info => l_debug_info
8339: );
8340: UPDATE inl_ship_headers_int
8341: SET processing_status_code = 'RUNNING' ,
8342: request_id = fnd_global.conc_request_id,
8343: last_updated_by = fnd_global.user_id ,
8344: last_update_date = SYSDATE ,
8345: last_update_login = fnd_global.login_id ,
8346: program_id = fnd_global.conc_program_id,

Line 8343: last_updated_by = fnd_global.user_id ,

8339: );
8340: UPDATE inl_ship_headers_int
8341: SET processing_status_code = 'RUNNING' ,
8342: request_id = fnd_global.conc_request_id,
8343: last_updated_by = fnd_global.user_id ,
8344: last_update_date = SYSDATE ,
8345: last_update_login = fnd_global.login_id ,
8346: program_id = fnd_global.conc_program_id,
8347: program_update_date = SYSDATE ,

Line 8345: last_update_login = fnd_global.login_id ,

8341: SET processing_status_code = 'RUNNING' ,
8342: request_id = fnd_global.conc_request_id,
8343: last_updated_by = fnd_global.user_id ,
8344: last_update_date = SYSDATE ,
8345: last_update_login = fnd_global.login_id ,
8346: program_id = fnd_global.conc_program_id,
8347: program_update_date = SYSDATE ,
8348: program_application_id = fnd_global.prog_appl_id
8349: WHERE ship_header_int_id = l_ship_header_int_id;

Line 8346: program_id = fnd_global.conc_program_id,

8342: request_id = fnd_global.conc_request_id,
8343: last_updated_by = fnd_global.user_id ,
8344: last_update_date = SYSDATE ,
8345: last_update_login = fnd_global.login_id ,
8346: program_id = fnd_global.conc_program_id,
8347: program_update_date = SYSDATE ,
8348: program_application_id = fnd_global.prog_appl_id
8349: WHERE ship_header_int_id = l_ship_header_int_id;
8350: UPDATE inl_ship_lines_int

Line 8348: program_application_id = fnd_global.prog_appl_id

8344: last_update_date = SYSDATE ,
8345: last_update_login = fnd_global.login_id ,
8346: program_id = fnd_global.conc_program_id,
8347: program_update_date = SYSDATE ,
8348: program_application_id = fnd_global.prog_appl_id
8349: WHERE ship_header_int_id = l_ship_header_int_id;
8350: UPDATE inl_ship_lines_int
8351: SET processing_status_code = 'RUNNING' ,
8352: request_id = fnd_global.conc_request_id,

Line 8352: request_id = fnd_global.conc_request_id,

8348: program_application_id = fnd_global.prog_appl_id
8349: WHERE ship_header_int_id = l_ship_header_int_id;
8350: UPDATE inl_ship_lines_int
8351: SET processing_status_code = 'RUNNING' ,
8352: request_id = fnd_global.conc_request_id,
8353: last_updated_by = fnd_global.user_id ,
8354: last_update_date = SYSDATE ,
8355: last_update_login = fnd_global.login_id ,
8356: program_id = fnd_global.conc_program_id,

Line 8353: last_updated_by = fnd_global.user_id ,

8349: WHERE ship_header_int_id = l_ship_header_int_id;
8350: UPDATE inl_ship_lines_int
8351: SET processing_status_code = 'RUNNING' ,
8352: request_id = fnd_global.conc_request_id,
8353: last_updated_by = fnd_global.user_id ,
8354: last_update_date = SYSDATE ,
8355: last_update_login = fnd_global.login_id ,
8356: program_id = fnd_global.conc_program_id,
8357: program_update_date = SYSDATE ,

Line 8355: last_update_login = fnd_global.login_id ,

8351: SET processing_status_code = 'RUNNING' ,
8352: request_id = fnd_global.conc_request_id,
8353: last_updated_by = fnd_global.user_id ,
8354: last_update_date = SYSDATE ,
8355: last_update_login = fnd_global.login_id ,
8356: program_id = fnd_global.conc_program_id,
8357: program_update_date = SYSDATE ,
8358: program_application_id = fnd_global.prog_appl_id
8359: WHERE ship_header_int_id = l_ship_header_int_id

Line 8356: program_id = fnd_global.conc_program_id,

8352: request_id = fnd_global.conc_request_id,
8353: last_updated_by = fnd_global.user_id ,
8354: last_update_date = SYSDATE ,
8355: last_update_login = fnd_global.login_id ,
8356: program_id = fnd_global.conc_program_id,
8357: program_update_date = SYSDATE ,
8358: program_application_id = fnd_global.prog_appl_id
8359: WHERE ship_header_int_id = l_ship_header_int_id
8360: AND processing_status_code = 'PENDING';

Line 8358: program_application_id = fnd_global.prog_appl_id

8354: last_update_date = SYSDATE ,
8355: last_update_login = fnd_global.login_id ,
8356: program_id = fnd_global.conc_program_id,
8357: program_update_date = SYSDATE ,
8358: program_application_id = fnd_global.prog_appl_id
8359: WHERE ship_header_int_id = l_ship_header_int_id
8360: AND processing_status_code = 'PENDING';
8361: ELSE
8362: l_debug_info := 'Change Interface Status Code to COMPLETED';

Line 8370: request_id = fnd_global.conc_request_id,

8366: p_debug_info => l_debug_info
8367: );
8368: UPDATE inl_ship_headers_int
8369: SET processing_status_code = 'COMPLETED' ,
8370: request_id = fnd_global.conc_request_id,
8371: last_updated_by = fnd_global.user_id ,
8372: last_update_date = SYSDATE ,
8373: last_update_login = fnd_global.login_id ,
8374: program_id = fnd_global.conc_program_id,

Line 8371: last_updated_by = fnd_global.user_id ,

8367: );
8368: UPDATE inl_ship_headers_int
8369: SET processing_status_code = 'COMPLETED' ,
8370: request_id = fnd_global.conc_request_id,
8371: last_updated_by = fnd_global.user_id ,
8372: last_update_date = SYSDATE ,
8373: last_update_login = fnd_global.login_id ,
8374: program_id = fnd_global.conc_program_id,
8375: program_update_date = SYSDATE ,

Line 8373: last_update_login = fnd_global.login_id ,

8369: SET processing_status_code = 'COMPLETED' ,
8370: request_id = fnd_global.conc_request_id,
8371: last_updated_by = fnd_global.user_id ,
8372: last_update_date = SYSDATE ,
8373: last_update_login = fnd_global.login_id ,
8374: program_id = fnd_global.conc_program_id,
8375: program_update_date = SYSDATE ,
8376: program_application_id = fnd_global.prog_appl_id
8377: WHERE ship_header_int_id = l_ship_header_int_id;

Line 8374: program_id = fnd_global.conc_program_id,

8370: request_id = fnd_global.conc_request_id,
8371: last_updated_by = fnd_global.user_id ,
8372: last_update_date = SYSDATE ,
8373: last_update_login = fnd_global.login_id ,
8374: program_id = fnd_global.conc_program_id,
8375: program_update_date = SYSDATE ,
8376: program_application_id = fnd_global.prog_appl_id
8377: WHERE ship_header_int_id = l_ship_header_int_id;
8378: UPDATE inl_ship_lines_int

Line 8376: program_application_id = fnd_global.prog_appl_id

8372: last_update_date = SYSDATE ,
8373: last_update_login = fnd_global.login_id ,
8374: program_id = fnd_global.conc_program_id,
8375: program_update_date = SYSDATE ,
8376: program_application_id = fnd_global.prog_appl_id
8377: WHERE ship_header_int_id = l_ship_header_int_id;
8378: UPDATE inl_ship_lines_int
8379: SET processing_status_code = 'COMPLETED' ,
8380: request_id = fnd_global.conc_request_id,

Line 8380: request_id = fnd_global.conc_request_id,

8376: program_application_id = fnd_global.prog_appl_id
8377: WHERE ship_header_int_id = l_ship_header_int_id;
8378: UPDATE inl_ship_lines_int
8379: SET processing_status_code = 'COMPLETED' ,
8380: request_id = fnd_global.conc_request_id,
8381: last_updated_by = fnd_global.user_id ,
8382: last_update_date = SYSDATE ,
8383: last_update_login = fnd_global.login_id ,
8384: program_id = fnd_global.conc_program_id,

Line 8381: last_updated_by = fnd_global.user_id ,

8377: WHERE ship_header_int_id = l_ship_header_int_id;
8378: UPDATE inl_ship_lines_int
8379: SET processing_status_code = 'COMPLETED' ,
8380: request_id = fnd_global.conc_request_id,
8381: last_updated_by = fnd_global.user_id ,
8382: last_update_date = SYSDATE ,
8383: last_update_login = fnd_global.login_id ,
8384: program_id = fnd_global.conc_program_id,
8385: program_update_date = SYSDATE ,

Line 8383: last_update_login = fnd_global.login_id ,

8379: SET processing_status_code = 'COMPLETED' ,
8380: request_id = fnd_global.conc_request_id,
8381: last_updated_by = fnd_global.user_id ,
8382: last_update_date = SYSDATE ,
8383: last_update_login = fnd_global.login_id ,
8384: program_id = fnd_global.conc_program_id,
8385: program_update_date = SYSDATE ,
8386: program_application_id = fnd_global.prog_appl_id
8387: WHERE ship_header_int_id = l_ship_header_int_id

Line 8384: program_id = fnd_global.conc_program_id,

8380: request_id = fnd_global.conc_request_id,
8381: last_updated_by = fnd_global.user_id ,
8382: last_update_date = SYSDATE ,
8383: last_update_login = fnd_global.login_id ,
8384: program_id = fnd_global.conc_program_id,
8385: program_update_date = SYSDATE ,
8386: program_application_id = fnd_global.prog_appl_id
8387: WHERE ship_header_int_id = l_ship_header_int_id
8388: AND processing_status_code = 'PENDING';

Line 8386: program_application_id = fnd_global.prog_appl_id

8382: last_update_date = SYSDATE ,
8383: last_update_login = fnd_global.login_id ,
8384: program_id = fnd_global.conc_program_id,
8385: program_update_date = SYSDATE ,
8386: program_application_id = fnd_global.prog_appl_id
8387: WHERE ship_header_int_id = l_ship_header_int_id
8388: AND processing_status_code = 'PENDING';
8389: END IF;
8390: END IF;

Line 8482: AND h.request_id = fnd_global.conc_request_id;

8478: FROM inl_ship_lines_int l
8479: WHERE l.ship_header_int_id = h.ship_header_int_id
8480: AND ROWNUM < 2
8481: )
8482: AND h.request_id = fnd_global.conc_request_id;
8483:
8484: TYPE ship_hdr_list_type IS TABLE OF c_ship_headers%ROWTYPE;
8485: ship_hdr_list ship_hdr_list_type;
8486: l_proc_name CONSTANT VARCHAR2(100) := 'Run_ShipPostProcessor';