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_SHIPMENT_PVT dependencies on FND_MSG_PUB

Line 255: IF FND_MSG_PUB.Check_Msg_Level(

251: p_module_name => g_module_name,
252: p_procedure_name => l_program_name
253: );
254: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
255: IF FND_MSG_PUB.Check_Msg_Level(
256: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
257: THEN
258: FND_MSG_PUB.Add_Exc_Msg(
259: p_pkg_name => g_pkg_name,

Line 256: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

252: p_procedure_name => l_program_name
253: );
254: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
255: IF FND_MSG_PUB.Check_Msg_Level(
256: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
257: THEN
258: FND_MSG_PUB.Add_Exc_Msg(
259: p_pkg_name => g_pkg_name,
260: p_procedure_name => l_program_name

Line 258: FND_MSG_PUB.Add_Exc_Msg(

254: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
255: IF FND_MSG_PUB.Check_Msg_Level(
256: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
257: THEN
258: FND_MSG_PUB.Add_Exc_Msg(
259: p_pkg_name => g_pkg_name,
260: p_procedure_name => l_program_name
261: );
262: END IF;

Line 344: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

340: INL_LOGGING_PVT.Log_UnexpecError (
341: p_module_name => g_module_name,
342: p_procedure_name => l_program_name) ;
343: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
344: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
345: FND_MSG_PUB.Add_Exc_Msg (
346: p_pkg_name => g_pkg_name,
347: p_procedure_name => l_program_name) ;
348: END IF;

Line 345: FND_MSG_PUB.Add_Exc_Msg (

341: p_module_name => g_module_name,
342: p_procedure_name => l_program_name) ;
343: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
344: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
345: FND_MSG_PUB.Add_Exc_Msg (
346: p_pkg_name => g_pkg_name,
347: p_procedure_name => l_program_name) ;
348: END IF;
349: END Reset_ShipError;

Line 405: FND_MSG_PUB.initialize;

401: -- Standard Start of API savepoint
402: SAVEPOINT Complete_Shipment_PVT;
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404: IF FND_API.to_Boolean (p_init_msg_list) THEN
405: FND_MSG_PUB.initialize;
406: END IF;
407: -- Check for call compatibility.
408: IF NOT
409: FND_API.Compatible_API_Call (

Line 533: FND_MSG_PUB.Count_And_Get (

529: IF FND_API.To_Boolean (p_commit) THEN
530: COMMIT WORK;
531: END IF;
532: -- Standard call to get message count and if count is 1, get message info.
533: FND_MSG_PUB.Count_And_Get (
534: p_encoded => L_FND_FALSE,
535: p_count => x_msg_count,
536: p_data => x_msg_data) ;
537: INL_LOGGING_PVT.Log_EndProc (

Line 547: FND_MSG_PUB.Count_And_Get (

543: p_module_name => g_module_name,
544: p_procedure_name => l_api_name) ;
545: ROLLBACK TO Complete_Shipment_PVT;
546: x_return_status := L_FND_RET_STS_ERROR;
547: FND_MSG_PUB.Count_And_Get (
548: p_encoded => L_FND_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data) ;
551: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 557: FND_MSG_PUB.Count_And_Get (

553: p_module_name => g_module_name,
554: p_procedure_name => l_api_name) ;
555: ROLLBACK TO Complete_Shipment_PVT;
556: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
557: FND_MSG_PUB.Count_And_Get (
558: p_encoded => L_FND_FALSE,
559: p_count => x_msg_count,
560: p_data => x_msg_data) ;
561: WHEN OTHERS THEN

Line 567: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

563: p_module_name => g_module_name,
564: p_procedure_name => l_api_name) ;
565: ROLLBACK TO Complete_Shipment_PVT;
566: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
567: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: FND_MSG_PUB.Add_Exc_Msg (
569: p_pkg_name => g_pkg_name,
570: p_procedure_name => l_api_name) ;
571: END IF;

Line 568: FND_MSG_PUB.Add_Exc_Msg (

564: p_procedure_name => l_api_name) ;
565: ROLLBACK TO Complete_Shipment_PVT;
566: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
567: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: FND_MSG_PUB.Add_Exc_Msg (
569: p_pkg_name => g_pkg_name,
570: p_procedure_name => l_api_name) ;
571: END IF;
572: FND_MSG_PUB.Count_And_Get (

Line 572: FND_MSG_PUB.Count_And_Get (

568: FND_MSG_PUB.Add_Exc_Msg (
569: p_pkg_name => g_pkg_name,
570: p_procedure_name => l_api_name) ;
571: END IF;
572: FND_MSG_PUB.Count_And_Get (
573: p_encoded => L_FND_FALSE,
574: p_count => x_msg_count,
575: p_data => x_msg_data) ;
576: END Complete_Shipment;

Line 620: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

616: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
617: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
618: WHEN OTHERS THEN
619: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
620: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
621: FND_MSG_PUB.Add_Exc_Msg (
622: p_pkg_name => g_pkg_name,
623: p_procedure_name => l_program_name) ;
624: END IF;

Line 621: FND_MSG_PUB.Add_Exc_Msg (

617: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
618: WHEN OTHERS THEN
619: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
620: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
621: FND_MSG_PUB.Add_Exc_Msg (
622: p_pkg_name => g_pkg_name,
623: p_procedure_name => l_program_name) ;
624: END IF;
625: END Delete_Allocations;

Line 670: FND_MSG_PUB.initialize;

666: -- Standard Start of API savepoint
667: SAVEPOINT Set_ToRevalidate_PVT;
668: -- Initialize message list if p_init_msg_list is set to TRUE.
669: IF FND_API.to_Boolean (p_init_msg_list) THEN
670: FND_MSG_PUB.initialize;
671: END IF;
672: -- Check for call compatibility.
673: IF NOT FND_API.Compatible_API_Call (
674: p_current_version_number => l_api_version,

Line 711: FND_MSG_PUB.Count_And_Get (

707: IF FND_API.To_Boolean (p_commit) THEN
708: COMMIT WORK;
709: END IF;
710: -- Standard call to get message count and if count is 1, get message info.
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => L_FND_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
715: ) ;

Line 732: FND_MSG_PUB.Count_And_Get (

728: p_module_name => g_module_name,
729: p_procedure_name => l_api_name) ;
730: ROLLBACK TO Set_ToRevalidate_PVT;
731: x_return_status := L_FND_RET_STS_ERROR;
732: FND_MSG_PUB.Count_And_Get (
733: p_encoded => L_FND_FALSE,
734: p_count => x_msg_count,
735: p_data => x_msg_data) ;
736: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 748: FND_MSG_PUB.Count_And_Get (

744: p_module_name => g_module_name,
745: p_procedure_name => l_api_name) ;
746: ROLLBACK TO Set_ToRevalidate_PVT;
747: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
748: FND_MSG_PUB.Count_And_Get (
749: p_encoded => L_FND_FALSE,
750: p_count => x_msg_count,
751: p_data => x_msg_data) ;
752: WHEN OTHERS THEN

Line 764: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

760: p_module_name => g_module_name,
761: p_procedure_name => l_api_name) ;
762: ROLLBACK TO Set_ToRevalidate_PVT;
763: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
764: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
765: FND_MSG_PUB.Add_Exc_Msg (
766: p_pkg_name => g_pkg_name,
767: p_procedure_name => l_api_name) ;
768: END IF;

Line 765: FND_MSG_PUB.Add_Exc_Msg (

761: p_procedure_name => l_api_name) ;
762: ROLLBACK TO Set_ToRevalidate_PVT;
763: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
764: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
765: FND_MSG_PUB.Add_Exc_Msg (
766: p_pkg_name => g_pkg_name,
767: p_procedure_name => l_api_name) ;
768: END IF;
769: FND_MSG_PUB.Count_And_Get (

Line 769: FND_MSG_PUB.Count_And_Get (

765: FND_MSG_PUB.Add_Exc_Msg (
766: p_pkg_name => g_pkg_name,
767: p_procedure_name => l_api_name) ;
768: END IF;
769: FND_MSG_PUB.Count_And_Get (
770: p_encoded => L_FND_FALSE,
771: p_count => x_msg_count,
772: p_data => x_msg_data) ;
773: END Set_ToRevalidate;

Line 1004: FND_MSG_PUB.initialize;

1000: p_module_name => g_module_name,
1001: p_procedure_name => l_api_name) ;
1002: -- Initialize message list if p_init_msg_list is set to TRUE.
1003: IF FND_API.to_Boolean (p_init_msg_list) THEN
1004: FND_MSG_PUB.initialize;
1005: END IF;
1006: -- Check for call compatibility.
1007: IF NOT
1008: FND_API.Compatible_API_Call (

Line 1129: FND_MSG_PUB.Count_And_Get (

1125: IF FND_API.To_Boolean (p_commit) THEN
1126: COMMIT WORK;
1127: END IF;
1128: -- Standard call to get message count and if count is 1, get message info.
1129: FND_MSG_PUB.Count_And_Get (
1130: p_encoded => L_FND_FALSE,
1131: p_count => x_msg_count,
1132: p_data => x_msg_data) ;
1133: -- Standard End of Procedure/Function Logging

Line 1144: FND_MSG_PUB.Count_And_Get (

1140: INL_LOGGING_PVT.Log_ExpecError (
1141: p_module_name => g_module_name,
1142: p_procedure_name => l_api_name) ;
1143: x_return_status := L_FND_RET_STS_ERROR;
1144: FND_MSG_PUB.Count_And_Get (
1145: p_encoded => L_FND_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data) ;
1148: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 1154: FND_MSG_PUB.Count_And_Get (

1150: INL_LOGGING_PVT.Log_UnexpecError (
1151: p_module_name => g_module_name,
1152: p_procedure_name => l_api_name) ;
1153: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1154: FND_MSG_PUB.Count_And_Get (
1155: p_encoded => L_FND_FALSE,
1156: p_count => x_msg_count,
1157: p_data => x_msg_data) ;
1158: WHEN OTHERS THEN

Line 1164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1160: INL_LOGGING_PVT.Log_UnexpecError (
1161: p_module_name => g_module_name,
1162: p_procedure_name => l_api_name) ;
1163: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
1164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1165: FND_MSG_PUB.Add_Exc_Msg (
1166: p_pkg_name => g_pkg_name,
1167: p_procedure_name => l_api_name) ;
1168: END IF;

Line 1165: FND_MSG_PUB.Add_Exc_Msg (

1161: p_module_name => g_module_name,
1162: p_procedure_name => l_api_name) ;
1163: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
1164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1165: FND_MSG_PUB.Add_Exc_Msg (
1166: p_pkg_name => g_pkg_name,
1167: p_procedure_name => l_api_name) ;
1168: END IF;
1169: FND_MSG_PUB.Count_And_Get (

Line 1169: FND_MSG_PUB.Count_And_Get (

1165: FND_MSG_PUB.Add_Exc_Msg (
1166: p_pkg_name => g_pkg_name,
1167: p_procedure_name => l_api_name) ;
1168: END IF;
1169: FND_MSG_PUB.Count_And_Get (
1170: p_encoded => L_FND_FALSE,
1171: p_count => x_msg_count,
1172: p_data => x_msg_data) ;
1173: END Get_AvailableQty;

Line 1328: FND_MSG_PUB.ADD;

1324: -- Check if primary qty is ZERO
1325: IF NVL (p_primary_qty, 0) = 0 THEN
1326: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_ZERO') ;
1327: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1328: FND_MSG_PUB.ADD;
1329: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1330: Handle_ShipError (
1331: p_ship_header_id => p_ship_header_id,
1332: p_ship_line_id => p_ship_line_id,

Line 1337: p_error_message => SUBSTR (FND_MSG_PUB.Get(

1333: p_charge_line_id => NULL,
1334: p_table_name => 'INL_SHIP_LINES',
1335: p_column_name => 'PRIMARY_QTY',
1336: p_column_value => 0,
1337: p_error_message => SUBSTR (FND_MSG_PUB.Get(
1338: p_msg_index => FND_MSG_PUB.Count_Msg (),
1339: p_encoded => L_FND_FALSE), 1, 2000
1340: ),
1341: p_error_message_name => 'INL_ERR_CHK_SHIP_LN_QTY_ZERO',

Line 1338: p_msg_index => FND_MSG_PUB.Count_Msg (),

1334: p_table_name => 'INL_SHIP_LINES',
1335: p_column_name => 'PRIMARY_QTY',
1336: p_column_value => 0,
1337: p_error_message => SUBSTR (FND_MSG_PUB.Get(
1338: p_msg_index => FND_MSG_PUB.Count_Msg (),
1339: p_encoded => L_FND_FALSE), 1, 2000
1340: ),
1341: p_error_message_name => 'INL_ERR_CHK_SHIP_LN_QTY_ZERO',
1342: p_token1_name => 'SHIP_LINE_NUM',

Line 1488: FND_MSG_PUB.ADD;

1484: END IF;
1485: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1486: FND_MESSAGE.SET_TOKEN ('QTY', l_msg_tolerable_qty) ;
1487: FND_MESSAGE.SET_TOKEN ('UOM', l_msg_uom_tl) ;
1488: FND_MSG_PUB.ADD;
1489: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1490: Handle_ShipError (
1491: p_ship_header_id => p_ship_header_id,
1492: p_ship_line_id => p_ship_line_id,

Line 1497: p_error_message => SUBSTR (FND_MSG_PUB.Get (

1493: p_charge_line_id => NULL,
1494: p_table_name => 'INL_SHIP_LINES',
1495: p_column_name => 'PRIMARY_QTY',
1496: p_column_value => p_primary_qty,
1497: p_error_message => SUBSTR (FND_MSG_PUB.Get (
1498: p_msg_index => FND_MSG_PUB.Count_Msg (),
1499: p_encoded => L_FND_FALSE), 1, 2000),
1500: p_error_message_name => l_error_message_name,
1501: p_token1_name => 'SHIP_LINE_NUM',

Line 1498: p_msg_index => FND_MSG_PUB.Count_Msg (),

1494: p_table_name => 'INL_SHIP_LINES',
1495: p_column_name => 'PRIMARY_QTY',
1496: p_column_value => p_primary_qty,
1497: p_error_message => SUBSTR (FND_MSG_PUB.Get (
1498: p_msg_index => FND_MSG_PUB.Count_Msg (),
1499: p_encoded => L_FND_FALSE), 1, 2000),
1500: p_error_message_name => l_error_message_name,
1501: p_token1_name => 'SHIP_LINE_NUM',
1502: p_token1_value => p_ship_line_num,

Line 1555: FND_MSG_PUB.ADD;

1551: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num);
1552: FND_MESSAGE.SET_TOKEN ('SRC_TYPE', p_ship_line_src_type_code);
1553: FND_MESSAGE.SET_TOKEN ('QTY', l_msg_tolerable_qty);
1554: FND_MESSAGE.SET_TOKEN ('UOM', l_msg_uom_tl);
1555: FND_MSG_PUB.ADD;
1556:
1557: SELECT DISTINCT sh.ship_num,
1558: sl.ship_line_num
1559: BULK COLLECT INTO l_ship_qty_validation_inf_tbl

Line 1578: FND_MSG_PUB.ADD;

1574: FOR i IN 1 .. l_ship_qty_validation_inf_tbl.COUNT LOOP
1575: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_INFO');
1576: FND_MESSAGE.SET_TOKEN ('SHIP_NUM', l_ship_qty_validation_inf_tbl(i).ship_num);
1577: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', l_ship_qty_validation_inf_tbl(i).ship_line_num);
1578: FND_MSG_PUB.ADD;
1579: END LOOP;
1580: -- End of Bug #9755545
1581:
1582: /*FOR c_ship_num IN

Line 1611: FND_MSG_PUB.ADD;*/

1607: FND_MESSAGE.SET_TOKEN ('SRC_TYPE', p_ship_line_src_type_code) ;
1608: FND_MESSAGE.SET_TOKEN ('QTY', l_msg_tolerable_qty) ;
1609: FND_MESSAGE.SET_TOKEN ('UOM', l_msg_uom_tl) ;
1610: FND_MESSAGE.SET_TOKEN ('SHIPHS', l_msg) ;--BUG#9735125
1611: FND_MSG_PUB.ADD;*/
1612:
1613:
1614:
1615: --INCLUDE A LINE IN INL_SHIP_HOLdS

Line 1623: p_error_message => SUBSTR (FND_MSG_PUB.Get (

1619: p_charge_line_id => NULL,
1620: p_table_name => 'INL_SHIP_LINES',
1621: p_column_name => NULL,
1622: p_column_value => NULL,
1623: p_error_message => SUBSTR (FND_MSG_PUB.Get (
1624: p_msg_index => FND_MSG_PUB.Count_Msg (),
1625: p_encoded => L_FND_FALSE), 1, 2000),
1626: p_error_message_name => 'INL_ERR_CHK_SHIP_LN_QTY_OTH_L',
1627: p_token1_name => 'SRC_TYPE',

Line 1624: p_msg_index => FND_MSG_PUB.Count_Msg (),

1620: p_table_name => 'INL_SHIP_LINES',
1621: p_column_name => NULL,
1622: p_column_value => NULL,
1623: p_error_message => SUBSTR (FND_MSG_PUB.Get (
1624: p_msg_index => FND_MSG_PUB.Count_Msg (),
1625: p_encoded => L_FND_FALSE), 1, 2000),
1626: p_error_message_name => 'INL_ERR_CHK_SHIP_LN_QTY_OTH_L',
1627: p_token1_name => 'SRC_TYPE',
1628: p_token1_value => p_ship_line_src_type_code,

Line 1652: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1648: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1649: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1650: WHEN OTHERS THEN
1651: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1652: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1653: FND_MSG_PUB.Add_Exc_Msg (
1654: p_pkg_name => g_pkg_name,
1655: p_procedure_name => l_program_name) ;
1656: END IF;

Line 1653: FND_MSG_PUB.Add_Exc_Msg (

1649: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1650: WHEN OTHERS THEN
1651: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1652: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1653: FND_MSG_PUB.Add_Exc_Msg (
1654: p_pkg_name => g_pkg_name,
1655: p_procedure_name => l_program_name) ;
1656: END IF;
1657: END Check_AvailableQty;

Line 1953: FND_MSG_PUB.ADD;

1949: IF (l_p_converted_PUP > l_po_converted_price) THEN
1950: x_return_validation_status := 'FALSE'; -- SCM-051
1951: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NOT_DEF_PO_PRICE_TOLER') ;
1952: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
1953: FND_MSG_PUB.ADD;
1954: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1955: Handle_ShipError (
1956: p_ship_header_id => p_ship_header_id,
1957: p_ship_line_id => p_ship_line_id,

Line 1962: p_error_message => SUBSTR (FND_MSG_PUB.Get (

1958: p_charge_line_id => NULL,
1959: p_table_name => 'INL_SHIP_LINES',
1960: p_column_name => 'PRIMARY_UNIT_PRICE',
1961: p_column_value => 0,
1962: p_error_message => SUBSTR (FND_MSG_PUB.Get (
1963: p_msg_index => FND_MSG_PUB.Count_Msg (),
1964: p_encoded => L_FND_FALSE), 1, 2000),
1965: p_error_message_name => 'INL_ERR_NOT_DEF_PO_PRICE_TOLER',
1966: p_token1_name => 'SHIPLN_NUM',

Line 1963: p_msg_index => FND_MSG_PUB.Count_Msg (),

1959: p_table_name => 'INL_SHIP_LINES',
1960: p_column_name => 'PRIMARY_UNIT_PRICE',
1961: p_column_value => 0,
1962: p_error_message => SUBSTR (FND_MSG_PUB.Get (
1963: p_msg_index => FND_MSG_PUB.Count_Msg (),
1964: p_encoded => L_FND_FALSE), 1, 2000),
1965: p_error_message_name => 'INL_ERR_NOT_DEF_PO_PRICE_TOLER',
1966: p_token1_name => 'SHIPLN_NUM',
1967: p_token1_value => p_ship_line_num,

Line 1991: FND_MSG_PUB.ADD;

1987: x_return_validation_status := 'FALSE';
1988: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_PO_PRICE_TOLER') ;
1989: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
1990: FND_MESSAGE.SET_TOKEN ('TOLER', l_po_price_toler_perc) ;
1991: FND_MSG_PUB.ADD;
1992: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1993: Handle_ShipError (
1994: p_ship_header_id => p_ship_header_id,
1995: p_ship_line_id => p_ship_line_id,

Line 2000: p_error_message => SUBSTR (FND_MSG_PUB.Get (

1996: p_charge_line_id => NULL,
1997: p_table_name => 'INL_SHIP_LINES',
1998: p_column_name => 'PRIMARY_UNIT_PRICE',
1999: p_column_value => 0,
2000: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2001: p_msg_index => FND_MSG_PUB.Count_Msg (),
2002: p_encoded => L_FND_FALSE), 1, 2000),
2003: p_error_message_name => 'INL_ERR_PO_PRICE_TOLER',
2004: p_token1_name => 'SHIPLN_NUM',

Line 2001: p_msg_index => FND_MSG_PUB.Count_Msg (),

1997: p_table_name => 'INL_SHIP_LINES',
1998: p_column_name => 'PRIMARY_UNIT_PRICE',
1999: p_column_value => 0,
2000: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2001: p_msg_index => FND_MSG_PUB.Count_Msg (),
2002: p_encoded => L_FND_FALSE), 1, 2000),
2003: p_error_message_name => 'INL_ERR_PO_PRICE_TOLER',
2004: p_token1_name => 'SHIPLN_NUM',
2005: p_token1_value => p_ship_line_num,

Line 2031: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2027: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2028: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2029: WHEN OTHERS THEN
2030: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2031: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2032: FND_MSG_PUB.Add_Exc_Msg (
2033: p_pkg_name => g_pkg_name,
2034: p_procedure_name => l_program_name) ;
2035: END IF;

Line 2032: FND_MSG_PUB.Add_Exc_Msg (

2028: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2029: WHEN OTHERS THEN
2030: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2031: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2032: FND_MSG_PUB.Add_Exc_Msg (
2033: p_pkg_name => g_pkg_name,
2034: p_procedure_name => l_program_name) ;
2035: END IF;
2036: END Check_PoPriceTolerance;

Line 2112: FND_MSG_PUB.initialize;

2108: -- Standard Start of API savepoint
2109: SAVEPOINT Check_PoTolerances_PVT;
2110: -- Initialize message list if p_init_msg_list is set to TRUE.
2111: IF FND_API.to_Boolean (p_init_msg_list) THEN
2112: FND_MSG_PUB.initialize;
2113: END IF;
2114: -- Check for call compatibility.
2115: IF NOT FND_API.Compatible_API_Call(l_api_version,
2116: p_api_version,

Line 2180: FND_MSG_PUB.Count_And_Get (

2176: IF FND_API.To_Boolean (p_commit) THEN
2177: COMMIT WORK;
2178: END IF;
2179: -- Standard call to get message count and if count is 1, get message info.
2180: FND_MSG_PUB.Count_And_Get (
2181: p_encoded => L_FND_FALSE,
2182: p_count => x_msg_count,
2183: p_data => x_msg_data) ;
2184: -- Standard End of Procedure/Function Logging

Line 2196: FND_MSG_PUB.Count_And_Get (

2192: p_module_name => g_module_name,
2193: p_procedure_name => l_program_name) ;
2194: ROLLBACK TO Check_PoTolerances_PVT;
2195: x_return_status := L_FND_RET_STS_ERROR;
2196: FND_MSG_PUB.Count_And_Get (
2197: p_encoded => L_FND_FALSE,
2198: p_count => x_msg_count,
2199: p_data => x_msg_data) ;
2200: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 2207: FND_MSG_PUB.Count_And_Get (

2203: p_module_name => g_module_name,
2204: p_procedure_name => l_program_name) ;
2205: ROLLBACK TO Check_PoTolerances_PVT;
2206: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2207: FND_MSG_PUB.Count_And_Get (
2208: p_encoded => L_FND_FALSE,
2209: p_count => x_msg_count,
2210: p_data => x_msg_data) ;
2211: WHEN OTHERS THEN

Line 2218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2214: p_module_name => g_module_name,
2215: p_procedure_name => l_program_name) ;
2216: ROLLBACK TO Check_PoTolerances_PVT;
2217: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
2218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2219: FND_MSG_PUB.Add_Exc_Msg (
2220: p_pkg_name => g_pkg_name,
2221: p_procedure_name => l_program_name) ;
2222: END IF;

Line 2219: FND_MSG_PUB.Add_Exc_Msg (

2215: p_procedure_name => l_program_name) ;
2216: ROLLBACK TO Check_PoTolerances_PVT;
2217: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
2218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2219: FND_MSG_PUB.Add_Exc_Msg (
2220: p_pkg_name => g_pkg_name,
2221: p_procedure_name => l_program_name) ;
2222: END IF;
2223: FND_MSG_PUB.Count_And_Get (

Line 2223: FND_MSG_PUB.Count_And_Get (

2219: FND_MSG_PUB.Add_Exc_Msg (
2220: p_pkg_name => g_pkg_name,
2221: p_procedure_name => l_program_name) ;
2222: END IF;
2223: FND_MSG_PUB.Count_And_Get (
2224: p_encoded => L_FND_FALSE,
2225: p_count => x_msg_count,
2226: p_data => x_msg_data) ;
2227: END Check_PoTolerances;

Line 2301: FND_MSG_PUB.initialize;

2297: -- Standard Start of API savepoint
2298: SAVEPOINT Check_PoTolerances_PVT;
2299: -- Initialize message list if p_init_msg_list is set to TRUE.
2300: IF FND_API.to_Boolean (p_init_msg_list) THEN
2301: FND_MSG_PUB.initialize;
2302: END IF;
2303: -- Check for call compatibility.
2304: IF NOT FND_API.Compatible_API_Call (
2305: l_api_version,

Line 2379: FND_MSG_PUB.Count_And_Get (

2375: END IF;
2376: END IF;
2377:
2378: -- Standard call to get message count and if count is 1, get message info.
2379: FND_MSG_PUB.Count_And_Get (
2380: p_encoded => L_FND_FALSE,
2381: p_count => x_msg_count,
2382: p_data => x_msg_data) ;
2383:

Line 2418: FND_MSG_PUB.Count_And_Get (

2414: IF FND_API.To_Boolean (p_commit) THEN
2415: COMMIT WORK;
2416: END IF;
2417: -- Standard call to get message count and if count is 1, get message info.
2418: FND_MSG_PUB.Count_And_Get (
2419: p_encoded => L_FND_FALSE,
2420: p_count => x_msg_count,
2421: p_data => x_msg_data) ;
2422: -- Standard End of Procedure/Function Logging

Line 2434: FND_MSG_PUB.Count_And_Get (

2430: p_module_name => g_module_name,
2431: p_procedure_name => l_program_name) ;
2432: ROLLBACK TO Check_PoTolerances_PVT;
2433: x_return_status := L_FND_RET_STS_ERROR;
2434: FND_MSG_PUB.Count_And_Get (
2435: p_encoded => L_FND_FALSE,
2436: p_count => x_msg_count,
2437: p_data => x_msg_data) ;
2438: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 2445: FND_MSG_PUB.Count_And_Get (

2441: p_module_name => g_module_name,
2442: p_procedure_name => l_program_name) ;
2443: ROLLBACK TO Check_PoTolerances_PVT;
2444: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2445: FND_MSG_PUB.Count_And_Get (
2446: p_encoded => L_FND_FALSE,
2447: p_count => x_msg_count,
2448: p_data => x_msg_data) ;
2449: WHEN OTHERS THEN

Line 2456: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2452: p_module_name => g_module_name,
2453: p_procedure_name => l_program_name) ;
2454: ROLLBACK TO Check_PoTolerances_PVT;
2455: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
2456: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2457: FND_MSG_PUB.Add_Exc_Msg (
2458: p_pkg_name => g_pkg_name,
2459: p_procedure_name => l_program_name) ;
2460: END IF;

Line 2457: FND_MSG_PUB.Add_Exc_Msg (

2453: p_procedure_name => l_program_name) ;
2454: ROLLBACK TO Check_PoTolerances_PVT;
2455: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
2456: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2457: FND_MSG_PUB.Add_Exc_Msg (
2458: p_pkg_name => g_pkg_name,
2459: p_procedure_name => l_program_name) ;
2460: END IF;
2461: FND_MSG_PUB.Count_And_Get (

Line 2461: FND_MSG_PUB.Count_And_Get (

2457: FND_MSG_PUB.Add_Exc_Msg (
2458: p_pkg_name => g_pkg_name,
2459: p_procedure_name => l_program_name) ;
2460: END IF;
2461: FND_MSG_PUB.Count_And_Get (
2462: p_encoded => L_FND_FALSE,
2463: p_count => x_msg_count,
2464: p_data => x_msg_data) ;
2465: END Check_PoTolerances;

Line 2530: FND_MSG_PUB.ADD;

2526: p_debug_info => l_debug_info) ;
2527: IF l_ch_lines_rec.currency_code <> p_functional_currency_code AND p_foreign_currency_flag = 'N' THEN
2528: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_FRGN_CUR') ;
2529: FND_MESSAGE.SET_TOKEN ('CLNUM', l_ch_lines_rec.charge_line_num) ;
2530: FND_MSG_PUB.ADD;
2531: -- INCLUDE A LINE IN INL_SHIP_HOLdS
2532: Handle_ShipError (
2533: p_ship_header_id => p_ship_header_id,
2534: p_ship_line_id => NULL,

Line 2539: p_error_message => SUBSTR (FND_MSG_PUB.Get (

2535: p_charge_line_id => l_ch_lines_rec.charge_line_id,
2536: p_table_name => 'INL_CHARGE_LINES',
2537: p_column_name => 'CURRENCY_CODE',
2538: p_column_value => l_ch_lines_rec.CURRENCY_CODE,
2539: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2540: p_msg_index => FND_MSG_PUB.Count_Msg (),
2541: p_encoded => L_FND_FALSE), 1, 2000),
2542: p_error_message_name => 'INL_ERR_CHK_FRGN_CUR',
2543: p_token1_name => 'CLNUM',

Line 2540: p_msg_index => FND_MSG_PUB.Count_Msg (),

2536: p_table_name => 'INL_CHARGE_LINES',
2537: p_column_name => 'CURRENCY_CODE',
2538: p_column_value => l_ch_lines_rec.CURRENCY_CODE,
2539: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2540: p_msg_index => FND_MSG_PUB.Count_Msg (),
2541: p_encoded => L_FND_FALSE), 1, 2000),
2542: p_error_message_name => 'INL_ERR_CHK_FRGN_CUR',
2543: p_token1_name => 'CLNUM',
2544: p_token1_value => l_ch_lines_rec.charge_line_num,

Line 2587: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2583: INL_LOGGING_PVT.Log_UnexpecError (
2584: p_module_name => g_module_name,
2585: p_procedure_name => l_program_name) ;
2586: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2587: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2588: FND_MSG_PUB.Add_Exc_Msg (
2589: p_pkg_name => g_pkg_name,
2590: p_procedure_name => l_program_name) ;
2591: END IF;

Line 2588: FND_MSG_PUB.Add_Exc_Msg (

2584: p_module_name => g_module_name,
2585: p_procedure_name => l_program_name) ;
2586: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2587: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2588: FND_MSG_PUB.Add_Exc_Msg (
2589: p_pkg_name => g_pkg_name,
2590: p_procedure_name => l_program_name) ;
2591: END IF;
2592: END Validate_ChargeLine;

Line 2655: FND_MSG_PUB.ADD;

2651: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_INVALID_SRC_OPUNIT') ;
2652: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
2653: FND_MESSAGE.SET_TOKEN ('LCM_OPUNIT', l_lcm_org_name) ;
2654: FND_MESSAGE.SET_TOKEN ('PO_OPUNIT', l_po_org_name) ;
2655: FND_MSG_PUB.ADD;
2656: -- INCLUDE A LINE IN INL_SHIP_HOLdS
2657: Handle_ShipError (
2658: p_ship_header_id => p_ship_header_id,
2659: p_ship_line_id => p_ship_line_id,

Line 2664: p_error_message => SUBSTR (FND_MSG_PUB.Get (

2660: p_charge_line_id => NULL,
2661: p_table_name => 'INL_SHIP_HEADERS',
2662: p_column_name => 'ORG_ID',
2663: p_column_value => 0,
2664: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2665: p_msg_index => FND_MSG_PUB.Count_Msg (),
2666: p_encoded => L_FND_FALSE), 1, 2000),
2667: p_error_message_name => 'INL_ERR_INVALID_SRC_OPUNIT',
2668: p_token1_name => 'SHIPLN_NUM',

Line 2665: p_msg_index => FND_MSG_PUB.Count_Msg (),

2661: p_table_name => 'INL_SHIP_HEADERS',
2662: p_column_name => 'ORG_ID',
2663: p_column_value => 0,
2664: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2665: p_msg_index => FND_MSG_PUB.Count_Msg (),
2666: p_encoded => L_FND_FALSE), 1, 2000),
2667: p_error_message_name => 'INL_ERR_INVALID_SRC_OPUNIT',
2668: p_token1_name => 'SHIPLN_NUM',
2669: p_token1_value => p_ship_line_num,

Line 2702: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2698: INL_LOGGING_PVT.Log_UnexpecError (
2699: p_module_name => g_module_name,
2700: p_procedure_name => l_program_name) ;
2701: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2702: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2703: FND_MSG_PUB.Add_Exc_Msg (
2704: p_pkg_name => g_pkg_name,
2705: p_procedure_name => l_program_name) ;
2706: END IF;

Line 2703: FND_MSG_PUB.Add_Exc_Msg (

2699: p_module_name => g_module_name,
2700: p_procedure_name => l_program_name) ;
2701: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2702: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2703: FND_MSG_PUB.Add_Exc_Msg (
2704: p_pkg_name => g_pkg_name,
2705: p_procedure_name => l_program_name) ;
2706: END IF;
2707: END Validate_SrcOperatingUnit;

Line 2781: FND_MSG_PUB.ADD;

2777: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_3RD_PTY_ST_ALLOWED') ;
2778: FND_MESSAGE.SET_TOKEN ('GROUP_REF', p_group_reference) ;
2779: FND_MESSAGE.SET_TOKEN ('PARTY_SITE', p_party_site_name) ;
2780: FND_MESSAGE.SET_TOKEN ('SHIP_TYPE', p_ship_type_code) ;
2781: FND_MSG_PUB.ADD;
2782: -- INCLUDE A LINE IN INL_SHIP_HOLDS
2783: Handle_ShipError (
2784: p_ship_header_id => p_ship_header_id,
2785: p_ship_line_id => NULL,

Line 2790: p_error_message => SUBSTR (FND_MSG_PUB.Get (

2786: p_charge_line_id => NULL,
2787: p_table_name => 'INL_SHIP_LINE_GROUPS',
2788: p_column_name => 'PARTY_SITE_ID',
2789: p_column_value => p_party_site_id,
2790: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2791: p_msg_index => FND_MSG_PUB.Count_Msg (),
2792: p_encoded => L_FND_FALSE), 1, 2000),
2793: p_error_message_name => 'INL_ERR_3RD_PTY_ST_ALLOWED',
2794: p_token1_name => 'GROUP_REF',

Line 2791: p_msg_index => FND_MSG_PUB.Count_Msg (),

2787: p_table_name => 'INL_SHIP_LINE_GROUPS',
2788: p_column_name => 'PARTY_SITE_ID',
2789: p_column_value => p_party_site_id,
2790: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2791: p_msg_index => FND_MSG_PUB.Count_Msg (),
2792: p_encoded => L_FND_FALSE), 1, 2000),
2793: p_error_message_name => 'INL_ERR_3RD_PTY_ST_ALLOWED',
2794: p_token1_name => 'GROUP_REF',
2795: p_token1_value => p_group_reference,

Line 2828: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2824: INL_LOGGING_PVT.Log_UnexpecError (
2825: p_module_name => g_module_name,
2826: p_procedure_name => l_program_name) ;
2827: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2828: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2829: FND_MSG_PUB.Add_Exc_Msg (
2830: p_pkg_name => g_pkg_name,
2831: p_procedure_name => l_program_name) ;
2832: END IF;

Line 2829: FND_MSG_PUB.Add_Exc_Msg (

2825: p_module_name => g_module_name,
2826: p_procedure_name => l_program_name) ;
2827: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2828: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2829: FND_MSG_PUB.Add_Exc_Msg (
2830: p_pkg_name => g_pkg_name,
2831: p_procedure_name => l_program_name) ;
2832: END IF;
2833: END Validate_ThirdPartySiteAllowed;

Line 3071: FND_MSG_PUB.ADD;

3067: l_prev_party_id:= l_sl_parties_lst(i).party_id;
3068: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_VEN_INV') ;
3069: FND_MESSAGE.SET_TOKEN ('P_LN_GROUP_NUM', p_ln_group_num) ;
3070: FND_MESSAGE.SET_TOKEN ('P_VENDOR_NAME', l_sl_parties_lst(i).vendor_name) ;
3071: FND_MSG_PUB.ADD;
3072:
3073: Handle_ShipError (
3074: p_ship_header_id => p_ship_header_id,
3075: p_ship_line_id => NULL,

Line 3080: p_error_message => SUBSTR (FND_MSG_PUB.Get (

3076: p_charge_line_id => NULL,
3077: p_table_name => 'INL_SHIP_LINE_GROUPS',
3078: p_column_name => 'PARTY_ID',
3079: p_column_value => p_party_id,
3080: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3081: p_msg_index => FND_MSG_PUB.Count_Msg (),
3082: p_encoded => L_FND_FALSE), 1, 2000),
3083: p_error_message_name => 'INL_ERR_CHK_VEN_INV',
3084: p_token1_name => 'P_LN_GROUP_NUM',

Line 3081: p_msg_index => FND_MSG_PUB.Count_Msg (),

3077: p_table_name => 'INL_SHIP_LINE_GROUPS',
3078: p_column_name => 'PARTY_ID',
3079: p_column_value => p_party_id,
3080: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3081: p_msg_index => FND_MSG_PUB.Count_Msg (),
3082: p_encoded => L_FND_FALSE), 1, 2000),
3083: p_error_message_name => 'INL_ERR_CHK_VEN_INV',
3084: p_token1_name => 'P_LN_GROUP_NUM',
3085: p_token1_value => p_ln_group_num,

Line 3179: FND_MSG_PUB.ADD;

3175:
3176: FND_MESSAGE.SET_NAME ('INL', l_msg) ;
3177: FND_MESSAGE.SET_TOKEN ('P_LN_GROUP_NUM', p_ln_group_num) ;
3178: FND_MESSAGE.SET_TOKEN ('P_VENDOR_NAME', l_sl_parties_lst(i).vendor_name) ;
3179: FND_MSG_PUB.ADD;
3180:
3181: Handle_ShipError (
3182: p_ship_header_id => p_ship_header_id,
3183: p_ship_line_id => NULL,

Line 3188: p_error_message => SUBSTR (FND_MSG_PUB.Get (

3184: p_charge_line_id => NULL,
3185: p_table_name => 'INL_SHIP_LINE_GROUPS',
3186: p_column_name => 'PARTY_ID',
3187: p_column_value => p_party_id,
3188: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3189: p_msg_index => FND_MSG_PUB.Count_Msg (),
3190: p_encoded => L_FND_FALSE), 1, 2000),
3191: p_error_message_name => l_msg,
3192: p_token1_name => 'P_LN_GROUP_NUM',

Line 3189: p_msg_index => FND_MSG_PUB.Count_Msg (),

3185: p_table_name => 'INL_SHIP_LINE_GROUPS',
3186: p_column_name => 'PARTY_ID',
3187: p_column_value => p_party_id,
3188: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3189: p_msg_index => FND_MSG_PUB.Count_Msg (),
3190: p_encoded => L_FND_FALSE), 1, 2000),
3191: p_error_message_name => l_msg,
3192: p_token1_name => 'P_LN_GROUP_NUM',
3193: p_token1_value => p_ln_group_num,

Line 3344: FND_MSG_PUB.ADD;

3340: FND_MESSAGE.SET_NAME ('INL', l_msg) ;
3341: FND_MESSAGE.SET_TOKEN ('P_LN_GROUP_NUM', p_ln_group_num) ;
3342: FND_MESSAGE.SET_TOKEN ('P_VENDOR_SITE_CODE', l_sl_parties_lst(i).vendor_site_code) ;
3343: FND_MESSAGE.SET_TOKEN ('P_LINES', l_ln_num) ;
3344: FND_MSG_PUB.ADD;
3345: Handle_ShipError (
3346: p_ship_header_id => p_ship_header_id,
3347: p_ship_line_id => NULL,
3348: p_charge_line_id => NULL,

Line 3352: p_error_message => SUBSTR (FND_MSG_PUB.Get (

3348: p_charge_line_id => NULL,
3349: p_table_name => 'INL_SHIP_LINE_GROUPS',
3350: p_column_name => 'PARTY_SITE_ID',
3351: p_column_value => p_party_site_id,
3352: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3353: p_msg_index => FND_MSG_PUB.Count_Msg (),
3354: p_encoded => L_FND_FALSE), 1, 2000),
3355: p_error_message_name => l_msg,
3356: p_token1_name => 'P_LN_GROUP_NUM',

Line 3353: p_msg_index => FND_MSG_PUB.Count_Msg (),

3349: p_table_name => 'INL_SHIP_LINE_GROUPS',
3350: p_column_name => 'PARTY_SITE_ID',
3351: p_column_value => p_party_site_id,
3352: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3353: p_msg_index => FND_MSG_PUB.Count_Msg (),
3354: p_encoded => L_FND_FALSE), 1, 2000),
3355: p_error_message_name => l_msg,
3356: p_token1_name => 'P_LN_GROUP_NUM',
3357: p_token1_value => p_ln_group_num,

Line 3405: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3401: INL_LOGGING_PVT.Log_UnexpecError (
3402: p_module_name => g_module_name,
3403: p_procedure_name => l_program_name) ;
3404: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3405: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3406: FND_MSG_PUB.Add_Exc_Msg (
3407: p_pkg_name => g_pkg_name,
3408: p_procedure_name => l_program_name) ;
3409: END IF;

Line 3406: FND_MSG_PUB.Add_Exc_Msg (

3402: p_module_name => g_module_name,
3403: p_procedure_name => l_program_name) ;
3404: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3405: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3406: FND_MSG_PUB.Add_Exc_Msg (
3407: p_pkg_name => g_pkg_name,
3408: p_procedure_name => l_program_name) ;
3409: END IF;
3410: END Validate_LineGroup;

Line 3495: FND_MSG_PUB.ADD;

3491: IF l_count_associations > 0 THEN
3492: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_ASSOC_ALLOC_FLAG_DISAB') ;
3493: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
3494: FND_MESSAGE.SET_TOKEN ('SHIPLN_TYPE', p_ship_line_type_code) ;
3495: FND_MSG_PUB.ADD;
3496: -- INCLUDE A LINE IN INL_SHIP_HOLDS
3497: Handle_ShipError (
3498: p_ship_header_id => p_ship_header_id,
3499: p_ship_line_id => p_ship_line_id,

Line 3504: p_error_message => SUBSTR (FND_MSG_PUB.Get (

3500: p_charge_line_id => NULL,
3501: p_table_name => 'INL_SHIP_LINES',
3502: p_column_name => 'SHIP_LINE_TYPE_ID',
3503: p_column_value => 0,
3504: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3505: p_msg_index => FND_MSG_PUB.Count_Msg (),
3506: p_encoded => L_FND_FALSE), 1, 2000),
3507: p_error_message_name => 'INL_ERR_ASSOC_ALLOC_FLAG_DISAB',
3508: p_token1_name => 'SHIPLN_NUM',

Line 3505: p_msg_index => FND_MSG_PUB.Count_Msg (),

3501: p_table_name => 'INL_SHIP_LINES',
3502: p_column_name => 'SHIP_LINE_TYPE_ID',
3503: p_column_value => 0,
3504: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3505: p_msg_index => FND_MSG_PUB.Count_Msg (),
3506: p_encoded => L_FND_FALSE), 1, 2000),
3507: p_error_message_name => 'INL_ERR_ASSOC_ALLOC_FLAG_DISAB',
3508: p_token1_name => 'SHIPLN_NUM',
3509: p_token1_value => p_ship_line_num,

Line 3534: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3530: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
3531: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3532: WHEN OTHERS THEN
3533: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3534: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3535: FND_MSG_PUB.Add_Exc_Msg (
3536: p_pkg_name => g_pkg_name,
3537: p_procedure_name => l_program_name) ;
3538: END IF;

Line 3535: FND_MSG_PUB.Add_Exc_Msg (

3531: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3532: WHEN OTHERS THEN
3533: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3534: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3535: FND_MSG_PUB.Add_Exc_Msg (
3536: p_pkg_name => g_pkg_name,
3537: p_procedure_name => l_program_name) ;
3538: END IF;
3539: END Validate_AllocEnabledFlag;

Line 3693: FND_MSG_PUB.ADD;

3689:
3690: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_LOC_CLOSE_CODE') ;
3691: FND_MESSAGE.SET_TOKEN ('LNGRP_NUM', l_ship_ln_grp_num) ;
3692: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', l_ship_line_num) ;
3693: FND_MSG_PUB.ADD;
3694: l_debug_info := 'Line Location is not in OPEN status';
3695:
3696: INL_LOGGING_PVT.Log_Statement (
3697: p_module_name => g_pkg_name,

Line 3713: p_error_message => SUBSTR (FND_MSG_PUB.Get (

3709: p_charge_line_id => NULL,
3710: p_table_name => 'INL_SHIP_LINES',
3711: p_column_name => 'SHIP_LINE_SOURCE_ID',
3712: p_column_value => l_ship_lines_rec.ship_line_source_id,
3713: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3714: p_msg_index => FND_MSG_PUB.Count_Msg (),
3715: p_encoded => L_FND_FALSE), 1, 2000),
3716: p_error_message_name => 'INL_ERR_CHK_LOC_CLOSE_CODE',
3717: p_token1_name => 'LNGRP_NUM',

Line 3714: p_msg_index => FND_MSG_PUB.Count_Msg (),

3710: p_table_name => 'INL_SHIP_LINES',
3711: p_column_name => 'SHIP_LINE_SOURCE_ID',
3712: p_column_value => l_ship_lines_rec.ship_line_source_id,
3713: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3714: p_msg_index => FND_MSG_PUB.Count_Msg (),
3715: p_encoded => L_FND_FALSE), 1, 2000),
3716: p_error_message_name => 'INL_ERR_CHK_LOC_CLOSE_CODE',
3717: p_token1_name => 'LNGRP_NUM',
3718: p_token1_value => l_ship_ln_grp_num,

Line 3884: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3880: INL_LOGGING_PVT.Log_UnexpecError (
3881: p_module_name => g_module_name,
3882: p_procedure_name => l_program_name) ;
3883: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3884: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3885: FND_MSG_PUB.Add_Exc_Msg (
3886: p_pkg_name => g_pkg_name,
3887: p_procedure_name => l_program_name) ;
3888: END IF;

Line 3885: FND_MSG_PUB.Add_Exc_Msg (

3881: p_module_name => g_module_name,
3882: p_procedure_name => l_program_name) ;
3883: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3884: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3885: FND_MSG_PUB.Add_Exc_Msg (
3886: p_pkg_name => g_pkg_name,
3887: p_procedure_name => l_program_name) ;
3888: END IF;
3889: END Validate_ShipLine;

Line 3982: FND_MSG_PUB.ADD;

3978: AND TRUNC(l_ship_date) > l_sysdate
3979: THEN
3980:
3981: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_RCV_SHIP_DATE') ;
3982: FND_MSG_PUB.ADD;
3983: l_debug_info := 'Shipment date greater than current date.';
3984: INL_LOGGING_PVT.Log_Statement (
3985: p_module_name => g_pkg_name,
3986: p_procedure_name => l_program_name,

Line 4001: p_error_message => SUBSTR (FND_MSG_PUB.Get (

3997: p_charge_line_id => NULL,
3998: p_table_name => 'INL_SHIP_HEADERS',
3999: p_column_name => 'SHIP_DATE',
4000: p_column_value => TO_CHAR (l_ship_date),
4001: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4002: p_msg_index => FND_MSG_PUB.Count_Msg (),
4003: p_encoded => L_FND_FALSE), 1, 2000),
4004: p_error_message_name => 'INL_ERR_CHK_RCV_SHIP_DATE',
4005: p_token1_name => NULL,

Line 4002: p_msg_index => FND_MSG_PUB.Count_Msg (),

3998: p_table_name => 'INL_SHIP_HEADERS',
3999: p_column_name => 'SHIP_DATE',
4000: p_column_value => TO_CHAR (l_ship_date),
4001: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4002: p_msg_index => FND_MSG_PUB.Count_Msg (),
4003: p_encoded => L_FND_FALSE), 1, 2000),
4004: p_error_message_name => 'INL_ERR_CHK_RCV_SHIP_DATE',
4005: p_token1_name => NULL,
4006: p_token1_value => NULL,

Line 4049: FND_MSG_PUB.ADD;

4045: x_return_status => l_return_status) = 'FALSE'
4046: THEN
4047: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_INV_SHIP_DATE') ;
4048: FND_MESSAGE.SET_TOKEN ('SHIP_DATE', TO_CHAR (l_ship_date)) ;
4049: FND_MSG_PUB.ADD;
4050: l_debug_info := 'Transaction period is not open in Inventory.';
4051: INL_LOGGING_PVT.Log_Statement (
4052: p_module_name => g_pkg_name,
4053: p_procedure_name => l_program_name,

Line 4068: p_error_message => SUBSTR (FND_MSG_PUB.Get (

4064: p_charge_line_id => NULL,
4065: p_table_name => 'INL_SHIP_HEADERS',
4066: p_column_name => 'SHIP_DATE',
4067: p_column_value => TO_CHAR (l_ship_date),
4068: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4069: p_msg_index => FND_MSG_PUB.Count_Msg (),
4070: p_encoded => L_FND_FALSE), 1, 2000),
4071: p_error_message_name => 'INL_ERR_CHK_INV_SHIP_DATE',
4072: p_token1_name => 'SHIP_DATE',

Line 4069: p_msg_index => FND_MSG_PUB.Count_Msg (),

4065: p_table_name => 'INL_SHIP_HEADERS',
4066: p_column_name => 'SHIP_DATE',
4067: p_column_value => TO_CHAR (l_ship_date),
4068: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4069: p_msg_index => FND_MSG_PUB.Count_Msg (),
4070: p_encoded => L_FND_FALSE), 1, 2000),
4071: p_error_message_name => 'INL_ERR_CHK_INV_SHIP_DATE',
4072: p_token1_name => 'SHIP_DATE',
4073: p_token1_value => TO_CHAR (l_ship_date),

Line 4101: FND_MSG_PUB.ADD;

4097: IF (NOT Has_ShipLine (p_ship_header_id, l_group_line_num)) THEN -- Bug #12630218
4098: IF l_group_line_num IS NOT NULL THEN
4099: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_NO_SHIP_LN_GRP_NUM');
4100: FND_MESSAGE.SET_TOKEN('LINE_GROUP_NUM',l_group_line_num);
4101: FND_MSG_PUB.ADD;
4102: -- INCLUDE A LINE IN INL_SHIP_HOLDS
4103: Handle_ShipError (
4104: p_ship_header_id => p_ship_header_id,
4105: p_ship_line_id => NULL,

Line 4110: p_error_message => SUBSTR (FND_MSG_PUB.Get (

4106: p_charge_line_id => NULL,
4107: p_table_name => 'INL_SHIP_HEADERS',
4108: p_column_name => 'SHIP_TYPE_ID',
4109: p_column_value => l_ship_type_id,
4110: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4111: p_msg_index => FND_MSG_PUB.Count_Msg (),
4112: p_encoded => L_FND_FALSE), 1, 2000),
4113: p_error_message_name => 'INL_ERR_CHK_NO_SHIP_LN_GRP_NUM',
4114: p_token1_name => 'LINE_GROUP_NUM',

Line 4111: p_msg_index => FND_MSG_PUB.Count_Msg (),

4107: p_table_name => 'INL_SHIP_HEADERS',
4108: p_column_name => 'SHIP_TYPE_ID',
4109: p_column_value => l_ship_type_id,
4110: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4111: p_msg_index => FND_MSG_PUB.Count_Msg (),
4112: p_encoded => L_FND_FALSE), 1, 2000),
4113: p_error_message_name => 'INL_ERR_CHK_NO_SHIP_LN_GRP_NUM',
4114: p_token1_name => 'LINE_GROUP_NUM',
4115: p_token1_value => l_group_line_num,

Line 4133: FND_MSG_PUB.ADD;

4129: RAISE L_FND_EXC_UNEXPECTED_ERROR;
4130: END IF;
4131: ELSE -- Bug 12630218 Shipment has no Group Lines
4132: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_NO_SHIP_LN');
4133: FND_MSG_PUB.ADD;
4134: -- INCLUDE A LINE IN INL_SHIP_HOLDS
4135: Handle_ShipError (
4136: p_ship_header_id => p_ship_header_id,
4137: p_ship_line_id => NULL,

Line 4142: p_error_message => SUBSTR (FND_MSG_PUB.Get (

4138: p_charge_line_id => NULL,
4139: p_table_name => 'INL_SHIP_HEADERS',
4140: p_column_name => 'SHIP_TYPE_ID',
4141: p_column_value => l_ship_type_id,
4142: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4143: p_msg_index => FND_MSG_PUB.Count_Msg (),
4144: p_encoded => L_FND_FALSE), 1, 2000),
4145: p_error_message_name => 'INL_ERR_CHK_NO_SHIP_LN',
4146: p_token1_name => NULL,

Line 4143: p_msg_index => FND_MSG_PUB.Count_Msg (),

4139: p_table_name => 'INL_SHIP_HEADERS',
4140: p_column_name => 'SHIP_TYPE_ID',
4141: p_column_value => l_ship_type_id,
4142: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4143: p_msg_index => FND_MSG_PUB.Count_Msg (),
4144: p_encoded => L_FND_FALSE), 1, 2000),
4145: p_error_message_name => 'INL_ERR_CHK_NO_SHIP_LN',
4146: p_token1_name => NULL,
4147: p_token1_value => NULL,

Line 4250: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4246: INL_LOGGING_PVT.Log_UnexpecError (
4247: p_module_name => g_module_name,
4248: p_procedure_name => l_program_name) ;
4249: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
4250: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4251: FND_MSG_PUB.Add_Exc_Msg (
4252: p_pkg_name => g_pkg_name,
4253: p_procedure_name => l_program_name) ;
4254: END IF;

Line 4251: FND_MSG_PUB.Add_Exc_Msg (

4247: p_module_name => g_module_name,
4248: p_procedure_name => l_program_name) ;
4249: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
4250: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4251: FND_MSG_PUB.Add_Exc_Msg (
4252: p_pkg_name => g_pkg_name,
4253: p_procedure_name => l_program_name) ;
4254: END IF;
4255: END Validate_ShipHdr;

Line 4345: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4341: INL_LOGGING_PVT.Log_UnexpecError (
4342: p_module_name => g_module_name,
4343: p_procedure_name => l_program_name) ;
4344: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
4345: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4346: FND_MSG_PUB.Add_Exc_Msg (
4347: p_pkg_name => g_pkg_name,
4348: p_procedure_name => l_program_name) ;
4349: END IF;

Line 4346: FND_MSG_PUB.Add_Exc_Msg (

4342: p_module_name => g_module_name,
4343: p_procedure_name => l_program_name) ;
4344: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
4345: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4346: FND_MSG_PUB.Add_Exc_Msg (
4347: p_pkg_name => g_pkg_name,
4348: p_procedure_name => l_program_name) ;
4349: END IF;
4350: RETURN 'FALSE';

Line 4397: FND_MSG_PUB.initialize;

4393: -- Standard Start of API savepoint
4394: SAVEPOINT Validate_Shipment_PVT;
4395: -- Initialize message list if p_init_msg_list is set to TRUE.
4396: IF FND_API.to_Boolean (p_init_msg_list) THEN
4397: FND_MSG_PUB.initialize;
4398: END IF;
4399: -- Check for call compatibility.
4400: IF NOT FND_API.Compatible_API_Call (
4401: p_current_version_number => l_api_version,

Line 4446: l_debug_info := 'fnd_msg_pub.count_msg';

4442: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
4443: x_return_status := l_return_status;
4444: RAISE L_FND_EXC_UNEXPECTED_ERROR;
4445: END IF;
4446: l_debug_info := 'fnd_msg_pub.count_msg';
4447: INL_LOGGING_PVT.Log_Variable (
4448: p_module_name => g_module_name,
4449: p_procedure_name => l_api_name,
4450: p_var_name => 'fnd_msg_pub.count_msg',

Line 4450: p_var_name => 'fnd_msg_pub.count_msg',

4446: l_debug_info := 'fnd_msg_pub.count_msg';
4447: INL_LOGGING_PVT.Log_Variable (
4448: p_module_name => g_module_name,
4449: p_procedure_name => l_api_name,
4450: p_var_name => 'fnd_msg_pub.count_msg',
4451: p_var_value => TO_CHAR (fnd_msg_pub.count_msg)) ;
4452: IF (NVL (fnd_msg_pub.count_msg, 0) = 0) THEN
4453: SELECT ship_status_code
4454: INTO l_ship_status

Line 4451: p_var_value => TO_CHAR (fnd_msg_pub.count_msg)) ;

4447: INL_LOGGING_PVT.Log_Variable (
4448: p_module_name => g_module_name,
4449: p_procedure_name => l_api_name,
4450: p_var_name => 'fnd_msg_pub.count_msg',
4451: p_var_value => TO_CHAR (fnd_msg_pub.count_msg)) ;
4452: IF (NVL (fnd_msg_pub.count_msg, 0) = 0) THEN
4453: SELECT ship_status_code
4454: INTO l_ship_status
4455: FROM inl_ship_headers

Line 4452: IF (NVL (fnd_msg_pub.count_msg, 0) = 0) THEN

4448: p_module_name => g_module_name,
4449: p_procedure_name => l_api_name,
4450: p_var_name => 'fnd_msg_pub.count_msg',
4451: p_var_value => TO_CHAR (fnd_msg_pub.count_msg)) ;
4452: IF (NVL (fnd_msg_pub.count_msg, 0) = 0) THEN
4453: SELECT ship_status_code
4454: INTO l_ship_status
4455: FROM inl_ship_headers
4456: WHERE ship_header_id = p_ship_header_id;

Line 4486: FND_MSG_PUB.Count_And_Get (

4482: IF FND_API.To_Boolean (p_commit) THEN
4483: COMMIT WORK;
4484: END IF;
4485: -- Standard call to get message count and if count is 1, get message info.
4486: FND_MSG_PUB.Count_And_Get (
4487: p_encoded => L_FND_FALSE,
4488: p_count => x_msg_count,
4489: p_data => x_msg_data) ;
4490: INL_LOGGING_PVT.Log_EndProc (

Line 4500: FND_MSG_PUB.Count_And_Get (

4496: p_module_name => g_module_name,
4497: p_procedure_name => l_api_name) ;
4498: ROLLBACK TO Validate_Shipment_PVT;
4499: x_return_status := L_FND_RET_STS_ERROR;
4500: FND_MSG_PUB.Count_And_Get (
4501: p_encoded => L_FND_FALSE,
4502: p_count => x_msg_count,
4503: p_data => x_msg_data) ;
4504: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 4510: FND_MSG_PUB.Count_And_Get (

4506: p_module_name => g_module_name,
4507: p_procedure_name => l_api_name) ;
4508: ROLLBACK TO Validate_Shipment_PVT;
4509: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
4510: FND_MSG_PUB.Count_And_Get (
4511: p_encoded => L_FND_FALSE,
4512: p_count => x_msg_count,
4513: p_data => x_msg_data) ;
4514: WHEN OTHERS THEN

Line 4520: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4516: p_module_name => g_module_name,
4517: p_procedure_name => l_api_name) ;
4518: ROLLBACK TO Validate_Shipment_PVT;
4519: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
4520: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4521: FND_MSG_PUB.Add_Exc_Msg (
4522: p_pkg_name => g_pkg_name,
4523: p_procedure_name => l_api_name) ;
4524: END IF;

Line 4521: FND_MSG_PUB.Add_Exc_Msg (

4517: p_procedure_name => l_api_name) ;
4518: ROLLBACK TO Validate_Shipment_PVT;
4519: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
4520: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4521: FND_MSG_PUB.Add_Exc_Msg (
4522: p_pkg_name => g_pkg_name,
4523: p_procedure_name => l_api_name) ;
4524: END IF;
4525: FND_MSG_PUB.Count_And_Get (

Line 4525: FND_MSG_PUB.Count_And_Get (

4521: FND_MSG_PUB.Add_Exc_Msg (
4522: p_pkg_name => g_pkg_name,
4523: p_procedure_name => l_api_name) ;
4524: END IF;
4525: FND_MSG_PUB.Count_And_Get (
4526: p_encoded => L_FND_FALSE,
4527: p_count => x_msg_count,
4528: p_data => x_msg_data) ;
4529: END Validate_Shipment;

Line 4658: IF FND_MSG_PUB.Check_Msg_Level(

4654: p_module_name => g_module_name,
4655: p_procedure_name => l_program_name
4656: );
4657: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
4658: IF FND_MSG_PUB.Check_Msg_Level(
4659: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4660: ) THEN
4661: FND_MSG_PUB.Add_Exc_Msg (
4662: p_pkg_name => g_pkg_name,

Line 4659: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4655: p_procedure_name => l_program_name
4656: );
4657: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
4658: IF FND_MSG_PUB.Check_Msg_Level(
4659: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4660: ) THEN
4661: FND_MSG_PUB.Add_Exc_Msg (
4662: p_pkg_name => g_pkg_name,
4663: p_procedure_name => l_program_name

Line 4661: FND_MSG_PUB.Add_Exc_Msg (

4657: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
4658: IF FND_MSG_PUB.Check_Msg_Level(
4659: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4660: ) THEN
4661: FND_MSG_PUB.Add_Exc_Msg (
4662: p_pkg_name => g_pkg_name,
4663: p_procedure_name => l_program_name
4664: );
4665: END IF;

Line 4845: IF FND_MSG_PUB.Check_Msg_Level(

4841: p_module_name => g_module_name,
4842: p_procedure_name => l_program_name
4843: );
4844: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
4845: IF FND_MSG_PUB.Check_Msg_Level(
4846: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4847: ) THEN
4848: FND_MSG_PUB.Add_Exc_Msg(
4849: p_pkg_name => g_pkg_name,

Line 4846: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4842: p_procedure_name => l_program_name
4843: );
4844: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
4845: IF FND_MSG_PUB.Check_Msg_Level(
4846: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4847: ) THEN
4848: FND_MSG_PUB.Add_Exc_Msg(
4849: p_pkg_name => g_pkg_name,
4850: p_procedure_name=> l_program_name

Line 4848: FND_MSG_PUB.Add_Exc_Msg(

4844: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
4845: IF FND_MSG_PUB.Check_Msg_Level(
4846: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4847: ) THEN
4848: FND_MSG_PUB.Add_Exc_Msg(
4849: p_pkg_name => g_pkg_name,
4850: p_procedure_name=> l_program_name
4851: );
4852: END IF;

Line 5077: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5073: p_module_name => g_module_name,
5074: p_procedure_name => l_program_name
5075: ) ;
5076: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
5077: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5078: FND_MSG_PUB.Add_Exc_Msg (
5079: p_pkg_name => g_pkg_name,
5080: p_procedure_name => l_program_name
5081: ) ;

Line 5078: FND_MSG_PUB.Add_Exc_Msg (

5074: p_procedure_name => l_program_name
5075: ) ;
5076: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
5077: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5078: FND_MSG_PUB.Add_Exc_Msg (
5079: p_pkg_name => g_pkg_name,
5080: p_procedure_name => l_program_name
5081: ) ;
5082: END IF;

Line 5231: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5227: p_module_name => g_module_name,
5228: p_procedure_name => l_program_name
5229: ) ;
5230: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
5231: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5232: FND_MSG_PUB.Add_Exc_Msg (
5233: p_pkg_name => g_pkg_name,
5234: p_procedure_name => l_program_name
5235: ) ;

Line 5232: FND_MSG_PUB.Add_Exc_Msg (

5228: p_procedure_name => l_program_name
5229: ) ;
5230: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
5231: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5232: FND_MSG_PUB.Add_Exc_Msg (
5233: p_pkg_name => g_pkg_name,
5234: p_procedure_name => l_program_name
5235: ) ;
5236: END IF;

Line 5405: FND_MSG_PUB.initialize;

5401: -- Standard Start of API savepoint
5402: SAVEPOINT Adjust_ShipLines_PVT;
5403: -- Initialize message list if p_init_msg_list is set to TRUE.
5404: IF FND_API.to_Boolean (p_init_msg_list) THEN
5405: FND_MSG_PUB.initialize;
5406: END IF;
5407: -- Check for call compatibility.
5408: IF NOT FND_API.Compatible_API_Call (
5409: p_current_version_number => l_api_version,

Line 6175: FND_MSG_PUB.Count_And_Get (

6171: IF FND_API.To_Boolean (p_commit) THEN
6172: COMMIT WORK;
6173: END IF;
6174: -- Standard call to get message count and if count is 1, get message info.
6175: FND_MSG_PUB.Count_And_Get (
6176: p_encoded => L_FND_FALSE,
6177: p_count => x_msg_count,
6178: p_data => x_msg_data
6179: ) ;

Line 6194: FND_MSG_PUB.Count_And_Get (

6190: p_procedure_name => l_api_name
6191: ) ;
6192: ROLLBACK TO Adjust_ShipLines_PVT;
6193: x_return_status := L_FND_RET_STS_ERROR;
6194: FND_MSG_PUB.Count_And_Get (
6195: p_encoded => L_FND_FALSE,
6196: p_count => x_msg_count,
6197: p_data => x_msg_data
6198: ) ;

Line 6207: FND_MSG_PUB.Count_And_Get (

6203: p_procedure_name => l_api_name
6204: ) ;
6205: ROLLBACK TO Adjust_ShipLines_PVT;
6206: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
6207: FND_MSG_PUB.Count_And_Get (
6208: p_encoded => L_FND_FALSE,
6209: p_count => x_msg_count,
6210: p_data => x_msg_data
6211: ) ;

Line 6220: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6216: p_procedure_name => l_api_name
6217: ) ;
6218: ROLLBACK TO Adjust_ShipLines_PVT;
6219: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
6220: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6221: FND_MSG_PUB.Add_Exc_Msg (
6222: p_pkg_name => g_pkg_name,
6223: p_procedure_name => l_api_name
6224: ) ;

Line 6221: FND_MSG_PUB.Add_Exc_Msg (

6217: ) ;
6218: ROLLBACK TO Adjust_ShipLines_PVT;
6219: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
6220: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6221: FND_MSG_PUB.Add_Exc_Msg (
6222: p_pkg_name => g_pkg_name,
6223: p_procedure_name => l_api_name
6224: ) ;
6225: END IF;

Line 6226: FND_MSG_PUB.Count_And_Get (

6222: p_pkg_name => g_pkg_name,
6223: p_procedure_name => l_api_name
6224: ) ;
6225: END IF;
6226: FND_MSG_PUB.Count_And_Get (
6227: p_encoded => L_FND_FALSE,
6228: p_count => x_msg_count,
6229: p_data => x_msg_data
6230: ) ;

Line 6466: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6462: p_module_name => g_module_name,
6463: p_procedure_name => l_program_name
6464: );
6465: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
6466: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6467: THEN
6468: FND_MSG_PUB.Add_Exc_Msg(
6469: p_pkg_name => g_pkg_name,
6470: p_procedure_name => l_program_name

Line 6468: FND_MSG_PUB.Add_Exc_Msg(

6464: );
6465: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
6466: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6467: THEN
6468: FND_MSG_PUB.Add_Exc_Msg(
6469: p_pkg_name => g_pkg_name,
6470: p_procedure_name => l_program_name
6471: );
6472: END IF;

Line 6721: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6717: p_module_name => g_module_name,
6718: p_procedure_name => l_program_name
6719: ) ;
6720: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
6721: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6722: FND_MSG_PUB.Add_Exc_Msg (
6723: p_pkg_name => g_pkg_name,
6724: p_procedure_name => l_program_name
6725: ) ;

Line 6722: FND_MSG_PUB.Add_Exc_Msg (

6718: p_procedure_name => l_program_name
6719: ) ;
6720: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
6721: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6722: FND_MSG_PUB.Add_Exc_Msg (
6723: p_pkg_name => g_pkg_name,
6724: p_procedure_name => l_program_name
6725: ) ;
6726: END IF;

Line 7002: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6998: p_module_name => g_module_name,
6999: p_procedure_name => l_program_name
7000: ) ;
7001: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
7002: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7003: FND_MSG_PUB.Add_Exc_Msg (
7004: p_pkg_name => g_pkg_name,
7005: p_procedure_name => l_program_name
7006: ) ;

Line 7003: FND_MSG_PUB.Add_Exc_Msg (

6999: p_procedure_name => l_program_name
7000: ) ;
7001: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
7002: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7003: FND_MSG_PUB.Add_Exc_Msg (
7004: p_pkg_name => g_pkg_name,
7005: p_procedure_name => l_program_name
7006: ) ;
7007: END IF;

Line 7837: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7833: p_module_name => g_module_name,
7834: p_procedure_name => l_program_name
7835: ) ;
7836: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
7837: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7838: FND_MSG_PUB.Add_Exc_Msg (
7839: p_pkg_name => g_pkg_name,
7840: p_procedure_name => l_program_name
7841: ) ;

Line 7838: FND_MSG_PUB.Add_Exc_Msg (

7834: p_procedure_name => l_program_name
7835: ) ;
7836: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
7837: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7838: FND_MSG_PUB.Add_Exc_Msg (
7839: p_pkg_name => g_pkg_name,
7840: p_procedure_name => l_program_name
7841: ) ;
7842: END IF;

Line 7947: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7943: p_module_name => g_module_name,
7944: p_procedure_name => l_program_name
7945: ) ;
7946: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
7947: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7948: FND_MSG_PUB.Add_Exc_Msg (
7949: p_pkg_name => g_pkg_name,
7950: p_procedure_name => l_program_name
7951: ) ;

Line 7948: FND_MSG_PUB.Add_Exc_Msg (

7944: p_procedure_name => l_program_name
7945: ) ;
7946: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
7947: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7948: FND_MSG_PUB.Add_Exc_Msg (
7949: p_pkg_name => g_pkg_name,
7950: p_procedure_name => l_program_name
7951: ) ;
7952: END IF;

Line 8024: FND_MSG_PUB.initialize;

8020: -- Standard Start of API savepoint
8021: SAVEPOINT Adjust_ChargeLines_PVT;
8022: -- Initialize message list if p_init_msg_list is set to TRUE.
8023: IF FND_API.to_Boolean (p_init_msg_list) THEN
8024: FND_MSG_PUB.initialize;
8025: END IF;
8026: -- Check for call compatibility.
8027: IF NOT FND_API.Compatible_API_Call (
8028: p_current_version_number => l_api_version,

Line 8359: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

8355: IF FND_API.To_Boolean (p_commit) THEN
8356: COMMIT WORK;
8357: END IF;
8358: -- Standard call to get message count and if count is 1, get message info.
8359: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8360: -- Standard End of Procedure/Function Logging
8361: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8362: EXCEPTION
8363: WHEN L_FND_EXC_ERROR THEN

Line 8368: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

8364: -- Standard Expected Error Logging
8365: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8366: ROLLBACK TO Adjust_ChargeLines_PVT;
8367: x_return_status := L_FND_RET_STS_ERROR;
8368: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8369: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
8370: -- Standard Unexpected Error Logging
8371: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8372: ROLLBACK TO Adjust_ChargeLines_PVT;

Line 8374: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

8370: -- Standard Unexpected Error Logging
8371: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8372: ROLLBACK TO Adjust_ChargeLines_PVT;
8373: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8374: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8375: WHEN OTHERS THEN
8376: -- Standard Unexpected Error Logging
8377: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8378: ROLLBACK TO Adjust_ChargeLines_PVT;

Line 8380: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8376: -- Standard Unexpected Error Logging
8377: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8378: ROLLBACK TO Adjust_ChargeLines_PVT;
8379: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
8380: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8381: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name, p_procedure_name => l_api_name) ;
8382: END IF;
8383: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8384: END Adjust_ChargeLines;

Line 8381: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name, p_procedure_name => l_api_name) ;

8377: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8378: ROLLBACK TO Adjust_ChargeLines_PVT;
8379: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
8380: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8381: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name, p_procedure_name => l_api_name) ;
8382: END IF;
8383: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8384: END Adjust_ChargeLines;
8385: -- API name : Adjust_ChargeLines

Line 8383: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

8379: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
8380: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8381: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name, p_procedure_name => l_api_name) ;
8382: END IF;
8383: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8384: END Adjust_ChargeLines;
8385: -- API name : Adjust_ChargeLines
8386: -- Type : Private
8387: -- Function : Create Adjustmens Charge Lines and their associations

Line 8472: FND_MSG_PUB.initialize;

8468: -- Standard Start of API savepoint
8469: SAVEPOINT Adjust_ChargeLines_PVT;
8470: -- Initialize message list if p_init_msg_list is set to TRUE.
8471: IF FND_API.to_Boolean (p_init_msg_list) THEN
8472: FND_MSG_PUB.initialize;
8473: END IF;
8474: -- Check for call compatibility.
8475: IF NOT FND_API.Compatible_API_Call (
8476: p_current_version_number => l_api_version,

Line 8956: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

8952: IF FND_API.To_Boolean (p_commit) THEN
8953: COMMIT WORK;
8954: END IF;
8955: -- Standard call to get message count and if count is 1, get message info.
8956: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8957: -- Standard End of Procedure/Function Logging
8958: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8959: EXCEPTION
8960: WHEN L_FND_EXC_ERROR THEN

Line 8967: FND_MSG_PUB.Count_And_Get (

8963: p_module_name => g_module_name,
8964: p_procedure_name => l_api_name) ;
8965: ROLLBACK TO Adjust_ChargeLines_PVT;
8966: x_return_status := L_FND_RET_STS_ERROR;
8967: FND_MSG_PUB.Count_And_Get (
8968: p_encoded => L_FND_FALSE,
8969: p_count => x_msg_count, p_data => x_msg_data) ;
8970: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
8971: -- Standard Unexpected Error Logging

Line 8977: FND_MSG_PUB.Count_And_Get (

8973: p_module_name => g_module_name,
8974: p_procedure_name => l_api_name) ;
8975: ROLLBACK TO Adjust_ChargeLines_PVT;
8976: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8977: FND_MSG_PUB.Count_And_Get (
8978: p_encoded => L_FND_FALSE,
8979: p_count => x_msg_count,
8980: p_data => x_msg_data) ;
8981: WHEN OTHERS THEN

Line 8986: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8982: -- Standard Unexpected Error Logging
8983: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8984: ROLLBACK TO Adjust_ChargeLines_PVT;
8985: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
8986: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8987: FND_MSG_PUB.Add_Exc_Msg (
8988: p_pkg_name => g_pkg_name,
8989: p_procedure_name => l_api_name) ;
8990: END IF;

Line 8987: FND_MSG_PUB.Add_Exc_Msg (

8983: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8984: ROLLBACK TO Adjust_ChargeLines_PVT;
8985: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
8986: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8987: FND_MSG_PUB.Add_Exc_Msg (
8988: p_pkg_name => g_pkg_name,
8989: p_procedure_name => l_api_name) ;
8990: END IF;
8991: FND_MSG_PUB.Count_And_Get (

Line 8991: FND_MSG_PUB.Count_And_Get (

8987: FND_MSG_PUB.Add_Exc_Msg (
8988: p_pkg_name => g_pkg_name,
8989: p_procedure_name => l_api_name) ;
8990: END IF;
8991: FND_MSG_PUB.Count_And_Get (
8992: p_encoded => L_FND_FALSE,
8993: p_count => x_msg_count,
8994: p_data => x_msg_data) ;
8995: END Adjust_ChargeLines;

Line 9060: FND_MSG_PUB.initialize;

9056: -- Standard Start of API savepoint
9057: SAVEPOINT Adjust_TaxLines_PVT;
9058: -- Initialize message list if p_init_msg_list is set to TRUE.
9059: IF FND_API.to_Boolean (p_init_msg_list) THEN
9060: FND_MSG_PUB.initialize;
9061: END IF;
9062: -- Check for call compatibility.
9063: IF NOT FND_API.Compatible_API_Call (
9064: p_current_version_number => l_api_version,

Line 9226: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

9222: IF FND_API.To_Boolean (p_commit) THEN
9223: COMMIT WORK;
9224: END IF;
9225: -- Standard call to get message count and if count is 1, get message info.
9226: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
9227: -- Standard End of Procedure/Function Logging
9228: INL_LOGGING_PVT.Log_EndProc (
9229: p_module_name => g_module_name,
9230: p_procedure_name => l_api_name) ;

Line 9239: FND_MSG_PUB.Count_And_Get (

9235: p_module_name => g_module_name,
9236: p_procedure_name => l_api_name) ;
9237: ROLLBACK TO Adjust_TaxLines_PVT;
9238: x_return_status := L_FND_RET_STS_ERROR;
9239: FND_MSG_PUB.Count_And_Get (
9240: p_encoded => L_FND_FALSE,
9241: p_count => x_msg_count, p_data => x_msg_data) ;
9242: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
9243: -- Standard Unexpected Error Logging

Line 9249: FND_MSG_PUB.Count_And_Get (

9245: p_module_name => g_module_name,
9246: p_procedure_name => l_api_name) ;
9247: ROLLBACK TO Adjust_TaxLines_PVT;
9248: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9249: FND_MSG_PUB.Count_And_Get (
9250: p_encoded => L_FND_FALSE,
9251: p_count => x_msg_count,
9252: p_data => x_msg_data) ;
9253: WHEN OTHERS THEN

Line 9260: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9256: p_module_name => g_module_name,
9257: p_procedure_name => l_api_name) ;
9258: ROLLBACK TO Adjust_TaxLines_PVT;
9259: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
9260: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9261: FND_MSG_PUB.Add_Exc_Msg (
9262: p_pkg_name => g_pkg_name,
9263: p_procedure_name => l_api_name) ;
9264: END IF;

Line 9261: FND_MSG_PUB.Add_Exc_Msg (

9257: p_procedure_name => l_api_name) ;
9258: ROLLBACK TO Adjust_TaxLines_PVT;
9259: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
9260: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9261: FND_MSG_PUB.Add_Exc_Msg (
9262: p_pkg_name => g_pkg_name,
9263: p_procedure_name => l_api_name) ;
9264: END IF;
9265: FND_MSG_PUB.Count_And_Get (

Line 9265: FND_MSG_PUB.Count_And_Get (

9261: FND_MSG_PUB.Add_Exc_Msg (
9262: p_pkg_name => g_pkg_name,
9263: p_procedure_name => l_api_name) ;
9264: END IF;
9265: FND_MSG_PUB.Count_And_Get (
9266: p_encoded => L_FND_FALSE,
9267: p_count => x_msg_count,
9268: p_data => x_msg_data) ;
9269: END Adjust_TaxLines;

Line 9331: FND_MSG_PUB.initialize;

9327: -- Standard Start of API savepoint
9328: SAVEPOINT Adjust_TaxLines_2_PVT;
9329: -- Initialize message list if p_init_msg_list is set to TRUE.
9330: IF FND_API.to_Boolean (p_init_msg_list) THEN
9331: FND_MSG_PUB.initialize;
9332: END IF;
9333: -- Check for call compatibility.
9334: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version, p_caller_version_number => p_api_version, p_api_name => l_api_name, p_pkg_name => g_pkg_name) THEN
9335: RAISE L_FND_EXC_UNEXPECTED_ERROR;

Line 9632: FND_MSG_PUB.Count_And_Get (

9628: IF FND_API.To_Boolean (p_commit) THEN
9629: COMMIT WORK;
9630: END IF;
9631: -- Standard call to get message count and if count is 1, get message info.
9632: FND_MSG_PUB.Count_And_Get (
9633: p_encoded => L_FND_FALSE,
9634: p_count => x_msg_count,
9635: p_data => x_msg_data) ;
9636: -- Standard End of Procedure/Function Logging

Line 9648: FND_MSG_PUB.Count_And_Get (

9644: p_module_name => g_module_name,
9645: p_procedure_name => l_api_name) ;
9646: ROLLBACK TO Adjust_TaxLines_2_PVT;
9647: x_return_status := L_FND_RET_STS_ERROR;
9648: FND_MSG_PUB.Count_And_Get (
9649: p_encoded => L_FND_FALSE,
9650: p_count => x_msg_count,
9651: p_data => x_msg_data) ;
9652: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 9657: FND_MSG_PUB.Count_And_Get (

9653: -- Standard Unexpected Error Logging
9654: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
9655: ROLLBACK TO Adjust_TaxLines_2_PVT;
9656: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9657: FND_MSG_PUB.Count_And_Get (
9658: p_encoded => L_FND_FALSE,
9659: p_count => x_msg_count,
9660: p_data => x_msg_data) ;
9661: WHEN OTHERS THEN

Line 9668: IF FND_MSG_PUB.Check_Msg_Level (

9664: p_module_name => g_module_name,
9665: p_procedure_name => l_api_name) ;
9666: ROLLBACK TO Adjust_TaxLines_2_PVT;
9667: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
9668: IF FND_MSG_PUB.Check_Msg_Level (
9669: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9670: ) THEN
9671: FND_MSG_PUB.Add_Exc_Msg (
9672: p_pkg_name => g_pkg_name,

Line 9669: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

9665: p_procedure_name => l_api_name) ;
9666: ROLLBACK TO Adjust_TaxLines_2_PVT;
9667: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
9668: IF FND_MSG_PUB.Check_Msg_Level (
9669: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9670: ) THEN
9671: FND_MSG_PUB.Add_Exc_Msg (
9672: p_pkg_name => g_pkg_name,
9673: p_procedure_name => l_api_name) ;

Line 9671: FND_MSG_PUB.Add_Exc_Msg (

9667: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
9668: IF FND_MSG_PUB.Check_Msg_Level (
9669: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9670: ) THEN
9671: FND_MSG_PUB.Add_Exc_Msg (
9672: p_pkg_name => g_pkg_name,
9673: p_procedure_name => l_api_name) ;
9674: END IF;
9675: FND_MSG_PUB.Count_And_Get (

Line 9675: FND_MSG_PUB.Count_And_Get (

9671: FND_MSG_PUB.Add_Exc_Msg (
9672: p_pkg_name => g_pkg_name,
9673: p_procedure_name => l_api_name) ;
9674: END IF;
9675: FND_MSG_PUB.Count_And_Get (
9676: p_encoded => L_FND_FALSE,
9677: p_count => x_msg_count,
9678: p_data => x_msg_data) ;
9679: END Adjust_TaxLines;

Line 9814: FND_MSG_PUB.initialize;

9810: -- Standard Start of API savepoint
9811: SAVEPOINT Adjust_Lines_PVT;
9812: -- Initialize message list if p_init_msg_list is set to TRUE.
9813: IF FND_API.to_Boolean (p_init_msg_list) THEN
9814: FND_MSG_PUB.initialize;
9815: END IF;
9816: -- Check for call compatibility.
9817: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version, p_caller_version_number => p_api_version, p_api_name => l_api_name, p_pkg_name => g_pkg_name) THEN
9818: RAISE L_FND_EXC_UNEXPECTED_ERROR;

Line 10289: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

10285: IF FND_API.To_Boolean (p_commit) THEN
10286: COMMIT WORK;
10287: END IF;
10288: -- Standard call to get message count and if count is 1, get message info.
10289: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
10290: -- Standard End of Procedure/Function Logging
10291: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10292: EXCEPTION
10293: WHEN L_FND_EXC_ERROR THEN

Line 10300: FND_MSG_PUB.Count_And_Get (

10296: p_module_name => g_module_name,
10297: p_procedure_name => l_api_name) ;
10298: ROLLBACK TO Adjust_Lines_PVT;
10299: x_return_status := L_FND_RET_STS_ERROR;
10300: FND_MSG_PUB.Count_And_Get (
10301: p_encoded => L_FND_FALSE,
10302: p_count => x_msg_count,
10303: p_data => x_msg_data) ;
10304: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 10309: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

10305: -- Standard Unexpected Error Logging
10306: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10307: ROLLBACK TO Adjust_Lines_PVT;
10308: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10309: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
10310: WHEN OTHERS THEN
10311: -- Standard Unexpected Error Logging
10312: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10313: ROLLBACK TO Adjust_Lines_PVT;

Line 10315: IF FND_MSG_PUB.Check_Msg_Level (

10311: -- Standard Unexpected Error Logging
10312: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10313: ROLLBACK TO Adjust_Lines_PVT;
10314: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
10315: IF FND_MSG_PUB.Check_Msg_Level (
10316: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10317: ) THEN
10318: FND_MSG_PUB.Add_Exc_Msg (
10319: p_pkg_name => g_pkg_name,

Line 10316: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

10312: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10313: ROLLBACK TO Adjust_Lines_PVT;
10314: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
10315: IF FND_MSG_PUB.Check_Msg_Level (
10316: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10317: ) THEN
10318: FND_MSG_PUB.Add_Exc_Msg (
10319: p_pkg_name => g_pkg_name,
10320: p_procedure_name => l_api_name) ;

Line 10318: FND_MSG_PUB.Add_Exc_Msg (

10314: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
10315: IF FND_MSG_PUB.Check_Msg_Level (
10316: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10317: ) THEN
10318: FND_MSG_PUB.Add_Exc_Msg (
10319: p_pkg_name => g_pkg_name,
10320: p_procedure_name => l_api_name) ;
10321: END IF;
10322: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

Line 10322: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

10318: FND_MSG_PUB.Add_Exc_Msg (
10319: p_pkg_name => g_pkg_name,
10320: p_procedure_name => l_api_name) ;
10321: END IF;
10322: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
10323: END Adjust_Lines;
10324:
10325: -- START Bug 13914863
10326: -- API name: Get_1aryQty

Line 10371: FND_MSG_PUB.initialize;

10367: -- Standard Start of API savepoint
10368: SAVEPOINT Get_1aryQty_PVT;
10369: -- Initialize message list if p_init_msg_list is set to TRUE.
10370: IF FND_API.to_Boolean (p_init_msg_list) THEN
10371: FND_MSG_PUB.initialize;
10372: END IF;
10373: -- Check for call compatibility.
10374: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version,
10375: p_caller_version_number => p_api_version,

Line 10470: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

10466: IF FND_API.To_Boolean (p_commit) THEN
10467: COMMIT WORK;
10468: END IF;
10469: -- Standard call to get message count and if count is 1, get message info.
10470: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
10471: p_count => x_msg_count,
10472: p_data => x_msg_data) ;
10473: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
10474: p_procedure_name => l_api_name) ;

Line 10494: IF FND_MSG_PUB.Check_Msg_Level (

10490: p_module_name => g_module_name,
10491: p_procedure_name => l_api_name) ;
10492: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10493: ROLLBACK TO Get_1aryQty_PVT;
10494: IF FND_MSG_PUB.Check_Msg_Level (
10495: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10496: ) THEN
10497: FND_MSG_PUB.Add_Exc_Msg (
10498: p_pkg_name => g_pkg_name,

Line 10495: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

10491: p_procedure_name => l_api_name) ;
10492: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10493: ROLLBACK TO Get_1aryQty_PVT;
10494: IF FND_MSG_PUB.Check_Msg_Level (
10495: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10496: ) THEN
10497: FND_MSG_PUB.Add_Exc_Msg (
10498: p_pkg_name => g_pkg_name,
10499: p_procedure_name => l_api_name) ;

Line 10497: FND_MSG_PUB.Add_Exc_Msg (

10493: ROLLBACK TO Get_1aryQty_PVT;
10494: IF FND_MSG_PUB.Check_Msg_Level (
10495: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10496: ) THEN
10497: FND_MSG_PUB.Add_Exc_Msg (
10498: p_pkg_name => g_pkg_name,
10499: p_procedure_name => l_api_name) ;
10500: END IF;
10501: END Get_1aryQty;

Line 10548: FND_MSG_PUB.initialize;

10544: -- Standard Start of API savepoint
10545: SAVEPOINT Get_2aryQty_PVT;
10546: -- Initialize message list if p_init_msg_list is set to TRUE.
10547: IF FND_API.to_Boolean (p_init_msg_list) THEN
10548: FND_MSG_PUB.initialize;
10549: END IF;
10550: -- Check for call compatibility.
10551: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version,
10552: p_caller_version_number => p_api_version,

Line 10650: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

10646: IF FND_API.To_Boolean (p_commit) THEN
10647: COMMIT WORK;
10648: END IF;
10649: -- Standard call to get message count and if count is 1, get message info.
10650: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
10651: p_count => x_msg_count,
10652: p_data => x_msg_data) ;
10653: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
10654: p_procedure_name => l_api_name) ;

Line 10674: IF FND_MSG_PUB.Check_Msg_Level (

10670: p_module_name => g_module_name,
10671: p_procedure_name => l_api_name) ;
10672: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10673: ROLLBACK TO Get_2aryQty_PVT;
10674: IF FND_MSG_PUB.Check_Msg_Level (
10675: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10676: ) THEN
10677: FND_MSG_PUB.Add_Exc_Msg (
10678: p_pkg_name => g_pkg_name,

Line 10675: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

10671: p_procedure_name => l_api_name) ;
10672: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10673: ROLLBACK TO Get_2aryQty_PVT;
10674: IF FND_MSG_PUB.Check_Msg_Level (
10675: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10676: ) THEN
10677: FND_MSG_PUB.Add_Exc_Msg (
10678: p_pkg_name => g_pkg_name,
10679: p_procedure_name => l_api_name) ;

Line 10677: FND_MSG_PUB.Add_Exc_Msg (

10673: ROLLBACK TO Get_2aryQty_PVT;
10674: IF FND_MSG_PUB.Check_Msg_Level (
10675: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10676: ) THEN
10677: FND_MSG_PUB.Add_Exc_Msg (
10678: p_pkg_name => g_pkg_name,
10679: p_procedure_name => l_api_name) ;
10680: END IF;
10681: END Get_2aryQty;

Line 10745: FND_MSG_PUB.initialize;

10741: -- Standard Start of API savepoint
10742: SAVEPOINT Get_1ary2aryQty_PVT;
10743: -- Initialize message list if p_init_msg_list is set to TRUE.
10744: IF FND_API.to_Boolean (p_init_msg_list) THEN
10745: FND_MSG_PUB.initialize;
10746: END IF;
10747: -- Check for call compatibility.
10748: IF NOT FND_API.Compatible_API_Call (
10749: p_current_version_number => l_api_version,

Line 10971: FND_MSG_PUB.Count_And_Get (

10967: IF FND_API.To_Boolean (p_commit) THEN
10968: COMMIT WORK;
10969: END IF;
10970: -- Standard call to get message count and if count is 1, get message info.
10971: FND_MSG_PUB.Count_And_Get (
10972: p_encoded => L_FND_FALSE,
10973: p_count => x_msg_count,
10974: p_data => x_msg_data) ;
10975: INL_LOGGING_PVT.Log_EndProc (

Line 10997: IF FND_MSG_PUB.Check_Msg_Level (

10993: p_module_name => g_module_name,
10994: p_procedure_name => l_api_name) ;
10995: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10996: ROLLBACK TO Get_1ary2aryQty_PVT;
10997: IF FND_MSG_PUB.Check_Msg_Level (
10998: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10999: ) THEN
11000: FND_MSG_PUB.Add_Exc_Msg (
11001: p_pkg_name => g_pkg_name,

Line 10998: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

10994: p_procedure_name => l_api_name) ;
10995: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10996: ROLLBACK TO Get_1ary2aryQty_PVT;
10997: IF FND_MSG_PUB.Check_Msg_Level (
10998: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10999: ) THEN
11000: FND_MSG_PUB.Add_Exc_Msg (
11001: p_pkg_name => g_pkg_name,
11002: p_procedure_name => l_api_name) ;

Line 11000: FND_MSG_PUB.Add_Exc_Msg (

10996: ROLLBACK TO Get_1ary2aryQty_PVT;
10997: IF FND_MSG_PUB.Check_Msg_Level (
10998: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10999: ) THEN
11000: FND_MSG_PUB.Add_Exc_Msg (
11001: p_pkg_name => g_pkg_name,
11002: p_procedure_name => l_api_name) ;
11003: END IF;
11004: END Get_1ary2aryQty;

Line 11176: FND_MSG_PUB.initialize;

11172: -- Standard Start of API savepoint
11173: SAVEPOINT Adjust_ELCLines_PVT;
11174: -- Initialize message list if p_init_msg_list is set to TRUE.
11175: IF FND_API.to_Boolean (p_init_msg_list) THEN
11176: FND_MSG_PUB.initialize;
11177: END IF;
11178: -- Check for call compatibility.
11179: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
11180: p_caller_version_number => p_api_version,

Line 11871: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

11867: IF FND_API.To_Boolean (p_commit) THEN
11868: COMMIT WORK;
11869: END IF;
11870: -- Standard call to get message count and if count is 1, get message info.
11871: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11872: p_count => x_msg_count,
11873: p_data => x_msg_data) ;
11874: -- Standard End of Procedure/Function Logging
11875: INL_LOGGING_PVT.Log_EndProc (

Line 11884: FND_MSG_PUB.ADD;

11880: --Handling deadlock with proper error message
11881: WHEN RESOURCE_BUSY THEN
11882: x_return_status := FND_API.g_ret_sts_error;
11883: FND_MESSAGE.set_name('INL','INL_CANNOT_EXEC_ELC_SUBMIT_LCK');
11884: FND_MSG_PUB.ADD;
11885: -- Standard Expected Error Logging
11886: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
11887: p_procedure_name => l_program_name);
11888: ROLLBACK TO Adjust_ELCLines_PVT;

Line 11890: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

11886: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
11887: p_procedure_name => l_program_name);
11888: ROLLBACK TO Adjust_ELCLines_PVT;
11889: x_return_status := L_FND_RET_STS_ERROR;
11890: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11891: p_count => x_msg_count,
11892: p_data => x_msg_data);
11893: WHEN L_FND_EXC_ERROR THEN
11894: -- Standard Expected Error Logging

Line 11899: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

11895: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
11896: p_procedure_name => l_program_name) ;
11897: ROLLBACK TO Adjust_ELCLines_PVT;
11898: x_return_status := L_FND_RET_STS_ERROR;
11899: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11900: p_count => x_msg_count,
11901: p_data => x_msg_data) ;
11902: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
11903: -- Standard Unexpected Error Logging

Line 11908: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

11904: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
11905: p_procedure_name => l_program_name) ;
11906: ROLLBACK TO Adjust_ELCLines_PVT;
11907: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
11908: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11909: p_count => x_msg_count,
11910: p_data => x_msg_data) ;
11911: WHEN OTHERS THEN
11912: -- Standard Unexpected Error Logging

Line 11917: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

11913: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
11914: p_procedure_name => l_program_name) ;
11915: ROLLBACK TO Adjust_ELCLines_PVT;
11916: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
11917: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11918: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
11919: p_procedure_name => l_program_name) ;
11920: END IF;
11921: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

Line 11918: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

11914: p_procedure_name => l_program_name) ;
11915: ROLLBACK TO Adjust_ELCLines_PVT;
11916: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
11917: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11918: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
11919: p_procedure_name => l_program_name) ;
11920: END IF;
11921: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11922: p_count => x_msg_count,

Line 11921: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

11917: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11918: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
11919: p_procedure_name => l_program_name) ;
11920: END IF;
11921: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11922: p_count => x_msg_count,
11923: p_data => x_msg_data) ;
11924: END Adjust_ELCLines;
11925: -- /SCM-051

Line 11980: FND_MSG_PUB.initialize;

11976: -- Standard Start of API savepoint
11977: SAVEPOINT Run_Submit_PVT;
11978: -- Initialize message list if p_init_msg_list is set to TRUE.
11979: IF FND_API.to_Boolean (p_init_msg_list) THEN
11980: FND_MSG_PUB.initialize;
11981: END IF;
11982: -- Check for call compatibility.
11983: IF NOT FND_API.Compatible_API_Call (
11984: l_api_version,

Line 12068: FND_MSG_PUB.ADD;

12064: p_var_value => l_rcv_running) ;
12065:
12066: IF NVL(l_rcv_running,0) > 0 THEN
12067: FND_MESSAGE.SET_NAME('INL','INL_CANNOT_EXEC_ELC_SUBMIT');
12068: FND_MSG_PUB.ADD;
12069: RAISE L_FND_EXC_ERROR;
12070: END IF;
12071:
12072: Adjust_ELCLines (

Line 12093: FND_MSG_PUB.ADD;

12089: p_debug_info => l_debug_info) ;
12090:
12091: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHK_ELC_UPDATE');
12092: FND_MESSAGE.SET_TOKEN('SHIP_NUM',l_ship_num);
12093: FND_MSG_PUB.ADD;
12094: RAISE L_FND_EXC_ERROR;
12095: ELSE
12096: -- /SCM-051
12097: -- Run Adjust Lines for Pending Shipments

Line 12176: l_msg_count_validate := NVL (fnd_msg_pub.Count_Msg (), 0) ;

12172: p_module_name => g_module_name,
12173: p_procedure_name => l_api_name,
12174: p_debug_info => l_debug_info
12175: ) ;
12176: l_msg_count_validate := NVL (fnd_msg_pub.Count_Msg (), 0) ;
12177: Validate_Shipment (
12178: p_api_version => 1.0,
12179: p_init_msg_list => L_FND_FALSE,
12180: p_commit => L_FND_FALSE,

Line 12288: FND_MSG_PUB.Count_And_Get (

12284: IF FND_API.To_Boolean (p_commit) THEN
12285: COMMIT WORK;
12286: END IF;
12287: -- Standard call to get message count and if count is 1, get message info.
12288: FND_MSG_PUB.Count_And_Get (
12289: p_encoded => L_FND_FALSE,
12290: p_count => x_msg_count,
12291: p_data => x_msg_data
12292: ) ;

Line 12307: FND_MSG_PUB.Count_And_Get (

12303: p_procedure_name => l_api_name
12304: ) ;
12305: ROLLBACK TO Run_Submit_PVT;
12306: x_return_status := L_FND_RET_STS_ERROR;
12307: FND_MSG_PUB.Count_And_Get (
12308: p_encoded => L_FND_FALSE,
12309: p_count => x_msg_count,
12310: p_data => x_msg_data
12311: ) ;

Line 12320: FND_MSG_PUB.Count_And_Get (

12316: p_procedure_name => l_api_name
12317: ) ;
12318: ROLLBACK TO Run_Submit_PVT;
12319: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
12320: FND_MSG_PUB.Count_And_Get (
12321: p_encoded => L_FND_FALSE,
12322: p_count => x_msg_count,
12323: p_data => x_msg_data
12324: ) ;

Line 12333: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

12329: p_procedure_name => l_api_name
12330: ) ;
12331: ROLLBACK TO Run_Submit_PVT;
12332: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
12333: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12334: FND_MSG_PUB.Add_Exc_Msg (
12335: p_pkg_name => g_pkg_name,
12336: p_procedure_name => l_api_name
12337: ) ;

Line 12334: FND_MSG_PUB.Add_Exc_Msg (

12330: ) ;
12331: ROLLBACK TO Run_Submit_PVT;
12332: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
12333: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12334: FND_MSG_PUB.Add_Exc_Msg (
12335: p_pkg_name => g_pkg_name,
12336: p_procedure_name => l_api_name
12337: ) ;
12338: END IF;

Line 12339: FND_MSG_PUB.Count_And_Get (

12335: p_pkg_name => g_pkg_name,
12336: p_procedure_name => l_api_name
12337: ) ;
12338: END IF;
12339: FND_MSG_PUB.Count_And_Get (
12340: p_encoded => L_FND_FALSE,
12341: p_count => x_msg_count,
12342: p_data => x_msg_data
12343: ) ;

Line 12598: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, L_FND_FALSE) );

12594: ELSIF l_msg_count > 1 THEN
12595: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_count|| ' warnings found.' );
12596: FOR i IN 1 ..l_msg_count
12597: LOOP
12598: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, L_FND_FALSE) );
12599: END LOOP;
12600: retcode := 1;
12601: END IF;
12602: INL_LOGGING_PVT.Log_Statement (

Line 12753: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

12749: p_module_name => g_module_name,
12750: p_procedure_name => l_program_name
12751: ) ;
12752: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
12753: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12754: FND_MSG_PUB.Add_Exc_Msg (
12755: p_pkg_name => g_pkg_name,
12756: p_procedure_name => l_program_name
12757: ) ;

Line 12754: FND_MSG_PUB.Add_Exc_Msg (

12750: p_procedure_name => l_program_name
12751: ) ;
12752: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
12753: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12754: FND_MSG_PUB.Add_Exc_Msg (
12755: p_pkg_name => g_pkg_name,
12756: p_procedure_name => l_program_name
12757: ) ;
12758: END IF;

Line 12817: FND_MSG_PUB.initialize;

12813: -- Standard Start of API savepoint
12814: SAVEPOINT Delete_ChargeAssoc_PVT;
12815: -- Initialize message list if p_init_msg_list is set to TRUE.
12816: IF FND_API.to_Boolean (p_init_msg_list) THEN
12817: FND_MSG_PUB.initialize;
12818: END IF;
12819: -- Check for call compatibility.
12820: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version, p_caller_version_number => p_api_version, p_api_name => l_api_name, p_pkg_name => g_pkg_name) THEN
12821: RAISE L_FND_EXC_UNEXPECTED_ERROR;

Line 12845: FND_MSG_PUB.ADD;

12841: ELSIF (r_affected_ship.ship_status = 'COMPLETED') THEN
12842: Update_PendingMatchingFlag (r_affected_ship.ship_header_id, 'Y', l_return_status) ;
12843: IF l_return_status <> L_FND_RET_STS_SUCCESS THEN
12844: FND_MESSAGE.SET_NAME ('INL', 'INL_UNEXPECTED_ERR') ;
12845: FND_MSG_PUB.ADD;
12846: IF l_return_status = L_FND_RET_STS_ERROR THEN
12847: RAISE L_FND_EXC_ERROR;
12848: ELSE
12849: RAISE L_FND_EXC_UNEXPECTED_ERROR;

Line 12861: FND_MSG_PUB.Count_And_Get (

12857: IF FND_API.To_Boolean (p_commit) THEN
12858: COMMIT WORK;
12859: END IF;
12860: -- Standard call to get message count and if count is 1, get message info.
12861: FND_MSG_PUB.Count_And_Get (
12862: p_encoded => L_FND_FALSE,
12863: p_count => x_msg_count,
12864: p_data => x_msg_data) ;
12865: -- Standard End of Procedure/Function Logging

Line 12877: FND_MSG_PUB.Count_And_Get (

12873: p_module_name => g_module_name,
12874: p_procedure_name => l_api_name) ;
12875: ROLLBACK TO Delete_ChargeAssoc_PVT;
12876: x_return_status := L_FND_RET_STS_ERROR;
12877: FND_MSG_PUB.Count_And_Get (
12878: p_encoded => L_FND_FALSE,
12879: p_count => x_msg_count,
12880: p_data => x_msg_data) ;
12881: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 12888: FND_MSG_PUB.Count_And_Get (

12884: p_module_name => g_module_name,
12885: p_procedure_name => l_api_name) ;
12886: ROLLBACK TO Delete_ChargeAssoc_PVT;
12887: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
12888: FND_MSG_PUB.Count_And_Get (
12889: p_encoded => L_FND_FALSE,
12890: p_count => x_msg_count,
12891: p_data => x_msg_data) ;
12892: WHEN OTHERS THEN

Line 12899: IF FND_MSG_PUB.Check_Msg_Level (

12895: p_module_name => g_module_name,
12896: p_procedure_name => l_api_name) ;
12897: ROLLBACK TO Delete_ChargeAssoc_PVT;
12898: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
12899: IF FND_MSG_PUB.Check_Msg_Level (
12900: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12901: ) THEN
12902: FND_MSG_PUB.Add_Exc_Msg (
12903: p_pkg_name => g_pkg_name,

Line 12900: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

12896: p_procedure_name => l_api_name) ;
12897: ROLLBACK TO Delete_ChargeAssoc_PVT;
12898: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
12899: IF FND_MSG_PUB.Check_Msg_Level (
12900: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12901: ) THEN
12902: FND_MSG_PUB.Add_Exc_Msg (
12903: p_pkg_name => g_pkg_name,
12904: p_procedure_name => l_api_name) ;

Line 12902: FND_MSG_PUB.Add_Exc_Msg (

12898: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
12899: IF FND_MSG_PUB.Check_Msg_Level (
12900: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12901: ) THEN
12902: FND_MSG_PUB.Add_Exc_Msg (
12903: p_pkg_name => g_pkg_name,
12904: p_procedure_name => l_api_name) ;
12905: END IF;
12906: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

Line 12906: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

12902: FND_MSG_PUB.Add_Exc_Msg (
12903: p_pkg_name => g_pkg_name,
12904: p_procedure_name => l_api_name) ;
12905: END IF;
12906: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
12907: END Delete_ChargeAssoc;
12908:
12909: -- Utility name : Get_MatchedTaxNRecAmt
12910: -- Type : Public

Line 13027: IF FND_MSG_PUB.Check_Msg_Level (

13023: -- Standard Unexpected Error Logging
13024: INL_LOGGING_PVT.Log_UnexpecError (
13025: p_module_name => g_module_name,
13026: p_procedure_name => l_program_name) ;
13027: IF FND_MSG_PUB.Check_Msg_Level (
13028: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13029: ) THEN
13030: FND_MSG_PUB.Add_Exc_Msg (
13031: p_pkg_name => g_pkg_name,

Line 13028: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

13024: INL_LOGGING_PVT.Log_UnexpecError (
13025: p_module_name => g_module_name,
13026: p_procedure_name => l_program_name) ;
13027: IF FND_MSG_PUB.Check_Msg_Level (
13028: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13029: ) THEN
13030: FND_MSG_PUB.Add_Exc_Msg (
13031: p_pkg_name => g_pkg_name,
13032: p_procedure_name => l_program_name) ;

Line 13030: FND_MSG_PUB.Add_Exc_Msg (

13026: p_procedure_name => l_program_name) ;
13027: IF FND_MSG_PUB.Check_Msg_Level (
13028: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13029: ) THEN
13030: FND_MSG_PUB.Add_Exc_Msg (
13031: p_pkg_name => g_pkg_name,
13032: p_procedure_name => l_program_name) ;
13033: END IF;
13034: RETURN null;

Line 13145: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

13141: -- Standard Unexpected Error Logging
13142: INL_LOGGING_PVT.Log_UnexpecError (
13143: p_module_name => g_module_name,
13144: p_procedure_name => l_program_name) ;
13145: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13146: FND_MSG_PUB.Add_Exc_Msg (
13147: p_pkg_name => g_pkg_name,
13148: p_procedure_name => l_program_name) ;
13149: END IF;

Line 13146: FND_MSG_PUB.Add_Exc_Msg (

13142: INL_LOGGING_PVT.Log_UnexpecError (
13143: p_module_name => g_module_name,
13144: p_procedure_name => l_program_name) ;
13145: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13146: FND_MSG_PUB.Add_Exc_Msg (
13147: p_pkg_name => g_pkg_name,
13148: p_procedure_name => l_program_name) ;
13149: END IF;
13150: RETURN null;

Line 13256: IF FND_MSG_PUB.Check_Msg_Level (

13252: -- Standard Unexpected Error Logging
13253: INL_LOGGING_PVT.Log_UnexpecError (
13254: p_module_name => g_module_name,
13255: p_procedure_name => l_program_name) ;
13256: IF FND_MSG_PUB.Check_Msg_Level (
13257: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13258: ) THEN
13259: FND_MSG_PUB.Add_Exc_Msg (
13260: p_pkg_name => g_pkg_name,

Line 13257: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

13253: INL_LOGGING_PVT.Log_UnexpecError (
13254: p_module_name => g_module_name,
13255: p_procedure_name => l_program_name) ;
13256: IF FND_MSG_PUB.Check_Msg_Level (
13257: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13258: ) THEN
13259: FND_MSG_PUB.Add_Exc_Msg (
13260: p_pkg_name => g_pkg_name,
13261: p_procedure_name => l_program_name) ;

Line 13259: FND_MSG_PUB.Add_Exc_Msg (

13255: p_procedure_name => l_program_name) ;
13256: IF FND_MSG_PUB.Check_Msg_Level (
13257: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13258: ) THEN
13259: FND_MSG_PUB.Add_Exc_Msg (
13260: p_pkg_name => g_pkg_name,
13261: p_procedure_name => l_program_name) ;
13262: END IF;
13263: RETURN null;

Line 13416: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

13412: WHEN OTHERS THEN
13413: -- Standard Unexpected Error Logging
13414: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
13415: p_procedure_name => l_program_name) ;
13416: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13417: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
13418: p_procedure_name => l_program_name) ;
13419: END IF;
13420: RETURN null;

Line 13417: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,

13413: -- Standard Unexpected Error Logging
13414: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
13415: p_procedure_name => l_program_name) ;
13416: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13417: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
13418: p_procedure_name => l_program_name) ;
13419: END IF;
13420: RETURN null;
13421: END Get_MatchedAmt;

Line 13506: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

13502: WHEN OTHERS THEN
13503: -- Standard Unexpected Error Logging
13504: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
13505: p_procedure_name => l_program_name) ;
13506: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13507: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
13508: p_procedure_name => l_program_name) ;
13509: END IF;
13510: RETURN null;

Line 13507: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,

13503: -- Standard Unexpected Error Logging
13504: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
13505: p_procedure_name => l_program_name) ;
13506: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13507: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
13508: p_procedure_name => l_program_name) ;
13509: END IF;
13510: RETURN null;
13511: END Get_LastUpdateDateForShip;

Line 13566: FND_MSG_PUB.initialize;

13562: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
13563: p_procedure_name => l_api_name);
13564: -- Initialize message list if p_init_msg_list is set to TRUE.
13565: IF FND_API.to_Boolean (p_init_msg_list) THEN
13566: FND_MSG_PUB.initialize;
13567: END IF;
13568: -- Check for call compatibility.
13569: IF NOT
13570: FND_API.Compatible_API_Call (

Line 13605: FND_MSG_PUB.ADD;

13601: p_debug_info => l_debug_info);
13602:
13603: FND_MESSAGE.SET_NAME('INL','INL_ERR_SECONDARY_QTY_NULL');
13604: FND_MESSAGE.SET_TOKEN ('ITEM', l_item) ;
13605: FND_MSG_PUB.ADD;
13606: END IF;
13607: -- Bug #15927464
13608:
13609: -- Quantities must be both positive or both negative

Line 13613: FND_MSG_PUB.ADD;

13609: -- Quantities must be both positive or both negative
13610: IF (l_primary_qty < 0 AND l_secondary_qty > 0) OR
13611: (l_primary_qty > 0 AND l_secondary_qty < 0) THEN
13612: FND_MESSAGE.SET_NAME('INV','INV_QTYOUTOFBALANCE');
13613: FND_MSG_PUB.ADD;
13614: END IF;
13615:
13616: -- If necessary, convert to positive numbers for the deviation check
13617: IF (l_primary_qty < 0) THEN

Line 13649: FND_MSG_PUB.Count_And_Get (

13645: IF FND_API.To_Boolean (p_commit) THEN
13646: COMMIT WORK;
13647: END IF;
13648: -- Standard call to get message count and if count is 1, get message info.
13649: FND_MSG_PUB.Count_And_Get (
13650: p_encoded => L_FND_FALSE,
13651: p_count => x_msg_count,
13652: p_data => x_msg_data) ;
13653: -- Standard End of Procedure/Function Logging

Line 13664: FND_MSG_PUB.Count_And_Get (

13660: INL_LOGGING_PVT.Log_ExpecError (
13661: p_module_name => g_module_name,
13662: p_procedure_name => l_api_name) ;
13663: x_return_status := L_FND_RET_STS_ERROR;
13664: FND_MSG_PUB.Count_And_Get (
13665: p_encoded => L_FND_FALSE,
13666: p_count => x_msg_count,
13667: p_data => x_msg_data) ;
13668: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 13674: FND_MSG_PUB.Count_And_Get (

13670: INL_LOGGING_PVT.Log_UnexpecError (
13671: p_module_name => g_module_name,
13672: p_procedure_name => l_api_name) ;
13673: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
13674: FND_MSG_PUB.Count_And_Get (
13675: p_encoded => L_FND_FALSE,
13676: p_count => x_msg_count,
13677: p_data => x_msg_data) ;
13678: WHEN OTHERS THEN

Line 13684: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

13680: INL_LOGGING_PVT.Log_UnexpecError (
13681: p_module_name => g_module_name,
13682: p_procedure_name => l_api_name) ;
13683: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
13684: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13685: FND_MSG_PUB.Add_Exc_Msg (
13686: p_pkg_name => g_pkg_name,
13687: p_procedure_name => l_api_name) ;
13688: END IF;

Line 13685: FND_MSG_PUB.Add_Exc_Msg (

13681: p_module_name => g_module_name,
13682: p_procedure_name => l_api_name) ;
13683: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
13684: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13685: FND_MSG_PUB.Add_Exc_Msg (
13686: p_pkg_name => g_pkg_name,
13687: p_procedure_name => l_api_name) ;
13688: END IF;
13689: FND_MSG_PUB.Count_And_Get (

Line 13689: FND_MSG_PUB.Count_And_Get (

13685: FND_MSG_PUB.Add_Exc_Msg (
13686: p_pkg_name => g_pkg_name,
13687: p_procedure_name => l_api_name) ;
13688: END IF;
13689: FND_MSG_PUB.Count_And_Get (
13690: p_encoded => L_FND_FALSE,
13691: p_count => x_msg_count,
13692: p_data => x_msg_data) ;
13693: END Validate_DualQuantities;

Line 13810: FND_MSG_PUB.ADD;

13806: p_var_value => l_converted_qty) ;
13807:
13808: IF (l_converted_qty = -99999) THEN
13809: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
13810: FND_MSG_PUB.ADD;
13811: END IF;
13812: ELSIF (p_calling_field = 'S') THEN
13813: l_debug_info := 'Call INV_CONVERT.inv_um_convert for deriving Transaction Qty based on Secondary Qty.';
13814: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 13835: FND_MSG_PUB.ADD;

13831: p_var_value => l_converted_qty) ;
13832:
13833: IF (l_converted_qty = -99999) THEN
13834: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
13835: FND_MSG_PUB.ADD;
13836: END IF;
13837: END IF;
13838: END IF;
13839: RETURN l_converted_qty;

Line 13846: IF FND_MSG_PUB.Check_Msg_Level (

13842: -- Standard Unexpected Error Logging
13843: INL_LOGGING_PVT.Log_UnexpecError (
13844: p_module_name => g_module_name,
13845: p_procedure_name => l_func_name) ;
13846: IF FND_MSG_PUB.Check_Msg_Level (
13847: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13848: ) THEN
13849: FND_MSG_PUB.Add_Exc_Msg (
13850: p_pkg_name => g_pkg_name,

Line 13847: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

13843: INL_LOGGING_PVT.Log_UnexpecError (
13844: p_module_name => g_module_name,
13845: p_procedure_name => l_func_name) ;
13846: IF FND_MSG_PUB.Check_Msg_Level (
13847: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13848: ) THEN
13849: FND_MSG_PUB.Add_Exc_Msg (
13850: p_pkg_name => g_pkg_name,
13851: p_procedure_name => l_func_name) ;

Line 13849: FND_MSG_PUB.Add_Exc_Msg (

13845: p_procedure_name => l_func_name) ;
13846: IF FND_MSG_PUB.Check_Msg_Level (
13847: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13848: ) THEN
13849: FND_MSG_PUB.Add_Exc_Msg (
13850: p_pkg_name => g_pkg_name,
13851: p_procedure_name => l_func_name) ;
13852: END IF;
13853: RETURN 0;

Line 13934: FND_MSG_PUB.initialize;

13930: SAVEPOINT Discard_Updates_PVT;
13931:
13932: -- Initialize message list if p_init_msg_list is set to TRUE.
13933: IF FND_API.to_Boolean (p_init_msg_list) THEN
13934: FND_MSG_PUB.initialize;
13935: END IF;
13936:
13937: -- Check for call compatibility.
13938: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version,

Line 14119: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,

14115: COMMIT WORK;
14116: END IF;
14117:
14118: -- Standard call to get message count and if count is 1, get message info.
14119: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,
14120: p_count => x_msg_count,
14121: p_data => x_msg_data);
14122:
14123: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

Line 14131: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,

14127: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
14128: p_procedure_name => l_program_name);
14129: ROLLBACK TO Discard_Updates_PVT;
14130: x_return_status := L_FND_RET_STS_ERROR;
14131: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,
14132: p_count => x_msg_count,
14133: p_data => x_msg_data);
14134: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
14135: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 14139: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,

14135: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
14136: p_procedure_name => l_program_name);
14137: ROLLBACK TO Discard_Updates_PVT;
14138: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
14139: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,
14140: p_count => x_msg_count,
14141: p_data => x_msg_data);
14142: WHEN OTHERS THEN
14143: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 14147: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

14143: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
14144: p_procedure_name => l_program_name);
14145: ROLLBACK TO Discard_Updates_PVT;
14146: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
14147: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
14148: FND_MSG_PUB.Add_Exc_Msg (p_pkg_name => g_pkg_name,
14149: p_procedure_name => l_program_name);
14150: END IF;
14151: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,

Line 14148: FND_MSG_PUB.Add_Exc_Msg (p_pkg_name => g_pkg_name,

14144: p_procedure_name => l_program_name);
14145: ROLLBACK TO Discard_Updates_PVT;
14146: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
14147: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
14148: FND_MSG_PUB.Add_Exc_Msg (p_pkg_name => g_pkg_name,
14149: p_procedure_name => l_program_name);
14150: END IF;
14151: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,
14152: p_count => x_msg_count,

Line 14151: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,

14147: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
14148: FND_MSG_PUB.Add_Exc_Msg (p_pkg_name => g_pkg_name,
14149: p_procedure_name => l_program_name);
14150: END IF;
14151: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,
14152: p_count => x_msg_count,
14153: p_data => x_msg_data);
14154: END Discard_Updates;
14155: