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

Line 38: x_return_status := FND_API.G_RET_STS_SUCCESS;

34: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
35: p_procedure_name => l_proc_name);
36:
37: -- Initialize API return status to success
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: l_debug_info := 'Get the Allocation Basis and UOM Code';
41: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
42: p_procedure_name => l_proc_name,

Line 92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

88: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
89: p_procedure_name => l_proc_name);
90: EXCEPTION
91: WHEN OTHERS THEN
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
94: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
95: p_procedure_name => l_proc_name);
96: END IF;

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
190: p_procedure_name => l_proc_name);
191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195: l_debug_info := 'Get the Charge Line ID';
196: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
197: p_procedure_name => l_proc_name,

Line 316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

312: p_to_parent_table_id => p_to_parent_table_id,
313: x_return_status => l_return_status);
314:
315: -- If any errors happen abort the process.
316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320: -- Standard End of Procedure/Function Logging

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: x_return_status => l_return_status);
314:
315: -- If any errors happen abort the process.
316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320: -- Standard End of Procedure/Function Logging
321: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

324: WHEN OTHERS THEN
325: -- Standard Unexpected Error Logging
326: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
327: p_procedure_name => l_proc_name);
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
330: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
331: p_procedure_name => l_proc_name);
332: END IF;

Line 401: x_return_status := FND_API.G_RET_STS_SUCCESS;

397: -- Begin the procedure
398: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
399: p_procedure_name => l_proc_name);
400: -- Init return status
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402:
403: -- Setting the global header record structure
404: po_advanced_price_pvt.g_hdr.org_id := p_org_id;
405: po_advanced_price_pvt.g_hdr.p_order_header_id := p_order_header_id;

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430: EXCEPTION
431: WHEN OTHERS THEN
432: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
433: p_procedure_name => l_proc_name);
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: END Populate_HeaderRecord;
436:
437: -- Utility name : Populate_LineRecord
438: -- Type : Private

Line 504: x_return_status := FND_API.G_RET_STS_SUCCESS;

500: -- Begin the procedure
501: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
502: p_procedure_name => l_proc_name);
503: -- Init return status
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: -- Setting the global line record structure
507: po_advanced_price_pvt.g_line.order_line_id := p_order_line_id;
508: po_advanced_price_pvt.g_line.item_revision := p_item_revision;

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

534: EXCEPTION
535: WHEN OTHERS THEN
536: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
537: p_procedure_name => l_proc_name);
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: END Populate_LineRecord;
540:
541: -- Utility name : Get_ChargesFromQP
542: -- Type : Private

Line 627: x_return_status := FND_API.G_RET_STS_SUCCESS;

623: -- Begin the procedure
624: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
625: p_procedure_name => l_proc_name);
626: -- Init return status
627: x_return_status := FND_API.G_RET_STS_SUCCESS;
628:
629: -- Init QP Cost and Charge Line type tables
630: l_qp_cost_table := qp_price_result_tbl();
631: x_charge_ln_tbl := charge_ln_tbl();

Line 859: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

855: p_list_price_override_flag => l_list_price_overide_flag_tbl,
856: x_status_code => x_return_status,
857: x_status_text => l_return_status_text);
858:
859: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
860: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
861: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
862: FND_MSG_PUB.ADD;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

859: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
860: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
861: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
862: FND_MSG_PUB.ADD;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
865: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
866: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
867: FND_MSG_PUB.ADD;

Line 864: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

860: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
861: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
862: FND_MSG_PUB.ADD;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
865: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
866: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
867: FND_MSG_PUB.ADD;
868: RAISE FND_API.G_EXC_ERROR;

Line 868: RAISE FND_API.G_EXC_ERROR;

864: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
865: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
866: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
867: FND_MSG_PUB.ADD;
868: RAISE FND_API.G_EXC_ERROR;
869: END IF;
870:
871: l_debug_info := 'Populate Control Record variables for Pricing Request Call';
872: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 898: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

894: QP_PREQ_PUB.PRICE_REQUEST(p_control_rec => l_control_rec,
895: x_return_status => x_return_status,
896: x_return_status_Text => l_return_status_Text);
897:
898: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
899: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
900: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
901: FND_MSG_PUB.ADD;
902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

898: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
899: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
900: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
901: FND_MSG_PUB.ADD;
902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
904: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
905: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
906: FND_MSG_PUB.ADD;

Line 903: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

899: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
900: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
901: FND_MSG_PUB.ADD;
902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
904: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
905: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
906: FND_MSG_PUB.ADD;
907: RAISE FND_API.G_EXC_ERROR;

Line 907: RAISE FND_API.G_EXC_ERROR;

903: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
904: FND_MESSAGE.SET_NAME('INL','INL_ERR_QP_PRICE_API');
905: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
906: FND_MSG_PUB.ADD;
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910: -- Access the QP qp_ldets_v view to retrieve the freight charge info.
911: FOR k IN 1..l_line_index-1 LOOP

Line 1031: WHEN FND_API.G_EXC_ERROR THEN

1027: -- End the procedure
1028: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1029: p_procedure_name => l_proc_name);
1030: EXCEPTION
1031: WHEN FND_API.G_EXC_ERROR THEN
1032: --raised expected error: assume raiser already pushed onto the stack
1033: l_exception_msg := FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
1034: p_encoded => 'F');
1035: x_return_status := FND_API.g_ret_sts_error;

Line 1035: x_return_status := FND_API.g_ret_sts_error;

1031: WHEN FND_API.G_EXC_ERROR THEN
1032: --raised expected error: assume raiser already pushed onto the stack
1033: l_exception_msg := FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
1034: p_encoded => 'F');
1035: x_return_status := FND_API.g_ret_sts_error;
1036: -- Push the po_return_msg onto msg list and message stack
1037: FND_MESSAGE.set_name('INL', 'INL_ERR_QP_PRICE_API');
1038: FND_MESSAGE.set_token('ERROR_TEXT',l_exception_msg);
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1035: x_return_status := FND_API.g_ret_sts_error;
1036: -- Push the po_return_msg onto msg list and message stack
1037: FND_MESSAGE.set_name('INL', 'INL_ERR_QP_PRICE_API');
1038: FND_MESSAGE.set_token('ERROR_TEXT',l_exception_msg);
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: --raised unexpected error: assume raiser already pushed onto the stack
1041: l_exception_msg := FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
1042: p_encoded => 'F');
1043: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1043: x_return_status := FND_API.g_ret_sts_unexp_error;

1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: --raised unexpected error: assume raiser already pushed onto the stack
1041: l_exception_msg := FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
1042: p_encoded => 'F');
1043: x_return_status := FND_API.g_ret_sts_unexp_error;
1044: -- Push the po_return_msg onto msg list and message stack
1045: FND_MESSAGE.set_name('INL', 'INL_ERR_QP_PRICE_API');
1046: FND_MESSAGE.set_token('ERROR_TEXT',l_exception_msg);
1047: WHEN OTHERS THEN

Line 1050: x_return_status := FND_API.g_ret_sts_unexp_error;

1046: FND_MESSAGE.set_token('ERROR_TEXT',l_exception_msg);
1047: WHEN OTHERS THEN
1048: --unexpected error from this procedure: get SQLERRM
1049: l_exception_msg := FND_MESSAGE.get;
1050: x_return_status := FND_API.g_ret_sts_unexp_error;
1051: -- Push the po_return_msg onto msg list and message stack
1052: FND_MESSAGE.set_name('INL', 'INL_ERR_QP_PRICE_API');
1053: FND_MESSAGE.set_token('ERROR_TEXT',l_exception_msg);
1054: END Get_ChargesFromQP;

Line 1063: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

1059: -- can be the QP or any other logic defined inside the Charges Hook.
1060: -- Pre-reqs : None
1061: -- Parameters :
1062: -- IN : p_api_version IN NUMBER Required
1063: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
1064: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1065: -- p_ship_header_id IN NUMBER Required
1066: --
1067: -- OUT x_return_status OUT NOCOPY VARCHAR2

Line 1064: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1060: -- Pre-reqs : None
1061: -- Parameters :
1062: -- IN : p_api_version IN NUMBER Required
1063: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
1064: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1065: -- p_ship_header_id IN NUMBER Required
1066: --
1067: -- OUT x_return_status OUT NOCOPY VARCHAR2
1068: -- x_msg_count OUT NOCOPY NUMBER

Line 1075: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1071: -- Version : Current version 1.0
1072: --
1073: -- Notes :
1074: PROCEDURE Generate_Charges(p_api_version IN NUMBER,
1075: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1076: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1077: p_ship_header_id IN NUMBER,
1078: x_return_status OUT NOCOPY VARCHAR2,
1079: x_msg_count OUT NOCOPY NUMBER,

Line 1076: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1072: --
1073: -- Notes :
1074: PROCEDURE Generate_Charges(p_api_version IN NUMBER,
1075: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1076: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1077: p_ship_header_id IN NUMBER,
1078: x_return_status OUT NOCOPY VARCHAR2,
1079: x_msg_count OUT NOCOPY NUMBER,
1080: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1108: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1104: -- Standard Start of API savepoint
1105: SAVEPOINT Generate_Charges_PVT;
1106:
1107: -- Initialize message list if p_init_msg_list is set to TRUE.
1108: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1109: FND_MSG_PUB.initialize;
1110: END IF;
1111:
1112: -- Check for call compatibility.

Line 1113: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version,

1109: FND_MSG_PUB.initialize;
1110: END IF;
1111:
1112: -- Check for call compatibility.
1113: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version,
1114: p_caller_version_number => p_api_version,
1115: p_api_name => l_api_name,
1116: p_pkg_name => g_pkg_name)
1117: THEN

Line 1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1114: p_caller_version_number => p_api_version,
1115: p_api_name => l_api_name,
1116: p_pkg_name => g_pkg_name)
1117: THEN
1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119: END IF;
1120:
1121: -- Initialize API return status to success
1122: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1122: x_return_status := FND_API.G_RET_STS_SUCCESS;

1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119: END IF;
1120:
1121: -- Initialize API return status to success
1122: x_return_status := FND_API.G_RET_STS_SUCCESS;
1123:
1124: l_debug_info := 'Getting all Shipment Line Groups from a given Shipment Header ID';
1125: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1126: p_procedure_name => l_api_name,

Line 1147: RAISE FND_API.G_EXC_ERROR;

1143: p_procedure_name => l_api_name,
1144: p_debug_info => l_debug_info);
1145: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHAR_LN_GEN');
1146: FND_MSG_PUB.ADD;
1147: RAISE FND_API.G_EXC_ERROR;
1148: END IF;
1149:
1150: l_debug_info := 'Delete QP Charges and Associations previously to the current Shipment';
1151: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 1342: RAISE FND_API.G_EXC_ERROR;

1338: p_procedure_name => l_api_name,
1339: p_debug_info => l_debug_info);
1340: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHAR_LN_GEN');
1341: FND_MSG_PUB.ADD;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END;
1344:
1345: l_debug_info := 'Call INL_CHARGESHOOK_PVT.Get_Charges(...)';
1346: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 1357: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1353: x_override_default_processing => l_override_default_processing,
1354: x_return_status => l_return_status);
1355:
1356: -- If any errors happen abort the process.
1357: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;

Line 1358: RAISE FND_API.G_EXC_ERROR;

1354: x_return_status => l_return_status);
1355:
1356: -- If any errors happen abort the process.
1357: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;
1362:

Line 1359: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1355:
1356: -- If any errors happen abort the process.
1357: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;
1362:
1363: -- Check whether Charges Hook overrode

Line 1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1356: -- If any errors happen abort the process.
1357: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;
1362:
1363: -- Check whether Charges Hook overrode
1364: -- the default Generate Charges processing.

Line 1379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1375: x_charge_ln_tbl => l_charge_ln_tbl,
1376: x_return_status => l_return_status);
1377:
1378: -- If any errors happen abort the process.
1379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1380: RAISE FND_API.G_EXC_ERROR;
1381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: END IF;

Line 1380: RAISE FND_API.G_EXC_ERROR;

1376: x_return_status => l_return_status);
1377:
1378: -- If any errors happen abort the process.
1379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1380: RAISE FND_API.G_EXC_ERROR;
1381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: END IF;
1384: END IF;

Line 1381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1377:
1378: -- If any errors happen abort the process.
1379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1380: RAISE FND_API.G_EXC_ERROR;
1381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: END IF;
1384: END IF;
1385:

Line 1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1378: -- If any errors happen abort the process.
1379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1380: RAISE FND_API.G_EXC_ERROR;
1381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: END IF;
1384: END IF;
1385:
1386: l_debug_info := 'Check whether Charge Lines were populated into l_charge_ln_tbl';

Line 1445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1441: p_to_parent_table_id => l_charge_ln_tbl(j).to_parent_table_id,
1442: x_return_status => l_return_status);
1443:
1444: -- If any errors happen abort the process.
1445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;

Line 1446: RAISE FND_API.G_EXC_ERROR;

1442: x_return_status => l_return_status);
1443:
1444: -- If any errors happen abort the process.
1445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;
1450: END LOOP;

Line 1447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1443:
1444: -- If any errors happen abort the process.
1445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;
1450: END LOOP;
1451: END IF;

Line 1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1444: -- If any errors happen abort the process.
1445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;
1450: END LOOP;
1451: END IF;
1452: -- Clear table types at the end of each iteration

Line 1458: IF FND_API.To_Boolean( p_commit ) THEN

1454: l_ship_ln_tbl.DELETE;
1455: END LOOP;
1456:
1457: -- Standard check of p_commit.
1458: IF FND_API.To_Boolean( p_commit ) THEN
1459: COMMIT WORK;
1460: END IF;
1461:
1462: -- Standard call to get message count and if count is 1, get message info.

Line 1463: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1459: COMMIT WORK;
1460: END IF;
1461:
1462: -- Standard call to get message count and if count is 1, get message info.
1463: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1464: p_count => x_msg_count,
1465: p_data => x_msg_data);
1466:
1467: -- Standard End of Procedure/Function Logging

Line 1472: WHEN FND_API.G_EXC_ERROR THEN

1468: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1469: p_procedure_name => l_api_name);
1470:
1471: EXCEPTION
1472: WHEN FND_API.G_EXC_ERROR THEN
1473: -- Standard Expected Error Logging
1474: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1475: p_procedure_name => l_api_name);
1476: ROLLBACK TO Generate_Charges_PVT;

Line 1477: x_return_status := FND_API.G_RET_STS_ERROR;

1473: -- Standard Expected Error Logging
1474: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1475: p_procedure_name => l_api_name);
1476: ROLLBACK TO Generate_Charges_PVT;
1477: x_return_status := FND_API.G_RET_STS_ERROR;
1478: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1479: p_count => x_msg_count,
1480: p_data => x_msg_data);
1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1478: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1474: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1475: p_procedure_name => l_api_name);
1476: ROLLBACK TO Generate_Charges_PVT;
1477: x_return_status := FND_API.G_RET_STS_ERROR;
1478: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1479: p_count => x_msg_count,
1480: p_data => x_msg_data);
1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1482: -- Standard Unexpected Error Logging

Line 1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1477: x_return_status := FND_API.G_RET_STS_ERROR;
1478: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1479: p_count => x_msg_count,
1480: p_data => x_msg_data);
1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1482: -- Standard Unexpected Error Logging
1483: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1484: p_procedure_name => l_api_name);
1485: ROLLBACK TO Generate_Charges_PVT;

Line 1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1482: -- Standard Unexpected Error Logging
1483: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1484: p_procedure_name => l_api_name);
1485: ROLLBACK TO Generate_Charges_PVT;
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1488: p_count => x_msg_count,
1489: p_data => x_msg_data);
1490: WHEN OTHERS THEN

Line 1487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1483: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1484: p_procedure_name => l_api_name);
1485: ROLLBACK TO Generate_Charges_PVT;
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1488: p_count => x_msg_count,
1489: p_data => x_msg_data);
1490: WHEN OTHERS THEN
1491: -- Standard Unexpected Error Logging

Line 1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1491: -- Standard Unexpected Error Logging
1492: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1493: p_procedure_name => l_api_name);
1494: ROLLBACK TO Generate_Charges_PVT;
1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1497: THEN
1498: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1499: p_procedure_name => l_api_name);

Line 1501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1497: THEN
1498: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1499: p_procedure_name => l_api_name);
1500: END IF;
1501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1502: p_count => x_msg_count,
1503: p_data => x_msg_data);
1504: END Generate_Charges;
1505: