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.CSM_ORDERS_PKG dependencies on CSM_UTIL_PKG

Line 78: CSM_UTIL_PKG.LOG

74: l_src_type VARCHAR2(100);
75: l_dummy boolean;
76: BEGIN
77:
78: CSM_UTIL_PKG.LOG
79: ( 'Entering CSM_ORDERS_PKG.RECEIVE_ORDER'|| 'for PK '|| p_line_id ,
80: 'CSM_ORDERS_PKG.RECEIVE_ORDER',
81: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
82:

Line 105: CSM_UTIL_PKG.LOG

101: l_trans_items_rec_type.TO_SUBINVENTORY_CODE := r_part_line.destination_subinventory;
102: l_trans_items_rec_type.SHIPMENT_NUMBER := r_part_line.shipment_number;
103: l_trans_items_rec_type.SHIPMENT_LINE_ID := r_part_line.shipment_line_id;
104:
105: CSM_UTIL_PKG.LOG
106: ( 'Calling API CSP_TRANSACTIONS_PUB.receive_requirement_trans for PK '||p_line_id ,
107: 'CSM_ORDERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_STATEMENT ); -- put PK column here
108:
109: CSP_TRANSACTIONS_PUB.receive_requirement_trans (

Line 125: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_data IS NOT NULL OR l_msg_count<>0 THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
124: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
125: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
126: RETURN ;
127: END IF;
128:
129: CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND(r_part_line.destination_organization_id,r_part_line.destination_subinventory,

Line 150: CSM_UTIL_PKG.LOG('Leaving CSM_ORDERS_PKG.RECEIVE_ORDER for : ' || r_part_line.line_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

146: , p_timestamp => sysdate
147: );
148: END LOOP;
149: END IF;
150: CSM_UTIL_PKG.LOG('Leaving CSM_ORDERS_PKG.RECEIVE_ORDER for : ' || r_part_line.line_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
151:
152: p_result := TO_CLOB('');
153:
154: END RECEIVE_ORDER;

Line 169: CSM_UTIL_PKG.LOG

165: l_result CLOB;
166:
167: BEGIN
168:
169: CSM_UTIL_PKG.LOG
170: ( 'Entering CSM_ORDERS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.line_id ,
171: 'CSM_ORDERS_PKG.APPLY_UPDATE',
172: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
173:

Line 184: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

180: );
181:
182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
183: /*** exception occurred in API -> return errmsg ***/
184: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
185: (
186: p_api_error => TRUE
187: );
188: END IF;

Line 193: CSM_UTIL_PKG.LOG

189:
190:
191:
192:
193: CSM_UTIL_PKG.LOG
194: ( 'Leaving CSM_ORDERS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.line_id ,
195: 'CSM_ORDERS_PKG.APPLY_UPDATE',
196: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
197:

Line 201: CSM_UTIL_PKG.LOG

197:
198:
199: EXCEPTION WHEN OTHERS THEN
200:
201: CSM_UTIL_PKG.LOG
202: ( 'Exception occurred in CSM_ORDERS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
203: 'CSM_ORDERS_PKG.APPLY_UPDATE',
204: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
205:

Line 208: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

204: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
205:
206:
207: fnd_msg_pub.Add_Exc_Msg( 'CSM_ORDERS_PKG', 'APPLY_UPDATE', sqlerrm);
208: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
209: (
210: p_api_error => TRUE
211: );
212:

Line 232: CSM_UTIL_PKG.LOG

228: x_return_status := FND_API.G_RET_STS_SUCCESS;
229:
230: FND_MSG_PUB.INITIALIZE;
231:
232: CSM_UTIL_PKG.LOG
233: ( 'Entering CSM_ORDERS_PKG.APPLY_RECORD'|| 'for PK '||p_record.line_id,
234: 'CSM_ORDERS_PKG.APPLY_RECORD',
235: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
236:

Line 237: CSM_UTIL_PKG.LOG

233: ( 'Entering CSM_ORDERS_PKG.APPLY_RECORD'|| 'for PK '||p_record.line_id,
234: 'CSM_ORDERS_PKG.APPLY_RECORD',
235: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
236:
237: CSM_UTIL_PKG.LOG
238: ( 'Processing order '|| 'for PK '||p_record.line_id ||'DMLTYPE = ' || p_record.dmltype$$,
239: 'CSM_ORDERS_PKG.APPLY_RECORD',
240: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
241:

Line 254: CSM_UTIL_PKG.LOG

250: );
251: ELSE
252: -- invalid dml type
253:
254: CSM_UTIL_PKG.LOG
255: ( 'Invalid or unsupported DML type: ' || p_record.dmltype$$|| 'for PK '||p_record.line_id,
256: 'CSM_ORDERS_PKG.APPLY_RECORD',
257: FND_LOG.LEVEL_ERROR ); -- put PK column here
258:

Line 259: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

255: ( 'Invalid or unsupported DML type: ' || p_record.dmltype$$|| 'for PK '||p_record.line_id,
256: 'CSM_ORDERS_PKG.APPLY_RECORD',
257: FND_LOG.LEVEL_ERROR ); -- put PK column here
258:
259: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
260: (
261: p_message => 'CSM_DML_OPERATION'
262: , p_token_name1 => 'DML'
263: , p_token_value1 => p_record.dmltype$$

Line 269: CSM_UTIL_PKG.LOG

265:
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: END IF;
268:
269: CSM_UTIL_PKG.LOG
270: ( 'Leaving CSM_ORDERS_PKG.APPLY_RECORD'|| 'for PK '||p_record.line_id,
271: 'CSM_ORDERS_PKG.APPLY_RECORD',
272: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
273:

Line 276: CSM_UTIL_PKG.LOG

272: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
273:
274: EXCEPTION WHEN OTHERS THEN
275: /*** defer record when any process exception occurs ***/
276: CSM_UTIL_PKG.LOG
277: ( 'Exception occurred in CSM_ORDERS_PKG.APPLY_RECORD'|| 'for PK '||p_record.line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
278: 'CSM_ORDERS_PKG.APPLY_RECORD',
279: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
280:

Line 283: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

279: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
280:
281:
282: fnd_msg_pub.Add_Exc_Msg( 'CSM_ORDERS_PKG', 'APPLY_RECORD', sqlerrm);
283: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
284: (
285: p_api_error => TRUE
286: );
287:

Line 311: CSM_UTIL_PKG.LOG

307: l_reject_row boolean;
308: l_return_status VARCHAR2(1);
309: BEGIN
310:
311: CSM_UTIL_PKG.LOG
312: ( 'Entering CSM_ORDERS_PKG.APPLY CLIENT CHANGES',
313: 'CSM_ORDERS_PKG.APPLY_CLIENT_CHANGES',
314: p_debug_level); -- put PK column here
315:

Line 338: CSM_UTIL_PKG.REJECT_RECORD

334: /*** was record processed successfully? ***/
335: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
336: /*** If Yes -> delete record from inqueue ***/
337: IF l_reject_row THEN
338: CSM_UTIL_PKG.REJECT_RECORD
339: (
340: p_user_name,
341: p_tranid,
342: r_order_lines.seqno$$,

Line 350: CSM_UTIL_PKG.DELETE_RECORD

346: l_error_msg,
347: l_return_status
348: );
349: ELSE
350: CSM_UTIL_PKG.DELETE_RECORD
351: (
352: p_user_name,
353: p_tranid,
354: r_order_lines.seqno$$,

Line 366: CSM_UTIL_PKG.LOG

362:
363: /*** was delete/reject successful? ***/
364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
365: /*** If No -> rollback ***/
366: CSM_UTIL_PKG.LOG
367: ( 'Deleting from inqueue failed, rolling back to savepoint'
368: || ' for PK ' || r_order_lines.line_id ,
369: g_object_name || '.APPLY_CLIENT_CHANGES',
370: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 379: CSM_UTIL_PKG.LOG

375:
376: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
377: /*** Record was not processed successfully or delete failed
378: -> defer and reject record ***/
379: CSM_UTIL_PKG.LOG
380: ( 'Record not processed successfully, deferring and rejecting record'
381: || ' for PK ' || r_order_lines.line_id ,
382: g_object_name || '.APPLY_CLIENT_CHANGES',
383: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 385: CSM_UTIL_PKG.DEFER_RECORD

381: || ' for PK ' || r_order_lines.line_id ,
382: g_object_name || '.APPLY_CLIENT_CHANGES',
383: FND_LOG.LEVEL_ERROR); -- put PK column here
384:
385: CSM_UTIL_PKG.DEFER_RECORD
386: ( p_user_name
387: , p_tranid
388: , r_order_lines.seqno$$
389: , r_order_lines.line_id

Line 400: CSM_UTIL_PKG.LOG

396:
397: /*** Was defer successful? ***/
398: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
399: /*** no -> rollback ***/
400: CSM_UTIL_PKG.LOG
401: ( 'Defer record failed, rolling back to savepoint'
402: || ' for PK ' || r_order_lines.line_id ,
403: g_object_name || '.APPLY_CLIENT_CHANGES',
404: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 412: CSM_UTIL_PKG.LOG

408: END IF;
409:
410: END LOOP;
411:
412: CSM_UTIL_PKG.LOG
413: ( 'Leaving CSM_ORDERS_PKG.APPLY CLIENT CHANGES',
414: 'CSM_ORDERS_PKG.APPLY_CLIENT_CHANGES',
415: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
416: