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

Line 89: p_Init_msg_List IN VARCHAR2 := fnd_api.g_False,

85: end wait_for_rec_processing;
86:
87: PROCEDURE Update_ItemCost
88: (p_api_Version IN NUMBER,
89: p_Init_msg_List IN VARCHAR2 := fnd_api.g_False,
90: p_Commit IN VARCHAR2 := fnd_api.g_False,
91: p_Validation_Level IN NUMBER := fnd_api.g_Valid_Level_Full,
92: x_Return_Status OUT NOCOPY VARCHAR2,
93: x_msg_Count OUT NOCOPY NUMBER,

Line 90: p_Commit IN VARCHAR2 := fnd_api.g_False,

86:
87: PROCEDURE Update_ItemCost
88: (p_api_Version IN NUMBER,
89: p_Init_msg_List IN VARCHAR2 := fnd_api.g_False,
90: p_Commit IN VARCHAR2 := fnd_api.g_False,
91: p_Validation_Level IN NUMBER := fnd_api.g_Valid_Level_Full,
92: x_Return_Status OUT NOCOPY VARCHAR2,
93: x_msg_Count OUT NOCOPY NUMBER,
94: x_msg_Data OUT NOCOPY VARCHAR2,

Line 91: p_Validation_Level IN NUMBER := fnd_api.g_Valid_Level_Full,

87: PROCEDURE Update_ItemCost
88: (p_api_Version IN NUMBER,
89: p_Init_msg_List IN VARCHAR2 := fnd_api.g_False,
90: p_Commit IN VARCHAR2 := fnd_api.g_False,
91: p_Validation_Level IN NUMBER := fnd_api.g_Valid_Level_Full,
92: x_Return_Status OUT NOCOPY VARCHAR2,
93: x_msg_Count OUT NOCOPY NUMBER,
94: x_msg_Data OUT NOCOPY VARCHAR2,
95: p_txn_hdr_rec IN DPP_CST_HDR_REC_TYPE,

Line 220: IF NOT FND_API.Compatible_API_Call (l_api_version,

216: -- Initialization
217: ------------------------------------------
218:
219: -- Standard call to check for call compatibility.
220: IF NOT FND_API.Compatible_API_Call (l_api_version,
221: p_api_version,
222: l_api_name,
223: g_pkg_name) THEN
224: RAISE FND_API.G_EXC_ERROR;

Line 224: RAISE FND_API.G_EXC_ERROR;

220: IF NOT FND_API.Compatible_API_Call (l_api_version,
221: p_api_version,
222: l_api_name,
223: g_pkg_name) THEN
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 228: IF FND_API.to_Boolean( p_init_msg_list ) THEN

224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF FND_API.to_Boolean( p_init_msg_list ) THEN
229: FND_MSG_PUB.initialize;
230: END IF;
231:
232: -- Debug Message

Line 237: l_return_status := FND_API.G_RET_STS_SUCCESS;

233:
234: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start at: '||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
235:
236: -- Initialize API return status to sucess
237: l_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: --
240: -- API body
241: --

Line 247: RAISE FND_API.G_EXC_ERROR;

243: IF l_txn_hdr_rec.org_id IS NULL THEN
244: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
245: FND_MESSAGE.set_token('ID', 'Org ID');
246: FND_MSG_PUB.add;
247: RAISE FND_API.G_EXC_ERROR;
248: ELSIF l_txn_hdr_rec.last_updated_by IS NULL THEN
249: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
250: FND_MESSAGE.set_token('ID', 'User ID - Last_Updated_By');
251: FND_MSG_PUB.add;

Line 252: RAISE FND_API.G_EXC_ERROR;

248: ELSIF l_txn_hdr_rec.last_updated_by IS NULL THEN
249: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
250: FND_MESSAGE.set_token('ID', 'User ID - Last_Updated_By');
251: FND_MSG_PUB.add;
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_txn_hdr_rec.cost_adjustment_account IS NULL THEN
254: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
255: FND_MESSAGE.set_token('ID', 'Cost Adjustment Account');
256: FND_MSG_PUB.add;

Line 257: RAISE FND_API.G_EXC_ERROR;

253: ELSIF l_txn_hdr_rec.cost_adjustment_account IS NULL THEN
254: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
255: FND_MESSAGE.set_token('ID', 'Cost Adjustment Account');
256: FND_MSG_PUB.add;
257: RAISE FND_API.G_EXC_ERROR;
258: ELSIF l_txn_hdr_rec.transaction_header_id IS NULL THEN
259: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
260: FND_MESSAGE.set_token('ID', 'Transaction Header ID');
261: FND_MSG_PUB.add;

Line 262: RAISE FND_API.G_EXC_ERROR;

258: ELSIF l_txn_hdr_rec.transaction_header_id IS NULL THEN
259: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
260: FND_MESSAGE.set_token('ID', 'Transaction Header ID');
261: FND_MSG_PUB.add;
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF l_txn_hdr_rec.execution_detail_id IS NULL THEN
264: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
265: FND_MESSAGE.set_token('ID', 'Execution Detail ID');
266: FND_MSG_PUB.add;

Line 267: RAISE FND_API.G_EXC_ERROR;

263: ELSIF l_txn_hdr_rec.execution_detail_id IS NULL THEN
264: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
265: FND_MESSAGE.set_token('ID', 'Execution Detail ID');
266: FND_MSG_PUB.add;
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF l_txn_hdr_rec.transaction_number IS NULL THEN
269: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
270: FND_MESSAGE.set_token('ID', 'Transaction Number');
271: FND_MSG_PUB.add;

Line 272: RAISE FND_API.G_EXC_ERROR;

268: ELSIF l_txn_hdr_rec.transaction_number IS NULL THEN
269: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
270: FND_MESSAGE.set_token('ID', 'Transaction Number');
271: FND_MSG_PUB.add;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274:
275: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'After mandatory checks:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
276:

Line 288: RAISE FND_API.G_EXC_ERROR;

284: WHERE user_id = l_txn_hdr_rec.last_updated_by;
285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN
287: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Invalid User');
288: RAISE FND_API.G_EXC_ERROR;
289: WHEN OTHERS THEN
290: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
291: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
292: fnd_message.set_token('ERRNO', sqlcode);

Line 295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

291: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
292: fnd_message.set_token('ERRNO', sqlcode);
293: fnd_message.set_token('REASON', sqlerrm);
294: FND_MSG_PUB.add;
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END;
297:
298: --Getting a valid Price Protection Responsibility at the User Level Profile Options
299: BEGIN

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
369: fnd_message.set_token('ERRNO', sqlcode);
370: fnd_message.set_token('REASON', sqlerrm);
371: FND_MSG_PUB.add;
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END;
374: WHEN OTHERS THEN
375: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
376: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
377: fnd_message.set_token('ERRNO', sqlcode);
378: fnd_message.set_token('REASON', sqlerrm);
379: FND_MSG_PUB.add;
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END;
382:
383: --Getting a valid Price Protection Responsibility at the Responsibility Level Profile Options
384: IF l_responsibility_id = -1 THEN

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
454: fnd_message.set_token('ERRNO', sqlcode);
455: fnd_message.set_token('REASON', sqlerrm);
456: FND_MSG_PUB.add;
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END;
459: WHEN OTHERS THEN
460: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
461: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');

Line 465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

461: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
462: fnd_message.set_token('ERRNO', sqlcode);
463: fnd_message.set_token('REASON', sqlerrm);
464: FND_MSG_PUB.add;
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END;
467: END IF;
468:
469: --Getting a valid Price Protection Responsibility at the Application Level Profile Options

Line 543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

539: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
540: fnd_message.set_token('ERRNO', sqlcode);
541: fnd_message.set_token('REASON', sqlerrm);
542: FND_MSG_PUB.add;
543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: END;
545: WHEN OTHERS THEN
546: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
547: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');

Line 551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

547: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
548: fnd_message.set_token('ERRNO', sqlcode);
549: fnd_message.set_token('REASON', sqlerrm);
550: FND_MSG_PUB.add;
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: END;
553: END IF;
554:
555: --Getting a valid Price Protection Responsibility at the Site Level Profile Options

Line 630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

626: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
627: fnd_message.set_token('ERRNO', sqlcode);
628: fnd_message.set_token('REASON', sqlerrm);
629: FND_MSG_PUB.add;
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END;
632: WHEN OTHERS THEN
633: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
634: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');

Line 638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

634: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
635: fnd_message.set_token('ERRNO', sqlcode);
636: fnd_message.set_token('REASON', sqlerrm);
637: FND_MSG_PUB.add;
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END;
640: END IF;
641:
642: --Check if the responsibility id is -1

Line 650: RAISE FND_API.G_EXC_ERROR;

646: FND_MSG_PUB.add;
647:
648: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Price Protection responsibility not available for Last updated user'||l_user_name);
649:
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652:
653: FND_GLOBAL.APPS_INITIALIZE(l_txn_hdr_rec.last_updated_by,l_responsibility_id,l_dpp_application_id);
654: MO_GLOBAL.set_policy_context('S',l_txn_hdr_rec.org_id);

Line 664: RAISE FND_API.G_EXC_ERROR;

660: WHERE cost_type_id = 8;
661: EXCEPTION
662: WHEN NO_DATA_FOUND THEN
663: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'The cost type DPPCost is not setup.');
664: RAISE FND_API.G_EXC_ERROR;
665: END;
666:
667: SELECT dpp_cst_group_id_seq.nextval
668: INTO l_import_cost_group_id

Line 714: ,p_conv_type => FND_API.G_MISS_CHAR

710: ELSE
711: l_to_amount := 0;
712: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_item_cost_tbl(i).currency
713: ,p_to_currency => Item_rec.currency_code
714: ,p_conv_type => FND_API.G_MISS_CHAR
715: ,p_conv_rate => FND_API.G_MISS_NUM
716: ,p_conv_date => l_trunc_sysdate
717: ,p_from_amount => l_item_cost_tbl(i).new_price
718: ,x_return_status => l_return_status

Line 715: ,p_conv_rate => FND_API.G_MISS_NUM

711: l_to_amount := 0;
712: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_item_cost_tbl(i).currency
713: ,p_to_currency => Item_rec.currency_code
714: ,p_conv_type => FND_API.G_MISS_CHAR
715: ,p_conv_rate => FND_API.G_MISS_NUM
716: ,p_conv_date => l_trunc_sysdate
717: ,p_from_amount => l_item_cost_tbl(i).new_price
718: ,x_return_status => l_return_status
719: ,x_to_amount => l_to_amount

Line 780: l_return_status := FND_API.G_RET_STS_ERROR;

776: IF l_prior_cost = 0 THEN
777: --ADD Messages
778: l_item_cost_tbl(i).Reason_for_failure := 'Costing setup is not done or the cost is Zero for the item:'||l_item_cost_tbl(i).item_number ;
779: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Costing setup is not done or the cost is Zero for the item:'||l_item_cost_tbl(i).item_number);
780: l_return_status := FND_API.G_RET_STS_ERROR;
781:
782: UPDATE DPP_OUTPUT_XML_GT
783: SET reason_for_failure = l_item_cost_tbl(i).Reason_for_failure
784: WHERE organization_id = Item_rec.organization_id

Line 846: l_return_status := FND_API.G_RET_STS_ERROR;

842:
843: IF NVL(l_incorrect_price_exists,0) = 1 THEN
844: l_item_cost_tbl(i).Reason_for_failure := 'This inventory organizations has an incorrect cost for item:'||l_item_cost_tbl(i).item_number;
845: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'This inventory organizations has an incorrect cost for item:'||l_item_cost_tbl(i).item_number);
846: l_return_status := FND_API.G_RET_STS_ERROR;
847:
848: UPDATE DPP_OUTPUT_XML_GT
849: SET reason_for_failure = l_item_cost_tbl(i).Reason_for_failure
850: WHERE organization_id = Item_rec.organization_id

Line 1024: l_return_status := FND_API.G_RET_STS_ERROR;

1020: ELSE
1021:
1022: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'OZFACCTG WF - Failure');
1023:
1024: l_return_status := FND_API.G_RET_STS_ERROR;
1025: l_status_Update_tbl(i).update_status := 'N';
1026: l_item_cost_tbl(i).Reason_for_failure := 'OZFACCTG Workflow - Failure for item:'||l_item_cost_tbl(i).item_number||' Error Message: '||SUBSTR(l_errmsg,1,254);
1027:
1028: UPDATE DPP_OUTPUT_XML_GT

Line 1240: l_return_status := FND_API.g_ret_sts_error;

1236:
1237: END;
1238:
1239: IF l_dev_status IN ('WARNING','ERROR') THEN
1240: l_return_status := FND_API.g_ret_sts_error;
1241: UPDATE DPP_OUTPUT_XML_GT
1242: SET reason_for_failure = 'Std Cost Update Request ID: '||l_cost_upd_req_id||' '|| l_dev_phase||' with '||l_dev_status
1243: WHERE organization_id = Organization_Rec.organization_id;
1244:

Line 1257: l_return_status := FND_API.g_ret_sts_error;

1253:
1254: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'After Std Cost Update request:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1255:
1256: ELSE
1257: l_return_status := FND_API.g_ret_sts_error;
1258: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Item Cost Import Request ID: '||l_cost_import_req_id||' '|| l_dev_phase||' with '||l_dev_status);
1259:
1260: UPDATE DPP_OUTPUT_XML_GT
1261: SET reason_for_failure = 'Item Cost Import Request ID: '||l_cost_import_req_id||' '|| l_dev_phase||' with '||l_dev_status;

Line 1295: l_return_status := FND_API.g_ret_sts_error;

1291: WHERE inventory_item_id = inventory_item_ids(indx);
1292:
1293:
1294: IF inventory_item_ids.COUNT > 0 THEN
1295: l_return_status := FND_API.g_ret_sts_error;
1296: END IF;
1297:
1298: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'After Std Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1299:

Line 1338: l_return_status := fnd_api.g_ret_sts_error;

1334: SET reason_for_failure = error_explanations(indx)
1335: WHERE transaction_line_id = source_line_ids(indx);
1336:
1337: IF source_line_ids.COUNT > 0 THEN
1338: l_return_status := fnd_api.g_ret_sts_error;
1339: END IF;
1340:
1341: END IF;
1342: -- End Error Processing for Avg Cost Update

Line 1480: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1476: -- End SLA Line Processing for Std Cost Update
1477:
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: -- IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1482: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1483: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost-SLA Tables Insertion');
1484: fnd_message.set_token('ERRNO', sqlcode);

Line 1500: SELECT DECODE(l_return_status,FND_API.G_RET_STS_SUCCESS,'SUCCESS','WARNING')

1496: << WORKFLOW_ERROR >>
1497:
1498: x_return_status := l_return_status;
1499:
1500: SELECT DECODE(l_return_status,FND_API.G_RET_STS_SUCCESS,'SUCCESS','WARNING')
1501: INTO l_execution_status
1502: FROM DUAL;
1503:
1504: BEGIN

Line 1510: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN

1506:
1507: --Get the output XML from DPP_OUTPUT_XML_GT table
1508: l_Transaction_Number := '''' || l_txn_hdr_rec.Transaction_Number || '''';
1509:
1510: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
1511: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,
1512: CURSOR (Select Item_Number ITEMNUMBER,
1513: inventory_org_name ORGNAME,
1514: NewPrice NEWPRICE,

Line 1529: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1525: dbms_xmlquery.closeContext(l_queryCtx);
1526:
1527: EXCEPTION
1528: WHEN OTHERS THEN
1529: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1531: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost-XML Generation');
1532: fnd_message.set_token('ERRNO', sqlcode);
1533: fnd_message.set_token('REASON', sqlerrm);

Line 1551: ,p_init_msg_list => FND_API.G_FALSE

1547: l_exe_update_rec.Last_Updated_By := l_txn_hdr_rec.Last_Updated_By;
1548:
1549: DPP_ExecutionDetails_PVT.Update_ExecutionDetails(
1550: p_api_version => l_api_version
1551: ,p_init_msg_list => FND_API.G_FALSE
1552: ,p_commit => FND_API.G_FALSE
1553: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1554: ,x_return_status => l_return_status
1555: ,x_msg_count => l_msg_count

Line 1552: ,p_commit => FND_API.G_FALSE

1548:
1549: DPP_ExecutionDetails_PVT.Update_ExecutionDetails(
1550: p_api_version => l_api_version
1551: ,p_init_msg_list => FND_API.G_FALSE
1552: ,p_commit => FND_API.G_FALSE
1553: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1554: ,x_return_status => l_return_status
1555: ,x_msg_count => l_msg_count
1556: ,x_msg_data => l_msg_data

Line 1553: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1549: DPP_ExecutionDetails_PVT.Update_ExecutionDetails(
1550: p_api_version => l_api_version
1551: ,p_init_msg_list => FND_API.G_FALSE
1552: ,p_commit => FND_API.G_FALSE
1553: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1554: ,x_return_status => l_return_status
1555: ,x_msg_count => l_msg_count
1556: ,x_msg_data => l_msg_data
1557: ,p_EXE_UPDATE_rec => l_exe_update_rec

Line 1563: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1559: );
1560:
1561: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'After Exe Dtls Update:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1562:
1563: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1564: x_return_status := l_return_status;
1565: END IF;
1566:
1567: -- Standard check for p_commit

Line 1568: IF FND_API.to_Boolean( p_commit )

1564: x_return_status := l_return_status;
1565: END IF;
1566:
1567: -- Standard check for p_commit
1568: IF FND_API.to_Boolean( p_commit )
1569: THEN
1570: COMMIT WORK;
1571: END IF;
1572:

Line 1590: WHEN FND_API.G_EXC_ERROR THEN

1586: END IF;
1587: --Exception Handling
1588: EXCEPTION
1589:
1590: WHEN FND_API.G_EXC_ERROR THEN
1591: x_return_status := FND_API.G_RET_STS_ERROR;
1592: -- Standard call to get message count and if count=1, get the message
1593: FND_MSG_PUB.Count_And_Get (
1594: p_encoded => FND_API.G_FALSE,

Line 1591: x_return_status := FND_API.G_RET_STS_ERROR;

1587: --Exception Handling
1588: EXCEPTION
1589:
1590: WHEN FND_API.G_EXC_ERROR THEN
1591: x_return_status := FND_API.G_RET_STS_ERROR;
1592: -- Standard call to get message count and if count=1, get the message
1593: FND_MSG_PUB.Count_And_Get (
1594: p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,

Line 1594: p_encoded => FND_API.G_FALSE,

1590: WHEN FND_API.G_EXC_ERROR THEN
1591: x_return_status := FND_API.G_RET_STS_ERROR;
1592: -- Standard call to get message count and if count=1, get the message
1593: FND_MSG_PUB.Count_And_Get (
1594: p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,
1596: p_data => x_msg_data
1597: );
1598: IF x_msg_count > 1 THEN

Line 1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1600: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1601: END LOOP;
1602: END IF;
1603:
1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1605: ROLLBACK TO UPDATE_ITEMCOST_PVT;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: -- Standard call to get message count and if count=1, get the message
1608: FND_MSG_PUB.Count_And_Get (

Line 1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1602: END IF;
1603:
1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1605: ROLLBACK TO UPDATE_ITEMCOST_PVT;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: -- Standard call to get message count and if count=1, get the message
1608: FND_MSG_PUB.Count_And_Get (
1609: p_encoded => FND_API.G_FALSE,
1610: p_count => x_msg_count,

Line 1609: p_encoded => FND_API.G_FALSE,

1605: ROLLBACK TO UPDATE_ITEMCOST_PVT;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: -- Standard call to get message count and if count=1, get the message
1608: FND_MSG_PUB.Count_And_Get (
1609: p_encoded => FND_API.G_FALSE,
1610: p_count => x_msg_count,
1611: p_data => x_msg_data
1612: );
1613: IF x_msg_count > 1 THEN

Line 1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1617: END IF;
1618:
1619: WHEN OTHERS THEN
1620: ROLLBACK TO UPDATE_ITEMCOST_PVT;
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1622: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1623: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost');
1624: fnd_message.set_token('ERRNO', sqlcode);
1625: fnd_message.set_token('REASON', sqlerrm);

Line 1630: p_encoded => FND_API.G_FALSE,

1626: FND_MSG_PUB.add;
1627:
1628: -- Standard call to get message count and if count=1, get the message
1629: FND_MSG_PUB.Count_And_Get (
1630: p_encoded => FND_API.G_FALSE,
1631: p_count => x_msg_count,
1632: p_data => x_msg_data
1633: );
1634: IF x_msg_count > 1 THEN