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.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 219: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

Line 223: RAISE FND_API.G_EXC_ERROR;

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

Line 227: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 237: l_return_status := FND_API.G_RET_STS_SUCCESS;

233: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start at: '||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
234: END IF;
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: IF G_DEBUG THEN
276: DPP_UTILITY_PVT.debug_message('After mandatory checks:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

Line 290: RAISE FND_API.G_EXC_ERROR;

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

Line 297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 652: RAISE FND_API.G_EXC_ERROR;

648: FND_MSG_PUB.add;
649: IF g_debug THEN
650: DPP_UTILITY_PVT.debug_message('Price Protection responsibility not available for Last updated user'||l_user_name);
651: END IF;
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655: FND_GLOBAL.APPS_INITIALIZE(l_txn_hdr_rec.last_updated_by,l_responsibility_id,l_dpp_application_id);
656: MO_GLOBAL.set_policy_context('S',l_txn_hdr_rec.org_id);

Line 666: RAISE FND_API.G_EXC_ERROR;

662: WHERE cost_type_id = 8;
663: EXCEPTION
664: WHEN NO_DATA_FOUND THEN
665: DPP_UTILITY_PVT.debug_message('The cost type DPPCost is not setup.');
666: RAISE FND_API.G_EXC_ERROR;
667: END;
668:
669: SELECT dpp_cst_group_id_seq.nextval
670: INTO l_import_cost_group_id

Line 718: ,p_conv_type => FND_API.G_MISS_CHAR

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

Line 719: ,p_conv_rate => FND_API.G_MISS_NUM

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

Line 784: l_return_status := FND_API.G_RET_STS_ERROR;

780: IF l_prior_cost = 0 THEN
781: --ADD Messages
782: 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 ;
783: DPP_UTILITY_PVT.debug_message('Costing setup is not done or the cost is Zero for the item:'||l_item_cost_tbl(i).item_number);
784: l_return_status := FND_API.G_RET_STS_ERROR;
785:
786: UPDATE DPP_OUTPUT_XML_GT
787: SET reason_for_failure = l_item_cost_tbl(i).Reason_for_failure
788: WHERE organization_id = Item_rec.organization_id

Line 850: l_return_status := FND_API.G_RET_STS_ERROR;

846:
847: IF NVL(l_incorrect_price_exists,0) = 1 THEN
848: l_item_cost_tbl(i).Reason_for_failure := 'This inventory organizations has an incorrect cost for item:'||l_item_cost_tbl(i).item_number;
849: DPP_UTILITY_PVT.debug_message('This inventory organizations has an incorrect cost for item:'||l_item_cost_tbl(i).item_number);
850: l_return_status := FND_API.G_RET_STS_ERROR;
851:
852: UPDATE DPP_OUTPUT_XML_GT
853: SET reason_for_failure = l_item_cost_tbl(i).Reason_for_failure
854: WHERE organization_id = Item_rec.organization_id

Line 1032: l_return_status := FND_API.G_RET_STS_ERROR;

1028: IF G_DEBUG THEN
1029: DPP_UTILITY_PVT.debug_message('OZFACCTG WF - Failure');
1030: END IF;
1031:
1032: l_return_status := FND_API.G_RET_STS_ERROR;
1033: l_status_Update_tbl(i).update_status := 'N';
1034: 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);
1035:
1036: UPDATE DPP_OUTPUT_XML_GT

Line 1258: l_return_status := FND_API.g_ret_sts_error;

1254:
1255: END;
1256:
1257: IF l_dev_status IN ('WARNING','ERROR') THEN
1258: l_return_status := FND_API.g_ret_sts_error;
1259: UPDATE DPP_OUTPUT_XML_GT
1260: SET reason_for_failure = 'Std Cost Update Request ID: '||l_cost_upd_req_id||' '|| l_dev_phase||' with '||l_dev_status
1261: WHERE organization_id = Organization_Rec.organization_id;
1262:

Line 1277: l_return_status := FND_API.g_ret_sts_error;

1273: DPP_UTILITY_PVT.debug_message('After Std Cost Update request:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1274: END IF;
1275:
1276: ELSE
1277: l_return_status := FND_API.g_ret_sts_error;
1278: DPP_UTILITY_PVT.debug_message('Item Cost Import Request ID: '||l_cost_import_req_id||' '|| l_dev_phase||' with '||l_dev_status);
1279:
1280: UPDATE DPP_OUTPUT_XML_GT
1281: SET reason_for_failure = 'Item Cost Import Request ID: '||l_cost_import_req_id||' '|| l_dev_phase||' with '||l_dev_status;

Line 1318: l_return_status := FND_API.g_ret_sts_error;

1314: WHERE inventory_item_id = inventory_item_ids(indx);
1315:
1316:
1317: IF inventory_item_ids.COUNT > 0 THEN
1318: l_return_status := FND_API.g_ret_sts_error;
1319: END IF;
1320:
1321: IF g_debug THEN
1322: DPP_UTILITY_PVT.debug_message('After Std Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

Line 1365: l_return_status := fnd_api.g_ret_sts_error;

1361: SET reason_for_failure = error_explanations(indx)
1362: WHERE transaction_line_id = source_line_ids(indx);
1363:
1364: IF source_line_ids.COUNT > 0 THEN
1365: l_return_status := fnd_api.g_ret_sts_error;
1366: END IF;
1367:
1368: END IF;
1369: -- End Error Processing for Avg Cost Update

Line 1516: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1512: -- End SLA Line Processing for Std Cost Update
1513:
1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: -- IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1518: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1519: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost-SLA Tables Insertion');
1520: fnd_message.set_token('ERRNO', sqlcode);

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

1534: << WORKFLOW_ERROR >>
1535:
1536: x_return_status := l_return_status;
1537:
1538: SELECT DECODE(l_return_status,FND_API.G_RET_STS_SUCCESS,'SUCCESS','WARNING')
1539: INTO l_execution_status
1540: FROM DUAL;
1541:
1542: BEGIN

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

1546:
1547: --Get the output XML from DPP_OUTPUT_XML_GT table
1548: l_Transaction_Number := '''' || l_txn_hdr_rec.Transaction_Number || '''';
1549:
1550: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
1551: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,
1552: CURSOR (Select Item_Number ITEMNUMBER,
1553: inventory_org_name ORGNAME,
1554: NewPrice NEWPRICE,

Line 1569: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1565: dbms_xmlquery.closeContext(l_queryCtx);
1566:
1567: EXCEPTION
1568: WHEN OTHERS THEN
1569: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1570: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1571: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost-XML Generation');
1572: fnd_message.set_token('ERRNO', sqlcode);
1573: fnd_message.set_token('REASON', sqlerrm);

Line 1593: ,p_init_msg_list => FND_API.G_FALSE

1589: l_exe_update_rec.Last_Updated_By := l_txn_hdr_rec.Last_Updated_By;
1590:
1591: DPP_ExecutionDetails_PVT.Update_ExecutionDetails(
1592: p_api_version => l_api_version
1593: ,p_init_msg_list => FND_API.G_FALSE
1594: ,p_commit => FND_API.G_FALSE
1595: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1596: ,x_return_status => l_return_status
1597: ,x_msg_count => l_msg_count

Line 1594: ,p_commit => FND_API.G_FALSE

1590:
1591: DPP_ExecutionDetails_PVT.Update_ExecutionDetails(
1592: p_api_version => l_api_version
1593: ,p_init_msg_list => FND_API.G_FALSE
1594: ,p_commit => FND_API.G_FALSE
1595: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1596: ,x_return_status => l_return_status
1597: ,x_msg_count => l_msg_count
1598: ,x_msg_data => l_msg_data

Line 1595: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1591: DPP_ExecutionDetails_PVT.Update_ExecutionDetails(
1592: p_api_version => l_api_version
1593: ,p_init_msg_list => FND_API.G_FALSE
1594: ,p_commit => FND_API.G_FALSE
1595: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1596: ,x_return_status => l_return_status
1597: ,x_msg_count => l_msg_count
1598: ,x_msg_data => l_msg_data
1599: ,p_EXE_UPDATE_rec => l_exe_update_rec

Line 1606: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1602: IF g_debug THEN
1603: DPP_UTILITY_PVT.debug_message('After Exe Dtls Update:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1604: END IF;
1605:
1606: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1607: x_return_status := l_return_status;
1608: END IF;
1609:
1610: -- Standard check for p_commit

Line 1611: IF FND_API.to_Boolean( p_commit )

1607: x_return_status := l_return_status;
1608: END IF;
1609:
1610: -- Standard check for p_commit
1611: IF FND_API.to_Boolean( p_commit )
1612: THEN
1613: COMMIT WORK;
1614: END IF;
1615:

Line 1634: WHEN FND_API.G_EXC_ERROR THEN

1630: END IF;
1631: --Exception Handling
1632: EXCEPTION
1633:
1634: WHEN FND_API.G_EXC_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: -- Standard call to get message count and if count=1, get the message
1637: FND_MSG_PUB.Count_And_Get (
1638: p_encoded => FND_API.G_FALSE,

Line 1635: x_return_status := FND_API.G_RET_STS_ERROR;

1631: --Exception Handling
1632: EXCEPTION
1633:
1634: WHEN FND_API.G_EXC_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: -- Standard call to get message count and if count=1, get the message
1637: FND_MSG_PUB.Count_And_Get (
1638: p_encoded => FND_API.G_FALSE,
1639: p_count => x_msg_count,

Line 1638: p_encoded => FND_API.G_FALSE,

1634: WHEN FND_API.G_EXC_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: -- Standard call to get message count and if count=1, get the message
1637: FND_MSG_PUB.Count_And_Get (
1638: p_encoded => FND_API.G_FALSE,
1639: p_count => x_msg_count,
1640: p_data => x_msg_data
1641: );
1642: IF x_msg_count > 1 THEN

Line 1648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1644: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1645: END LOOP;
1646: END IF;
1647:
1648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1649: ROLLBACK TO UPDATE_ITEMCOST_PVT;
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651: -- Standard call to get message count and if count=1, get the message
1652: FND_MSG_PUB.Count_And_Get (

Line 1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1646: END IF;
1647:
1648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1649: ROLLBACK TO UPDATE_ITEMCOST_PVT;
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651: -- Standard call to get message count and if count=1, get the message
1652: FND_MSG_PUB.Count_And_Get (
1653: p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,

Line 1653: p_encoded => FND_API.G_FALSE,

1649: ROLLBACK TO UPDATE_ITEMCOST_PVT;
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651: -- Standard call to get message count and if count=1, get the message
1652: FND_MSG_PUB.Count_And_Get (
1653: p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data
1656: );
1657: IF x_msg_count > 1 THEN

Line 1665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1661: END IF;
1662:
1663: WHEN OTHERS THEN
1664: ROLLBACK TO UPDATE_ITEMCOST_PVT;
1665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1666: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1667: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost');
1668: fnd_message.set_token('ERRNO', sqlcode);
1669: fnd_message.set_token('REASON', sqlerrm);

Line 1674: p_encoded => FND_API.G_FALSE,

1670: FND_MSG_PUB.add;
1671:
1672: -- Standard call to get message count and if count=1, get the message
1673: FND_MSG_PUB.Count_And_Get (
1674: p_encoded => FND_API.G_FALSE,
1675: p_count => x_msg_count,
1676: p_data => x_msg_data
1677: );
1678: IF x_msg_count > 1 THEN