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 1729: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

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

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

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

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

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

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

1834: l_skip_curr_rec := TRUE;
1835: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_LINE_CAT_MISS');
1836: -- 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.
1837: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1838: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1839: END IF;
1840: END IF;
1841:
1842: --DBMS_OUTPUT.put_line( 'NEW: after line cat null check' );

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

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

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

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

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

1983: -- x_warning_flag := FND_API.G_TRUE;
1984: -- x_return_status := FND_API.G_RET_STS_ERROR;
1985: --FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
1986: --FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',px_charge_lines_tbl(l_curRow).contract_number);
1987: --FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1988: -- l_skip_curr_rec := TRUE;
1989: end if;
1990: */
1991:

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

2118: 'Leaving CSD_CHARGE_LINE_UTIL.convert_to_charge_lines');
2119: end if;
2120:
2121: /*
2122: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2123: p_data => x_msg_data );
2124: */
2125:
2126: EXCEPTION

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

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

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

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

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

2157: -- || SQLCODE );
2158: --DBMS_OUTPUT.put_line( 'SQLERRM= '
2159: -- || SQLERRM );
2160:
2161: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2163: END IF;
2164:
2165: -- save message in debug log

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

2158: --DBMS_OUTPUT.put_line( 'SQLERRM= '
2159: -- || SQLERRM );
2160:
2161: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2163: END IF;
2164:
2165: -- save message in debug log
2166: IF (lc_excep_level >= lc_debug_level) THEN

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

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

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

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