DBA Data[Home] [Help]

APPS.CSD_CHARGE_LINE_UTIL dependencies on FND_MSG_PUB

Line 48: FND_MSG_PUB.Add;

44: EXCEPTION
45: WHEN no_data_found THEN
46: FND_MESSAGE.SET_NAME('CSD','CSD_API_PL_CURR_CODE');
47: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
48: FND_MSG_PUB.Add;
49: -- saupadhy 2826127
50: RETURN NULL ; -- RETURN -1
51:
52: WHEN others THEN

Line 55: FND_MSG_PUB.Add;

51:
52: WHEN others THEN
53: FND_MESSAGE.SET_NAME('CSD','CSD_API_PL_CURR_CODE');
54: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
55: FND_MSG_PUB.Add;
56: -- saupadhy 2826127
57: RETURN NULL ; -- RETURN -1
58:
59: END Get_PLCurrCode;

Line 134: FND_MSG_PUB.initialize;

130: END IF;
131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.
133: IF FND_API.to_Boolean(p_init_msg_list) THEN
134: FND_MSG_PUB.initialize;
135: END IF;
136:
137: -- Initialize API return status to success
138: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 311: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

307:
308: -- API body ends here
309:
310: -- Standard call to get message count and IF count is get message info.
311: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
312: p_data => x_msg_data );
313:
314: EXCEPTION
315:

Line 319: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

315:
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK TO Get_DefaultPriceList;
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
320: p_data => x_msg_data);
321:
322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
323: ROLLBACK TO Get_DefaultPriceList;

Line 325: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

321:
322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
323: ROLLBACK TO Get_DefaultPriceList;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
326: p_data => x_msg_data );
327:
328: WHEN OTHERS THEN
329: ROLLBACK TO Get_DefaultPriceList;

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

327:
328: WHEN OTHERS THEN
329: ROLLBACK TO Get_DefaultPriceList;
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
332: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
333: l_api_name );
334: END IF;
335: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 332: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

328: WHEN OTHERS THEN
329: ROLLBACK TO Get_DefaultPriceList;
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
332: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
333: l_api_name );
334: END IF;
335: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
336: p_data => x_msg_data );

Line 335: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
332: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
333: l_api_name );
334: END IF;
335: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
336: p_data => x_msg_data );
337:
338: END Get_DefaultPriceList;
339:

Line 443: FND_MSG_PUB.Add;

439:
440: WHEN others THEN
441: FND_MESSAGE.SET_NAME('CSD','CSD_API_DEFAULT_CONTRACT');
442: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
443: FND_MSG_PUB.Add;
444: RETURN -1;
445:
446: END Get_DefaultContract;
447:

Line 517: FND_MSG_PUB.initialize;

513: END IF;
514:
515: -- Initialize message list if p_init_msg_list is set to TRUE.
516: IF FND_API.to_Boolean(p_init_msg_list) THEN
517: FND_MSG_PUB.initialize;
518: END IF;
519:
520: -- Initialize API return status to success
521: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 567: FND_MSG_PUB.Add;

563:
564: WHEN others THEN
565: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_PL');
566: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;
569:
570: END;
571:

Line 699: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

695: -- End API Body
696: --
697:
698: -- Standard call to get message count and IF count is get message info.
699: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
700: p_data => x_msg_data );
701:
702: EXCEPTION
703:

Line 707: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

703:
704: WHEN FND_API.G_EXC_ERROR THEN
705: ROLLBACK TO Get_ContractPriceList;
706: x_return_status := FND_API.G_RET_STS_ERROR ;
707: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
708: p_data => x_msg_data);
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO Get_ContractPriceList;

Line 713: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO Get_ContractPriceList;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
713: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
714: p_data => x_msg_data );
715:
716: WHEN OTHERS THEN
717: ROLLBACK TO Get_ContractPriceList;

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

715:
716: WHEN OTHERS THEN
717: ROLLBACK TO Get_ContractPriceList;
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
720: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
721: l_api_name );
722: END IF;
723:

Line 720: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

716: WHEN OTHERS THEN
717: ROLLBACK TO Get_ContractPriceList;
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
720: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
721: l_api_name );
722: END IF;
723:
724: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 724: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

720: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
721: l_api_name );
722: END IF;
723:
724: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
725: p_data => x_msg_data );
726:
727: END Get_ContractPriceList;
728:

Line 789: FND_MSG_PUB.initialize;

785: END IF;
786:
787: -- Initialize message list if p_init_msg_list is set to TRUE.
788: IF FND_API.to_Boolean(p_init_msg_list) THEN
789: FND_MSG_PUB.initialize;
790: END IF;
791:
792: -- Initialize API return status to success
793: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 888: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

884:
885: WHEN FND_API.G_EXC_ERROR THEN
886: ROLLBACK TO Validate_Contract;
887: x_return_status := FND_API.G_RET_STS_ERROR ;
888: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
889: p_data => x_msg_data);
890:
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: ROLLBACK TO Validate_Contract;

Line 894: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

890:
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: ROLLBACK TO Validate_Contract;
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
894: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
895: p_data => x_msg_data );
896:
897: WHEN OTHERS THEN
898: ROLLBACK TO Validate_Contract;

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

896:
897: WHEN OTHERS THEN
898: ROLLBACK TO Validate_Contract;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
900: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
901: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
902: l_api_name );
903: END IF;
904:

Line 901: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

897: WHEN OTHERS THEN
898: ROLLBACK TO Validate_Contract;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
900: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
901: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
902: l_api_name );
903: END IF;
904:
905: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 905: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

901: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
902: l_api_name );
903: END IF;
904:
905: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
906: p_data => x_msg_data );
907:
908: END Validate_Contract;
909:

Line 951: FND_MSG_PUB.Add;

947: WHEN reqd_param_failed THEN
948: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');
949: FND_MESSAGE.SET_TOKEN('MISSING PARAM: PRICE_LIST_ID', p_price_list_id);
950: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_currency_code);
951: FND_MSG_PUB.Add;
952: RETURN NULL;
953:
954: WHEN others THEN
955: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');

Line 957: FND_MSG_PUB.Add;

953:
954: WHEN others THEN
955: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');
956: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
957: FND_MSG_PUB.Add;
958: RETURN NULL;
959:
960: END Validate_PriceList;
961:

Line 1028: FND_MSG_PUB.initialize;

1024: END IF;
1025:
1026: -- Initialize message list if p_init_msg_list is set to TRUE.
1027: IF FND_API.to_Boolean(p_init_msg_list) THEN
1028: FND_MSG_PUB.initialize;
1029: END IF;
1030:
1031: -- Initialize API return status to success
1032: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1088: FND_MSG_PUB.Add;

1084:
1085: WHEN others THEN
1086: FND_MESSAGE.SET_NAME('CSD','CSD_API_DISCOUNTED_PRICE');
1087: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
1088: FND_MSG_PUB.Add;
1089: RAISE FND_API.G_EXC_ERROR;
1090:
1091: END;
1092:

Line 1150: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1146:
1147: -- API body ends here
1148:
1149: -- Standard call to get message count and IF count is get message info.
1150: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1151: p_data => x_msg_data );
1152:
1153: EXCEPTION
1154:

Line 1158: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1154:
1155: WHEN FND_API.G_EXC_ERROR THEN
1156: ROLLBACK TO Get_DiscountedPrice;
1157: x_return_status := FND_API.G_RET_STS_ERROR ;
1158: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1159: p_data => x_msg_data);
1160:
1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1162: ROLLBACK TO Get_DiscountedPrice;

Line 1164: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1160:
1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1162: ROLLBACK TO Get_DiscountedPrice;
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1164: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1165: p_data => x_msg_data );
1166:
1167: WHEN OTHERS THEN
1168: ROLLBACK TO Get_DiscountedPrice;

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

1166:
1167: WHEN OTHERS THEN
1168: ROLLBACK TO Get_DiscountedPrice;
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1171: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1172: l_api_name );
1173: END IF;
1174: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 1171: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1167: WHEN OTHERS THEN
1168: ROLLBACK TO Get_DiscountedPrice;
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1171: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1172: l_api_name );
1173: END IF;
1174: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1175: p_data => x_msg_data );

Line 1174: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1171: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1172: l_api_name );
1173: END IF;
1174: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1175: p_data => x_msg_data );
1176:
1177:
1178: END Get_DiscountedPrice;

Line 1296: FND_MSG_PUB.ADD;

1292:
1293: -- Log an error message.
1294: FND_MESSAGE.SET_NAME('CSD', 'CSD_CHRG_UTIL_NO_COVG');
1295: -- No coverage information found for contract and business process.
1296: FND_MSG_PUB.ADD;
1297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1298: END IF;
1299: ******/
1300: x_coverage_txn_group_id := null;

Line 1305: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1301:
1302: EXCEPTION
1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1306: p_data => x_msg_data );
1307: WHEN OTHERS THEN
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1305: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1306: p_data => x_msg_data );
1307: WHEN OTHERS THEN
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1310: THEN
1311: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1312: l_api_name );
1313: END IF;

Line 1311: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1307: WHEN OTHERS THEN
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1310: THEN
1311: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1312: l_api_name );
1313: END IF;
1314: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1315: p_data => x_msg_data );

Line 1314: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1310: THEN
1311: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1312: l_api_name );
1313: END IF;
1314: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1315: p_data => x_msg_data );
1316: END Get_CoverageInfo;
1317:
1318: /*----------------------------------------------------------------*/

Line 1455: FND_MSG_PUB.initialize;

1451: END IF;
1452:
1453: -- Initialize message list if p_init_msg_list is set to TRUE.
1454: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1455: FND_MSG_PUB.initialize;
1456: END IF;
1457:
1458: -- logging
1459: if (lc_proc_level >= lc_debug_level) then

Line 1538: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );

1534: || ' p_incident_id = ' || p_incident_id);
1535: end if;
1536: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NO_OPER_UNIT');
1537: -- Could not determine the operating unit. Operating unit is required to derive line types.
1538: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: END IF;
1541:
1542: -- Get the coverage details for the business process and

Line 1583: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );

1579: 'Coverage information could not be determined for the contract and business process.');
1580: end if;
1581: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_UTIL_NO_COVG');
1582: -- Coverage information could not be determined for the contract and business process.
1583: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END IF;
1586: END IF;
1587:

Line 1624: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

1620: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NEG_QTY');
1621: -- The net transactable quantity for the item $ITEM was found to be negative.
1622: -- The lines for the item will be ignored.
1623: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1624: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1625: END IF;
1626:
1627: -- We derive/validate lots of values that depend just on the item.
1628: -- Hence, for each subsequent record we need not do the entire processing

Line 1734: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

1730: p_MLE_lines_tbl( i ).item_name );
1731: FND_MESSAGE.SET_TOKEN( 'PRICE_LIST', l_price_list_name );
1732: FND_MESSAGE.SET_TOKEN( 'UOM', p_MLE_lines_tbl( i ).uom );
1733: --DBMS_OUTPUT.put_line( 'NEW: before the message was added' );
1734: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1735: --DBMS_OUTPUT.put_line( 'NEW: after the message was added' );
1736: END;
1737:
1738: --DBMS_OUTPUT.put_line( 'NEW: after getting the selling price' );

Line 1760: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

1756: l_skip_curr_rec := TRUE;
1757: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NO_ITEM_SAR' );
1758: -- Unable to determine service activity billing type for the item $ITEM.
1759: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1760: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1761: ELSE
1762: --DBMS_OUTPUT.put_line( 'NEW: txn bill type is NOT NULL' );
1763:
1764: if (lc_stat_level >= lc_debug_level) then

Line 1831: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

1827: l_skip_curr_rec := TRUE;
1828: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_LINE_TYPE_MISS');
1829: -- Line type, for the current organization, has not been set for the item $ITEM. Check the service activity billing types set up.
1830: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1831: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1832: END IF;
1833:
1834: --DBMS_OUTPUT.put_line( 'NEW: after line type id null check' );
1835:

Line 1843: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

1839: l_skip_curr_rec := TRUE;
1840: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_LINE_CAT_MISS');
1841: -- Line category code, for the current organization, is either incorrect or not set for the item $ITEM. Check the service activity billing types set up.
1842: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1843: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1844: END IF;
1845: END IF;
1846:
1847: --DBMS_OUTPUT.put_line( 'NEW: after line cat null check' );

Line 1897: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

1893: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_IB_REQ' );
1894: -- Instance number for the item $ITEM is required, based on it's service activity billing type set up.
1895: FND_MESSAGE.SET_TOKEN( 'ITEM',
1896: p_MLE_lines_tbl( i ).item_name );
1897: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1898: END IF;
1899: END IF;
1900:
1901: --DBMS_OUTPUT.put_line( 'NEW: outside IB check' );

Line 1963: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );

1959: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_DISCOUNT_PRICE');
1960: -- There was an error while trying to get discount price for the item $ITEM using the contract $CONTRACT_NUMBER.
1961: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name);
1962: FND_MESSAGE.SET_TOKEN( 'CONTRACT_NUMBER', l_contract_number );
1963: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
1964: END IF;
1965: END IF;
1966:
1967: -- We do not do Actuals costing.

Line 1992: --FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

1988: -- x_warning_flag := FND_API.G_TRUE;
1989: -- x_return_status := FND_API.G_RET_STS_ERROR;
1990: --FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
1991: --FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',px_charge_lines_tbl(l_curRow).contract_number);
1992: --FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1993: -- l_skip_curr_rec := TRUE;
1994: end if;
1995: */
1996:

Line 2127: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2123: 'Leaving CSD_CHARGE_LINE_UTIL.convert_to_charge_lines');
2124: end if;
2125:
2126: /*
2127: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2128: p_data => x_msg_data );
2129: */
2130:
2131: EXCEPTION

Line 2136: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

2132: WHEN FND_API.G_EXC_ERROR THEN
2133: ROLLBACK TO Convert_To_Actual_Lines;
2134: --DBMS_OUTPUT.put_line( 'NEW: Inside EXC ERROR' );
2135: x_return_status := FND_API.G_RET_STS_ERROR;
2136: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2137: p_data => x_msg_data );
2138:
2139: -- save message in debug log
2140: IF (lc_excep_level >= lc_debug_level) THEN

Line 2149: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

2145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2146: ROLLBACK TO Convert_To_Actual_Lines;
2147: --DBMS_OUTPUT.put_line( 'NEW: Inside UNEXP ERROR' );
2148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2149: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2150: p_data => x_msg_data );
2151:
2152: -- save message in debug log
2153: IF (lc_excep_level >= lc_debug_level) THEN

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

2162: -- || SQLCODE );
2163: --DBMS_OUTPUT.put_line( 'SQLERRM= '
2164: -- || SQLERRM );
2165:
2166: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2167: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2168: END IF;
2169:
2170: -- save message in debug log

Line 2167: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );

2163: --DBMS_OUTPUT.put_line( 'SQLERRM= '
2164: -- || SQLERRM );
2165:
2166: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2167: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2168: END IF;
2169:
2170: -- save message in debug log
2171: IF (lc_excep_level >= lc_debug_level) THEN

Line 2180: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );

2176: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_MLE_CHRG_FORMAT_ERR');
2177: -- Encountered an error while converting MLE lines into charge line format. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2178: FND_MESSAGE.set_token('SQLCODE' , SQLCODE);
2179: FND_MESSAGE.set_token('SQLERRM' , SQLERRM);
2180: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
2181: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2182: p_data => x_msg_data );
2183: END Convert_To_Charge_Lines;
2184:

Line 2181: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

2177: -- Encountered an error while converting MLE lines into charge line format. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2178: FND_MESSAGE.set_token('SQLCODE' , SQLCODE);
2179: FND_MESSAGE.set_token('SQLERRM' , SQLERRM);
2180: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
2181: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2182: p_data => x_msg_data );
2183: END Convert_To_Charge_Lines;
2184:
2185: