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.CSL_MATERIAL_TRANSACTION_PKG dependencies on FND_API

Line 98: , p_init_msg_list => FND_API.G_TRUE

94: -- should be undone in the wrapper hence transaction_quantity * -1
95: -- ( GG 05-FEB-2002 )
96: csp_transactions_pub.transact_material
97: ( p_api_version => 1.0
98: , p_init_msg_list => FND_API.G_TRUE
99: , p_commit => FND_API.G_FALSE
100: , px_transaction_id => l_transaction_id
101: , px_transaction_header_id => l_mat_txn_transfer_id
102: , p_inventory_item_id => p_record.inventory_item_id

Line 99: , p_commit => FND_API.G_FALSE

95: -- ( GG 05-FEB-2002 )
96: csp_transactions_pub.transact_material
97: ( p_api_version => 1.0
98: , p_init_msg_list => FND_API.G_TRUE
99: , p_commit => FND_API.G_FALSE
100: , px_transaction_id => l_transaction_id
101: , px_transaction_header_id => l_mat_txn_transfer_id
102: , p_inventory_item_id => p_record.inventory_item_id
103: , p_organization_id => p_record.organization_id

Line 127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

123: , x_msg_count => l_msg_count
124: , x_msg_data => l_msg_data
125: );
126:
127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
128: /*** exception occurred in API -> return errmsg ***/
129: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
130: (
131: p_api_error => TRUE

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
208: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
209: END IF;
210:
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END APPLY_INSERT;
213:
214: /***
215: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 233: x_return_status := FND_API.G_RET_STS_SUCCESS;

229: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
230: END IF;
231:
232: -- There is no update possible so returning SUCCESS
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: /*** exception occurred in API -> return errmsg ***/
237: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

231:
232: -- There is no update possible so returning SUCCESS
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: /*** exception occurred in API -> return errmsg ***/
237: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
238: (
239: p_api_error => TRUE

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

270: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
271: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
272: END IF;
273:
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: END APPLY_UPDATE;
276:
277: /***
278: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

284: x_return_status IN OUT NOCOPY VARCHAR2
285: ) IS
286: BEGIN
287: /*** initialize return status and message list ***/
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289: FND_MSG_PUB.INITIALIZE;
290:
291: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
292: jtm_message_log_pkg.Log_Msg

Line 341: x_return_status := FND_API.G_RET_STS_ERROR;

337: , p_token_name1 => 'DML'
338: , p_token_value1 => p_record.dmltype$$
339: );
340:
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: ELSE
343: -- invalid dml type
344: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
345: jtm_message_log_pkg.Log_Msg

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

355: , p_token_name1 => 'DML'
356: , p_token_value1 => p_record.dmltype$$
357: );
358:
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: END IF;
361:
362: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
363: jtm_message_log_pkg.Log_Msg

Line 393: x_return_status := FND_API.G_RET_STS_ERROR;

389: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
390: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
391: END IF;
392:
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: END APPLY_RECORD;
395:
396: /***
397: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item MTL_MAT_TRANSACTIONS

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

410: l_process_status VARCHAR2(1);
411: l_error_msg VARCHAR2(4000);
412: BEGIN
413: g_debug_level := p_debug_level;
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
417: jtm_message_log_pkg.Log_Msg
418: ( v_object_id => null

Line 437: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

433: , l_error_msg
434: , l_process_status
435: );
436:
437: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
438: /*** Yes -> reject record because of changed pk ***/
439: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
440: jtm_message_log_pkg.Log_Msg
441: ( v_object_id => r_material_transaction.transaction_id

Line 459: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

455: l_error_msg,
456: l_process_status
457: );
458:
459: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
460: /*** Reject successfull now rejecting matching serial/lotnumber records ***/
461: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
462: jtm_message_log_pkg.Log_Msg
463: ( v_object_id => r_material_transaction.transaction_id

Line 503: /IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN/

499: END LOOP;
500: END IF;
501:
502: /*** was record processed successfully? ***/
503: /*IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN*/
504: /*** Yes -> delete record from inqueue ***/
505: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
506: jtm_message_log_pkg.Log_Msg
507: ( v_object_id => r_material_transaction.TRANSACTION_ID

Line 526: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

522: l_process_status
523: );
524:
525: /*** was delete successful? ***/
526: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
527: /*** no -> rollback ***/
528: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
529: jtm_message_log_pkg.Log_Msg
530: ( v_object_id => r_material_transaction.TRANSACTION_ID

Line 552: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

548: l_error_msg,
549: l_process_status
550: );
551: /*** was delete successful? ***/
552: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
553: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
554: jtm_message_log_pkg.Log_Msg
555: ( v_object_id => r_lot_number.tranid$$
556: , v_object_name => g_object_name || 'MTL_TRANS_LOT_NUMBERS'

Line 590: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

586: l_error_msg,
587: l_process_status
588: );
589: /*** was delete successful? ***/
590: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
591: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
592: jtm_message_log_pkg.Log_Msg
593: ( v_object_id => r_unit_transaction.tranid$$
594: , v_object_name => g_object_name || 'MTL_UNIT_TRANSACTIONS'

Line 614: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

610: END LOOP;
611:
612: END IF;
613:
614: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
615: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
616: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
617: jtm_message_log_pkg.Log_Msg
618: ( v_object_id => r_material_transaction.TRANSACTION_ID

Line 637: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

633: , l_process_status
634: );
635:
636: /*** Was defer successful? ***/
637: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
638: /*** no -> rollback ***/
639: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
640: jtm_message_log_pkg.Log_Msg
641: ( v_object_id => r_material_transaction.TRANSACTION_ID

Line 700: x_return_status := FND_API.G_RET_STS_ERROR;

696: , v_object_name => g_object_name
697: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
698: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
699: END IF;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: END APPLY_CLIENT_CHANGES;
702:
703: END CSL_MATERIAL_TRANSACTION_PKG;