DBA Data[Home] [Help]

APPS.CSM_MATERIAL_TRANSACTION_PKG dependencies on FND_API

Line 95: , p_init_msg_list => FND_API.G_TRUE

91: -- same behaviour as when the record comes from apps. This inversion
92: -- should be undone in the wrapper hence transaction_quantity * -1
93: csp_transactions_pub.transact_material
94: ( p_api_version => 1.0
95: , p_init_msg_list => FND_API.G_TRUE
96: , p_commit => FND_API.G_FALSE
97: , px_transaction_id => l_transaction_id
98: , px_transaction_header_id => l_mat_txn_transfer_id
99: , p_inventory_item_id => p_record.inventory_item_id

Line 96: , p_commit => FND_API.G_FALSE

92: -- should be undone in the wrapper hence transaction_quantity * -1
93: csp_transactions_pub.transact_material
94: ( p_api_version => 1.0
95: , p_init_msg_list => FND_API.G_TRUE
96: , p_commit => FND_API.G_FALSE
97: , px_transaction_id => l_transaction_id
98: , px_transaction_header_id => l_mat_txn_transfer_id
99: , p_inventory_item_id => p_record.inventory_item_id
100: , p_organization_id => p_record.organization_id

Line 124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

120: , x_msg_count => l_msg_count
121: , x_msg_data => l_msg_data
122: );
123:
124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
125: /*** exception occurred in API -> return errmsg ***/
126: CSM_UTIL_PKG.LOG
127: ( module => g_object_name
128: , message => 'transaction_id ' || l_transaction_id || ' errored out with msg: ' || l_msg_data

Line 154: x_return_status := FND_API.G_RET_STS_ERROR;

150: (
151: p_api_error => TRUE
152: );
153:
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: END APPLY_INSERT;
156:
157: /***
158: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 173: x_return_status := FND_API.G_RET_STS_SUCCESS;

169: , message => p_record.TRANSACTION_ID || ' Entering ' || g_object_name || '.APPLY_UPDATE'
170: , log_level => FND_LOG.LEVEL_STATEMENT);
171:
172: -- There is no update possible so returning SUCCESS
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: CSM_UTIL_PKG.LOG
176: ( module => g_object_name
177: , message => p_record.TRANSACTION_ID || ' Leaving ' || g_object_name || '.APPLY_UPDATE'

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188: (
189: p_api_error => TRUE
190: );
191:
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END APPLY_UPDATE;
194:
195: /***
196: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 206: x_return_status := FND_API.G_RET_STS_SUCCESS;

202: x_return_status IN OUT NOCOPY VARCHAR2
203: ) IS
204: BEGIN
205: /*** initialize return status and message list ***/
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207: FND_MSG_PUB.INITIALIZE;
208:
209: CSM_UTIL_PKG.LOG
210: ( module => g_object_name

Line 237: x_return_status := FND_API.G_RET_STS_ERROR;

233: , p_token_name1 => 'DML'
234: , p_token_value1 => p_record.dmltype$$
235: );
236:
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: END IF;
239:
240: CSM_UTIL_PKG.LOG
241: ( module => g_object_name

Line 258: x_return_status := FND_API.G_RET_STS_ERROR;

254: (
255: p_api_error => TRUE
256: );
257:
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: END APPLY_RECORD;
260:
261: /***
262: This procedure is called by CSM_UTIL_PKG when publication item MTL_MAT_TRANSACTIONS

Line 278: x_return_status := FND_API.G_RET_STS_SUCCESS;

274:
275: l_process_status VARCHAR2(1);
276: l_error_msg VARCHAR2(4000);
277: BEGIN
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:
280: CSM_UTIL_PKG.LOG
281: ( module => g_object_name
282: , message => ' Entering ' || g_object_name || '.Apply_Client_Changes for user: ' ||

Line 299: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

295: , l_error_msg
296: , l_process_status
297: );
298:
299: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
300: /*** Yes -> reject record because of changed pk ***/
301: CSM_UTIL_PKG.LOG
302: ( module => g_object_name
303: , message => r_material_transaction.TRANSACTION_ID || ' Record successfully processed, rejecting record because pk is changed'

Line 318: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

314: l_error_msg,
315: l_process_status
316: );
317:
318: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
319: /*** Reject successfull now rejecting matching serial/lotnumber records ***/
320: CSM_UTIL_PKG.LOG
321: ( module => g_object_name
322: , message => r_material_transaction.TRANSACTION_ID || ' Record rejected, now rejecting available matching lot-/serialnumber records'

Line 359: /*IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN*/

355: END LOOP;
356: END IF;
357:
358: /*** was record processed successfully? ***/
359: /*IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN*/
360: /*** Yes -> delete record from inqueue ***/
361: CSM_UTIL_PKG.LOG
362: ( module => g_object_name
363: , message => r_material_transaction.TRANSACTION_ID || ' Record successfully processed, deleting from inqueue'

Line 379: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

375: l_process_status
376: );
377:
378: /*** was delete successful? ***/
379: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
380: /*** no -> rollback ***/
381: CSM_UTIL_PKG.LOG
382: ( module => g_object_name
383: , message => r_material_transaction.TRANSACTION_ID || ' Deleting from inqueue failed, rolling back to savepoint'

Line 403: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

399: l_error_msg,
400: l_process_status
401: );
402: /*** was delete successful? ***/
403: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
404: CSM_UTIL_PKG.LOG
405: ( module => g_object_name
406: , message => r_lot_number.tranid$$ || ' Deleting from inqueue failed, Defer and reject record'
407: , log_level => FND_LOG.LEVEL_PROCEDURE);

Line 440: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

436: l_error_msg,
437: l_process_status
438: );
439: /*** was delete successful? ***/
440: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
441: CSM_UTIL_PKG.LOG
442: ( module => g_object_name || 'MTL_UNIT_TRANSACTIONS'
443: , message => r_unit_transaction.TRANSACTION_ID || ' Deleting from inqueue failed, Defer and reject record'
444: , log_level => FND_LOG.LEVEL_PROCEDURE);

Line 463: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

459: END LOOP;
460:
461: END IF;
462:
463: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
464: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
465: CSM_UTIL_PKG.LOG
466: ( module => g_object_name
467: , message => r_material_transaction.TRANSACTION_ID || ' Record not processed successfully, deferring and rejecting record'

Line 484: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

480: , r_material_transaction.dmltype$$
481: );
482:
483: /*** Was defer successful? ***/
484: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
485: /*** no -> rollback ***/
486: CSM_UTIL_PKG.LOG
487: ( module => g_object_name
488: , message => r_material_transaction.TRANSACTION_ID || ' Defer record failed, rolling back to savepoint'

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538: ( module => g_object_name
539: , message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
540: , log_level => FND_LOG.LEVEL_ERROR);
541:
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: END APPLY_CLIENT_CHANGES;
544:
545: END CSM_MATERIAL_TRANSACTION_PKG;