APPS.INV_TRANSACTION_FLOW_PUB dependencies on FND_MSG_PUB

Line 181: fnd_msg_pub.initialize;

177:
178:
179: -- Initialize message list.
180: IF fnd_api.to_boolean(p_init_msg_list) THEN
181: fnd_msg_pub.initialize;
182: END IF;
183:
184:
185: IF l_debug = 1 then

Line 373: FND_MSG_PUB.ADD;

369:
370: EXCEPTION
371: when no_data_found then
372: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_START_ORG');
373: FND_MSG_PUB.ADD;
374: raise fnd_api.g_exc_error;
375: end;
376:
377: BEGIN

Line 385: FND_MSG_PUB.ADD;

381: WHERE organization_id = p_end_operating_unit;
382: EXCEPTION
383: when no_data_found then
384: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_END_ORG');
385: FND_MSG_PUB.ADD;
386: raise fnd_api.g_exc_error;
387: end;
388:
389: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');

Line 392: fnd_msg_pub.add;

388:
389: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');
390: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
391: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
392: fnd_msg_pub.add;
393: IF l_debug = 1 THEN
394: print_debug(' No matching transaction flows found ', l_api_name);
395: END IF;
396: x_transaction_flows_tbl.DELETE;

Line 403: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

399: EXCEPTION
400: WHEN FND_API.G_EXC_ERROR THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: x_transaction_flows_tbl.delete;
403: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
404:
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
407: x_transaction_flows_tbl.delete;

Line 408: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

404:
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
407: x_transaction_flows_tbl.delete;
408: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
409:
410: WHEN OTHERS THEN
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
412: x_transaction_flows_tbl.delete;

Line 413: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

409:
410: WHEN OTHERS THEN
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
412: x_transaction_flows_tbl.delete;
413: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
414:
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
416: FND_MSG_PUB.Add_Exc_Msg
417: ( G_PACKAGE_NAME, 'GET_TRANSACTION_FLOW');

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

411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
412: x_transaction_flows_tbl.delete;
413: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
414:
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
416: FND_MSG_PUB.Add_Exc_Msg
417: ( G_PACKAGE_NAME, 'GET_TRANSACTION_FLOW');
418: end if;
419: END GET_TRANSACTION_FLOW;

Line 416: FND_MSG_PUB.Add_Exc_Msg

412: x_transaction_flows_tbl.delete;
413: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
414:
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
416: FND_MSG_PUB.Add_Exc_Msg
417: ( G_PACKAGE_NAME, 'GET_TRANSACTION_FLOW');
418: end if;
419: END GET_TRANSACTION_FLOW;
420:

Line 527: fnd_msg_pub.initialize;

523:
524:
525: -- Initialize message list.
526: IF fnd_api.to_boolean(p_init_msg_list) THEN
527: fnd_msg_pub.initialize;
528: END IF;
529:
530:
531: IF l_debug = 1 then

Line 609: fnd_msg_pub.add;

605:
606: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW_ID');
607: FND_MESSAGE.SET_TOKEN('ID', p_headeR_id);
608:
609: fnd_msg_pub.add;
610: IF l_debug = 1 THEN
611: print_debug(' No transaction flows found ', l_api_name);
612: END IF;
613: RAISE FND_API.g_exc_error;

Line 620: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

616: EXCEPTION
617: WHEN FND_API.G_EXC_ERROR THEN
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: x_transaction_flows_tbl.delete;
620: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
621:
622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
624: x_transaction_flows_tbl.delete;

Line 625: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

621:
622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
624: x_transaction_flows_tbl.delete;
625: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
626:
627: WHEN OTHERS THEN
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
629: x_transaction_flows_tbl.delete;

Line 630: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

626:
627: WHEN OTHERS THEN
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
629: x_transaction_flows_tbl.delete;
630: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
631:
632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
633: FND_MSG_PUB.Add_Exc_Msg
634: ( G_PACKAGE_NAME, 'GET_TRANSACTION_FLOW');

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

628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
629: x_transaction_flows_tbl.delete;
630: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
631:
632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
633: FND_MSG_PUB.Add_Exc_Msg
634: ( G_PACKAGE_NAME, 'GET_TRANSACTION_FLOW');
635: end if;
636: END GET_TRANSACTION_FLOW;

Line 633: FND_MSG_PUB.Add_Exc_Msg

629: x_transaction_flows_tbl.delete;
630: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
631:
632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
633: FND_MSG_PUB.Add_Exc_Msg
634: ( G_PACKAGE_NAME, 'GET_TRANSACTION_FLOW');
635: end if;
636: END GET_TRANSACTION_FLOW;
637:

Line 734: fnd_msg_pub.initialize;

730:
731:
732: -- Initialize message list.
733: IF fnd_api.to_boolean(p_init_msg_list) THEN
734: fnd_msg_pub.initialize;
735: END IF;
736:
737:
738: IF l_debug = 1 then

Line 851: FND_MSG_PUB.ADD;

847:
848: EXCEPTION
849: when no_data_found then
850: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_START_ORG');
851: FND_MSG_PUB.ADD;
852: raise fnd_api.g_exc_error;
853: end;
854:
855: BEGIN

Line 863: FND_MSG_PUB.ADD;

859: WHERE organization_id = p_end_operating_unit;
860: EXCEPTION
861: when no_data_found then
862: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_END_ORG');
863: FND_MSG_PUB.ADD;
864: raise fnd_api.g_exc_error;
865: end;
866:
867: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');

Line 870: fnd_msg_pub.add;

866:
867: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');
868: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
869: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
870: fnd_msg_pub.add;
871:
872: IF l_debug = 1 THEN
873: print_debug(' No matching transaction flows found ', l_api_name);
874: END IF;

Line 884: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

880: EXCEPTION
881: WHEN FND_API.G_EXC_ERROR THEN
882: x_return_status := FND_API.G_RET_STS_ERROR;
883: x_transaction_flow_exists := G_TRANSACTION_FLOW_NOT_FOUND;
884: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
885:
886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
887: x_return_status := FND_API.G_RET_STS_ERROR;
888: x_transaction_flow_exists := G_TRANSACTION_FLOW_NOT_FOUND;

Line 889: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

885:
886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
887: x_return_status := FND_API.G_RET_STS_ERROR;
888: x_transaction_flow_exists := G_TRANSACTION_FLOW_NOT_FOUND;
889: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
890:
891: WHEN OTHERS THEN
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893: x_transaction_flow_exists := G_TRANSACTION_FLOW_NOT_FOUND;

Line 894: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

890:
891: WHEN OTHERS THEN
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893: x_transaction_flow_exists := G_TRANSACTION_FLOW_NOT_FOUND;
894: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
895:
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
897: FND_MSG_PUB.Add_Exc_Msg
898: ( G_PACKAGE_NAME, 'CHECK_TRANSACTION_FLOW');

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

892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893: x_transaction_flow_exists := G_TRANSACTION_FLOW_NOT_FOUND;
894: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
895:
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
897: FND_MSG_PUB.Add_Exc_Msg
898: ( G_PACKAGE_NAME, 'CHECK_TRANSACTION_FLOW');
899: end if;
900: END CHECK_TRANSACTION_FLOW;

Line 897: FND_MSG_PUB.Add_Exc_Msg

893: x_transaction_flow_exists := G_TRANSACTION_FLOW_NOT_FOUND;
894: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
895:
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
897: FND_MSG_PUB.Add_Exc_Msg
898: ( G_PACKAGE_NAME, 'CHECK_TRANSACTION_FLOW');
899: end if;
900: END CHECK_TRANSACTION_FLOW;
901:

Line 1053: fnd_msg_pub.initialize;

1049:
1050:
1051: -- Initialize message list.
1052: IF fnd_api.to_boolean(p_init_msg_list) THEN
1053: fnd_msg_pub.initialize;
1054: END IF;
1055:
1056: SELECT mtl_transaction_flow_headers_s.NEXTVAL
1057: INTO l_header_id FROM dual;

Line 1279: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1275: ROLLBACK TO create_transaction_flow;
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: x_header_id := NULL;
1278: x_line_number_tbl.DELETE;
1279: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: ROLLBACK TO create_transaction_flow;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1286: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1282: ROLLBACK TO create_transaction_flow;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1284: x_header_id := NULL;
1285: x_line_number_tbl.DELETE;
1286: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1287: WHEN OTHERS THEN
1288: ROLLBACK TO create_transaction_flow;
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1290: x_header_id := NULL;

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

1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1290: x_header_id := NULL;
1291: x_line_number_tbl.DELETE;
1292:
1293: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1294: FND_MSG_PUB.Add_Exc_Msg
1295: ( G_PACKAGE_NAME, 'CREATE_TRANSACTION_FLOW');
1296: end if;
1297:

Line 1294: FND_MSG_PUB.Add_Exc_Msg

1290: x_header_id := NULL;
1291: x_line_number_tbl.DELETE;
1292:
1293: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1294: FND_MSG_PUB.Add_Exc_Msg
1295: ( G_PACKAGE_NAME, 'CREATE_TRANSACTION_FLOW');
1296: end if;
1297:
1298: END CREATE_TRANSACTION_FLOW;

Line 1414: fnd_msg_pub.initialize;

1410:
1411:
1412: -- Initialize message list.
1413: IF fnd_api.to_boolean(p_init_msg_list) THEN
1414: fnd_msg_pub.initialize;
1415: END IF;
1416:
1417: IF (g_debug=1) THEN
1418: print_debug('Before inv_transaction_flow_pub.update_transaction_flow_header call...');

Line 1568: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1564: EXCEPTION
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO UPDATE_TRANSACTION_FLOW;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1569:
1570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1571: ROLLBACK TO UPDATE_TRANSACTION_FLOW;
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1573: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1569:
1570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1571: ROLLBACK TO UPDATE_TRANSACTION_FLOW;
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1573: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1574: WHEN OTHERS THEN
1575: ROLLBACK TO UPDATE_TRANSACTION_FLOW;
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1573: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1574: WHEN OTHERS THEN
1575: ROLLBACK TO UPDATE_TRANSACTION_FLOW;
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1578: FND_MSG_PUB.Add_Exc_Msg
1579: ( G_PACKAGE_NAME, 'CREATE_TRANSACTION_FLOW');
1580: end if;
1581:

Line 1578: FND_MSG_PUB.Add_Exc_Msg

1574: WHEN OTHERS THEN
1575: ROLLBACK TO UPDATE_TRANSACTION_FLOW;
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1578: FND_MSG_PUB.Add_Exc_Msg
1579: ( G_PACKAGE_NAME, 'CREATE_TRANSACTION_FLOW');
1580: end if;
1581:
1582: END UPDATE_TRANSACTION_FLOW;

Line 1641: fnd_msg_pub.initialize;

1637: END IF;
1638:
1639: -- Initialize message list.
1640: IF fnd_api.to_boolean(p_init_msg_list) THEN
1641: fnd_msg_pub.initialize;
1642: END IF;
1643:
1644:
1645: SAVEPOINT UPDATE_TRANSACTION_FLOW_HEADER;

Line 1706: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1702: EXCEPTION
1703: WHEN FND_API.G_EXC_ERROR THEN
1704: ROLLBACK TO UPDATE_TRANSACTION_FLOW_HEADER;
1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1707:
1708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1709: ROLLBACK TO UPDATE_TRANSACTION_FLOW_HEADER;
1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1711: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1707:
1708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1709: ROLLBACK TO UPDATE_TRANSACTION_FLOW_HEADER;
1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1711: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1712: WHEN OTHERS THEN
1713: ROLLBACK TO UPDATE_TRANSACTION_FLOW_HEADER;
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1715:

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

1712: WHEN OTHERS THEN
1713: ROLLBACK TO UPDATE_TRANSACTION_FLOW_HEADER;
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1715:
1716: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1717: FND_MSG_PUB.Add_Exc_Msg
1718: ( G_PACKAGE_NAME, 'UPDATE_TRANSACTION_FLOW_HEADER');
1719: end if;
1720: END Update_Transaction_Flow_Header;

Line 1717: FND_MSG_PUB.Add_Exc_Msg

1713: ROLLBACK TO UPDATE_TRANSACTION_FLOW_HEADER;
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1715:
1716: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1717: FND_MSG_PUB.Add_Exc_Msg
1718: ( G_PACKAGE_NAME, 'UPDATE_TRANSACTION_FLOW_HEADER');
1719: end if;
1720: END Update_Transaction_Flow_Header;
1721:

Line 1776: fnd_msg_pub.initialize;

1772:
1773:
1774: -- Initialize message list.
1775: IF fnd_api.to_boolean(p_init_msg_list) THEN
1776: fnd_msg_pub.initialize;
1777: END IF;
1778:
1779:
1780: SAVEPOINT UPDATE_TRANSACTION_FLOW_LINE;

Line 1839: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1835: EXCEPTION
1836: WHEN FND_API.G_EXC_ERROR THEN
1837: ROLLBACK TO update_transaction_flow_line;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1840:
1841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1842: ROLLBACK TO update_transaction_flow_line;
1843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1844: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1840:
1841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1842: ROLLBACK TO update_transaction_flow_line;
1843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1844: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1845: WHEN OTHERS THEN
1846: ROLLBACK TO update_transaction_flow_line;
1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1848:

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

1845: WHEN OTHERS THEN
1846: ROLLBACK TO update_transaction_flow_line;
1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1848:
1849: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1850: FND_MSG_PUB.Add_Exc_Msg
1851: ( G_PACKAGE_NAME, 'UPDATE_TRANSACTION_FLOW');
1852: end if;
1853: END Update_Transaction_Flow_line;

Line 1850: FND_MSG_PUB.Add_Exc_Msg

1846: ROLLBACK TO update_transaction_flow_line;
1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1848:
1849: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1850: FND_MSG_PUB.Add_Exc_Msg
1851: ( G_PACKAGE_NAME, 'UPDATE_TRANSACTION_FLOW');
1852: end if;
1853: END Update_Transaction_Flow_line;
1854:

Line 1986: fnd_msg_pub.initialize;

1982:
1983:
1984: -- Initialize message list.
1985: IF fnd_api.to_boolean(p_init_msg_list) THEN
1986: fnd_msg_pub.initialize;
1987: END IF;
1988:
1989: SAVEPOINT update_ic_relation;
1990:

Line 2134: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2130: EXCEPTION
2131: WHEN FND_API.G_EXC_ERROR THEN
2132: ROLLBACK TO update_ic_relation;
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2135:
2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2137: ROLLBACK TO update_ic_relation;
2138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2139: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2135:
2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2137: ROLLBACK TO update_ic_relation;
2138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2139: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2140: WHEN OTHERS THEN
2141: ROLLBACK TO update_ic_relation;
2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2143:

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

2140: WHEN OTHERS THEN
2141: ROLLBACK TO update_ic_relation;
2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2143:
2144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2145: FND_MSG_PUB.Add_Exc_Msg
2146: ( G_PACKAGE_NAME, 'UPDATE_TRANSACTION_FLOW');
2147: end if;
2148: END Update_IC_RELATION;

Line 2145: FND_MSG_PUB.Add_Exc_Msg

2141: ROLLBACK TO update_ic_relation;
2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2143:
2144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2145: FND_MSG_PUB.Add_Exc_Msg
2146: ( G_PACKAGE_NAME, 'UPDATE_TRANSACTION_FLOW');
2147: end if;
2148: END Update_IC_RELATION;
2149:

Line 2228: fnd_msg_pub.initialize;

2224:
2225:
2226: -- Initialize message list.
2227: IF fnd_api.to_boolean(p_init_msg_list) THEN
2228: fnd_msg_pub.initialize;
2229: END IF;
2230:
2231: /* NOT NULL CHECK - ALL THE NOT NULL ERROR MESSAGES WOULD BE GROUPED AND
2232: RAISE AT ONCE */

Line 2240: FND_MSG_PUB.ADD;

2236:
2237: IF p_ship_organization_id IS NULL THEN
2238: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');
2239: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_ORGANIZATION_ID');
2240: FND_MSG_PUB.ADD;
2241: hasNotNullError := true;
2242: END IF;
2243:
2244: IF p_sell_organization_id IS NULL THEN

Line 2247: FND_MSG_PUB.ADD;

2243:
2244: IF p_sell_organization_id IS NULL THEN
2245: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');
2246: FND_MESSAGE.SET_TOKEN('COLUMN','SELL_ORGANIZATION_ID');
2247: FND_MSG_PUB.ADD;
2248: hasNotNullError := true;
2249: END IF;
2250:
2251: IF p_flow_type IS NULL THEN

Line 2254: FND_MSG_PUB.ADD;

2250:
2251: IF p_flow_type IS NULL THEN
2252: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');
2253: FND_MESSAGE.SET_TOKEN('COLUMN','FLOW_TYPE');
2254: FND_MSG_PUB.ADD;
2255: hasNotNullError := true;
2256: END IF;
2257:
2258: IF p_customer_id IS NULL THEN

Line 2262: FND_MSG_PUB.ADD;

2258: IF p_customer_id IS NULL THEN
2259:
2260: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2261: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_ID');
2262: FND_MSG_PUB.ADD;
2263: hasNotNullError := true;
2264: END IF;
2265:
2266: IF p_address_id IS NULL THEN

Line 2270: FND_MSG_PUB.ADD;

2266: IF p_address_id IS NULL THEN
2267:
2268: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2269: FND_MESSAGE.SET_TOKEN('COLUMN','ADDRESS_ID');
2270: FND_MSG_PUB.ADD;
2271: hasNotNullError := true;
2272:
2273: END IF;
2274:

Line 2279: FND_MSG_PUB.ADD;

2275: IF p_customer_site_id IS NULL THEN
2276:
2277: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2278: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_SITE_ID');
2279: FND_MSG_PUB.ADD;
2280: hasNotNullError := true;
2281:
2282: END IF;
2283:

Line 2288: FND_MSG_PUB.ADD;

2284: IF p_cust_trx_type_id IS NULL THEN
2285:
2286: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2287: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_TRX_TYPE_ID');
2288: FND_MSG_PUB.ADD;
2289: hasNotNullError := true;
2290:
2291: END IF;
2292:

Line 2297: FND_MSG_PUB.ADD;

2293: IF p_vendor_id IS NULL THEN
2294:
2295: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2296: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_ID');
2297: FND_MSG_PUB.ADD;
2298: hasNotNullError := true;
2299:
2300: END IF;
2301:

Line 2306: FND_MSG_PUB.ADD;

2302: IF p_vendor_site_id IS NULL THEN
2303:
2304: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2305: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_SITE_ID');
2306: FND_MSG_PUB.ADD;
2307: hasNotNullError := true;
2308:
2309: END IF;
2310: /* Bug# 3314606

Line 2314: FND_MSG_PUB.ADD;

2310: /* Bug# 3314606
2311: IF p_freight_code_combination_id IS NULL THEN
2312: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2313: FND_MESSAGE.SET_TOKEN('COLUMN','FREIGHT_CODE_COMBINATION_ID');
2314: FND_MSG_PUB.ADD;
2315: hasNotNullError := true;
2316: END IF;
2317: */
2318: DECLARE

Line 2331: FND_MSG_PUB.ADD;

2327:
2328: IF p_intercompany_cogs_account_id IS NULL THEN
2329: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2330: FND_MESSAGE.SET_TOKEN('COLUMN','INTERCOMPANY_COGS_ACCOUNT_ID');
2331: FND_MSG_PUB.ADD;
2332: hasNotNullError := true;
2333: END IF;
2334:
2335: IF p_inventory_accrual_account_id IS NULL THEN

Line 2338: FND_MSG_PUB.ADD;

2334:
2335: IF p_inventory_accrual_account_id IS NULL THEN
2336: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2337: FND_MESSAGE.SET_TOKEN('COLUMN','INVENTORY_ACCRUAL_ACCOUNT_ID');
2338: FND_MSG_PUB.ADD;
2339: hasNotNullError := true;
2340: END IF;
2341:
2342: IF p_expense_accrual_account_id IS NULL THEN

Line 2345: FND_MSG_PUB.ADD;

2341:
2342: IF p_expense_accrual_account_id IS NULL THEN
2343: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2344: FND_MESSAGE.SET_TOKEN('COLUMN','EXPENSE_ACCRUAL_ACCOUNT_ID');
2345: FND_MSG_PUB.ADD;
2346: hasNotNullError := true;
2347: END IF;
2348: EXCEPTION
2349: WHEN NO_DATA_FOUND THEN

Line 2803: FND_MSG_PUB.ADD;

2799: EXCEPTION
2800: WHEN FND_API.G_EXC_ERROR THEN
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: x_valid := g_false;
2803: FND_MSG_PUB.ADD;
2804: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2805:
2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2804: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2800: WHEN FND_API.G_EXC_ERROR THEN
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: x_valid := g_false;
2803: FND_MSG_PUB.ADD;
2804: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2805:
2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2808: x_valid := g_false;

Line 2809: FND_MSG_PUB.ADD;

2805:
2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2808: x_valid := g_false;
2809: FND_MSG_PUB.ADD;
2810: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2811: WHEN OTHERS THEN
2812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2813: x_valid := g_false;

Line 2810: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2808: x_valid := g_false;
2809: FND_MSG_PUB.ADD;
2810: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2811: WHEN OTHERS THEN
2812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2813: x_valid := g_false;
2814: FND_MSG_PUB.ADD;

Line 2814: FND_MSG_PUB.ADD;

2810: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2811: WHEN OTHERS THEN
2812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2813: x_valid := g_false;
2814: FND_MSG_PUB.ADD;
2815: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2816: FND_MSG_PUB.Add_Exc_Msg
2817: ( G_PACKAGE_NAME, 'validate_IC_RELATION_rec');
2818: end if;

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

2811: WHEN OTHERS THEN
2812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2813: x_valid := g_false;
2814: FND_MSG_PUB.ADD;
2815: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2816: FND_MSG_PUB.Add_Exc_Msg
2817: ( G_PACKAGE_NAME, 'validate_IC_RELATION_rec');
2818: end if;
2819: END validate_IC_RELATION_rec;

Line 2816: FND_MSG_PUB.Add_Exc_Msg

2812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2813: x_valid := g_false;
2814: FND_MSG_PUB.ADD;
2815: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2816: FND_MSG_PUB.Add_Exc_Msg
2817: ( G_PACKAGE_NAME, 'validate_IC_RELATION_rec');
2818: end if;
2819: END validate_IC_RELATION_rec;
2820:

Line 2923: fnd_msg_pub.initialize;

2919:
2920:
2921: -- Initialize message list.
2922: IF fnd_api.to_boolean(p_init_msg_list) THEN
2923: fnd_msg_pub.initialize;
2924: END IF;
2925:
2926:
2927: x_return_status := 'S';

Line 2941: fnd_msg_pub.add;

2937: IF l_debug = 1 then
2938: print_debug('incorrect p_rcv_transaction_id', l_api_name);
2939: END IF;
2940: fnd_message.set_name('INV', 'INV_NO_RCVTXNID');
2941: fnd_msg_pub.add;
2942: RAISE fnd_api.g_exc_error;
2943: END IF;
2944:
2945: BEGIN

Line 2963: fnd_msg_pub.add;

2959: IF l_debug = 1 then
2960: print_debug('no record found in rcv_transcations', l_api_name);
2961: END IF;
2962: fnd_message.set_name('INV', 'INV_NO_RCVTXN');
2963: fnd_msg_pub.add;
2964: RAISE fnd_api.g_exc_error;
2965: END;
2966:
2967: IF l_debug = 1 then

Line 2982: fnd_msg_pub.add;

2978: IF l_debug = 1 then
2979: print_debug('Insufficient information in rcv_transactions', l_api_name);
2980: END IF;
2981: fnd_message.set_name('INV', 'INV_NO_RCVTXN_INFO');
2982: fnd_msg_pub.add;
2983: RAISE fnd_api.g_exc_error;
2984: END IF;
2985:
2986:

Line 3049: fnd_msg_pub.add;

3045: IF l_debug = 1 then
3046: print_debug('cannot find sales order line ', l_api_name);
3047: END IF;
3048: fnd_message.set_name('INV', 'INV_NO_SALES_ORDER_LINE');
3049: fnd_msg_pub.add;
3050: RAISE fnd_api.g_exc_error;
3051: END;
3052:
3053: IF l_debug = 1 then

Line 3078: fnd_msg_pub.add;

3074: END IF;
3075:
3076: IF (l_selling_ou IS NULL) OR (l_ship_from_ou IS NULL) THEN
3077: fnd_message.set_name('INV', 'INV_NULL_SELLSHIP_OU');
3078: fnd_msg_pub.add;
3079: RAISE fnd_api.g_exc_error;
3080: END IF;
3081:
3082: /******* Calling get transaction flow for the operating units*******/

Line 3108: fnd_msg_pub.add;

3104: l_qualifier_value_tbl.DELETE;
3105:
3106: when too_many_rows then
3107: fnd_message.set_name('INV', 'INV_TOO_MANY_CATEGORIES');
3108: fnd_msg_pub.add;
3109: RAISE fnd_api.g_exc_error;
3110: END;
3111:
3112: INV_TRANSACTION_FLOW_PUB.CHECK_TRANSACTION_FLOW

Line 3188: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3184: x_dropship_type_code := -99;
3185: x_transaction_type_id := -99;
3186: x_transaction_action_id := -99;
3187: x_transaction_source_type_id := -99;
3188: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3189:
3190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3192: x_dropship_type_code := -99;

Line 3196: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3192: x_dropship_type_code := -99;
3193: x_transaction_type_id := -99;
3194: x_transaction_action_id := -99;
3195: x_transaction_source_type_id := -99;
3196: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3197:
3198: WHEN OTHERS THEN
3199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3200: x_dropship_type_code := -99;

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

3201: x_transaction_type_id := -99;
3202: x_transaction_action_id := -99;
3203: x_transaction_source_type_id := -99;
3204:
3205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3206: FND_MSG_PUB.Add_Exc_Msg
3207: ( G_PACKAGE_NAME, 'GET_DROPSHIP_PO_TXN_TYPE');
3208: end if;
3209: END GET_DROPSHIP_PO_TXN_TYPE;

Line 3206: FND_MSG_PUB.Add_Exc_Msg

3202: x_transaction_action_id := -99;
3203: x_transaction_source_type_id := -99;
3204:
3205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3206: FND_MSG_PUB.Add_Exc_Msg
3207: ( G_PACKAGE_NAME, 'GET_DROPSHIP_PO_TXN_TYPE');
3208: end if;
3209: END GET_DROPSHIP_PO_TXN_TYPE;
3210:

Line 3293: FND_MSG_PUB.ADD;

3289: EXCEPTION
3290: WHEN NO_DATA_FOUND then
3291: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
3292: FND_MESSAGE.SET_TOKEN('ID', p_reference_id);
3293: FND_MSG_PUB.ADD;
3294: raise FND_API.G_EXC_ERROR;
3295: END;
3296: else
3297: l_progress := 2;

Line 3309: FND_MSG_PUB.ADD;

3305: EXCEPTION
3306: WHEN NO_DATA_FOUND then
3307: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
3308: FND_MESSAGE.SET_TOKEN('LINE', p_reference_id);
3309: FND_MSG_PUB.ADD;
3310: raise FND_API.G_EXC_ERROR;
3311: END;
3312: end if;
3313: else

Line 3325: FND_MSG_PUB.ADD;

3321: EXCEPTION
3322: WHEN NO_DATA_FOUND then
3323: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
3324: FND_MESSAGE.SET_TOKEN('RCVID', p_reference_id);
3325: FND_MSG_PUB.ADD;
3326: raise FND_API.G_EXC_ERROR;
3327: END;
3328: end if;
3329: -- end if; OPM INVCONV

Line 3333: fnd_msg_pub.count_and_get(

3329: -- end if; OPM INVCONV
3330:
3331: x_transaction_date := l_transaction_date;
3332: x_return_status := G_RET_STS_SUCCESS;
3333: fnd_msg_pub.count_and_get(
3334: p_encoded => fnd_api.g_false,
3335: p_count => x_msg_count,
3336: p_data => x_msg_data
3337: );

Line 3343: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3339: return l_organization_id;
3340: EXCEPTION
3341: WHEN FND_API.G_EXC_ERROR then
3342: x_return_status := G_RET_STS_ERROR;
3343: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3344: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3345:
3346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3347: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 3344: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

3340: EXCEPTION
3341: WHEN FND_API.G_EXC_ERROR then
3342: x_return_status := G_RET_STS_ERROR;
3343: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3344: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3345:
3346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3347: x_return_status := G_RET_STS_UNEXP_ERROR;
3348: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 3348: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3344: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3345:
3346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3347: x_return_status := G_RET_STS_UNEXP_ERROR;
3348: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3349: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3350:
3351: WHEN OTHERS then
3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3349: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

3345:
3346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3347: x_return_status := G_RET_STS_UNEXP_ERROR;
3348: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3349: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3350:
3351: WHEN OTHERS then
3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3353: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 3353: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3349: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3350:
3351: WHEN OTHERS then
3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3353: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3354: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3355:
3356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3357: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Get_Inventory_Org');

Line 3354: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

3350:
3351: WHEN OTHERS then
3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3353: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3354: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3355:
3356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3357: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Get_Inventory_Org');
3358: end if;

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

3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3353: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3354: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3355:
3356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3357: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Get_Inventory_Org');
3358: end if;
3359:
3360: print_debug('in When Others, l_progress = ' || l_progress, 'GET_INVENTORY_ORG');

Line 3357: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Get_Inventory_Org');

3353: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3354: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3355:
3356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3357: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Get_Inventory_Org');
3358: end if;
3359:
3360: print_debug('in When Others, l_progress = ' || l_progress, 'GET_INVENTORY_ORG');
3361:

Line 3416: FND_MSG_PUB.ADD;

3412: -- Modified the message text set of books to ledger for making the message compatible with LE uptake project
3413: print_Debug('cannot find the ledger of the ou ', 'Get_Functional_Currency_Code');
3414: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3415: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3416: FND_MSG_PUB.ADD;
3417: raise FND_API.G_EXC_ERROR;
3418: END;
3419: */
3420: BEGIN

Line 3433: FND_MSG_PUB.ADD;

3429: p_account_info_context => 'SOB');
3430: IF NVL(lreturn_status , 'S') = 'E' THEN
3431: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3432: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3433: FND_MSG_PUB.ADD;
3434: print_debug('Cannot find the ledger information for operating unit = '||p_org_id , 9);
3435: RAISE FND_API.G_EXC_ERROR;
3436: END IF;
3437: l_set_of_book_id := lsob_id;

Line 3452: FND_MSG_PUB.ADD;

3448: EXCEPTION
3449: when NO_DATA_FOUND then
3450: print_debug('cannot find the functional currency code', 'get_functional_currency_code');
3451: FND_MESSAGE.SET_NAME('SQLGL', 'GL funct curr does not exist');
3452: FND_MSG_PUB.ADD;
3453: raise FND_API.G_EXC_ERROR;
3454: end;
3455:
3456: print_debug('l_functional_currency_code is ' || l_functional_currency_code, 'get_functional_currency_code');

Line 3463: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3459:
3460: EXCEPTION
3461: WHEN FND_API.G_EXC_ERROR then
3462: x_return_status := G_RET_STS_ERROR;
3463: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3464: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3465: return null;
3466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3467: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 3464: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

3460: EXCEPTION
3461: WHEN FND_API.G_EXC_ERROR then
3462: x_return_status := G_RET_STS_ERROR;
3463: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3464: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3465: return null;
3466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3467: x_return_status := G_RET_STS_UNEXP_ERROR;
3468: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 3468: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3464: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3465: return null;
3466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3467: x_return_status := G_RET_STS_UNEXP_ERROR;
3468: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3469: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3470: return null;
3471:
3472: WHEN OTHERS THEN

Line 3469: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

3465: return null;
3466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3467: x_return_status := G_RET_STS_UNEXP_ERROR;
3468: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3469: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3470: return null;
3471:
3472: WHEN OTHERS THEN
3473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3470: return null;
3471:
3472: WHEN OTHERS THEN
3473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3475: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3476:
3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3478: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'get_functional_currency_code');

Line 3475: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

3471:
3472: WHEN OTHERS THEN
3473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3475: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3476:
3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3478: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'get_functional_currency_code');
3479: end if;

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

3473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3475: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3476:
3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3478: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'get_functional_currency_code');
3479: end if;
3480:
3481: print_debug('in When Others, l_progress = ' || l_progress, 'get_functional_currency_code');

Line 3478: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'get_functional_currency_code');

3474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3475: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3476:
3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3478: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'get_functional_currency_code');
3479: end if;
3480:
3481: print_debug('in When Others, l_progress = ' || l_progress, 'get_functional_currency_code');
3482: print_Debug(sqlerrm, 'get_functional_currency_code');

Line 3590: FND_MSG_PUB.ADD;

3586: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3587: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3588: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3589: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3590: FND_MSG_PUB.ADD;
3591: raise FND_API.G_EXC_ERROR;
3592: elsif( l_transfer_price = -2 ) then
3593: print_Debug('ic invalid currency', 'convert_currency');
3594: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid_Currency');

Line 3596: FND_MSG_PUB.ADD;

3592: elsif( l_transfer_price = -2 ) then
3593: print_Debug('ic invalid currency', 'convert_currency');
3594: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid_Currency');
3595: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3596: FND_MSG_PUB.ADD;
3597: raise FND_API.G_EXC_ERROR;
3598: end if;
3599: else
3600: l_transfer_price := p_transfer_price;

Line 3605: fnd_msg_pub.count_and_get (

3601: end if;
3602:
3603: print_debug('l_transfer_price is ' || l_transfer_price, 'convert_currency');
3604: x_return_status := G_RET_STS_SUCCESS;
3605: fnd_msg_pub.count_and_get (
3606: p_encoded => fnd_api.g_false,
3607: p_count => x_msg_count,
3608: p_data => x_msg_data
3609: );

Line 3617: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3613:
3614: EXCEPTION
3615: WHEN FND_API.G_EXC_ERROR then
3616: x_return_status := G_RET_STS_ERROR;
3617: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3618: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3619: return -99;
3620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3621: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 3618: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

3614: EXCEPTION
3615: WHEN FND_API.G_EXC_ERROR then
3616: x_return_status := G_RET_STS_ERROR;
3617: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3618: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3619: return -99;
3620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3621: x_return_status := G_RET_STS_UNEXP_ERROR;
3622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 3622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3618: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3619: return -99;
3620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3621: x_return_status := G_RET_STS_UNEXP_ERROR;
3622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3623: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3624: return -99;
3625:
3626: WHEN OTHERS THEN

Line 3623: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

3619: return -99;
3620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3621: x_return_status := G_RET_STS_UNEXP_ERROR;
3622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3623: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3624: return -99;
3625:
3626: WHEN OTHERS THEN
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3628: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3624: return -99;
3625:
3626: WHEN OTHERS THEN
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3628: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3629: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3630:
3631: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3632: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Convert_Currency');

Line 3629: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

3625:
3626: WHEN OTHERS THEN
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3628: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3629: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3630:
3631: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3632: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Convert_Currency');
3633: end if;

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

3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3628: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3629: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3630:
3631: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3632: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Convert_Currency');
3633: end if;
3634:
3635: print_debug('in When Others, l_progress = ' || l_progress, 'Convert_Currency');

Line 3632: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Convert_Currency');

3628: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3629: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3630:
3631: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3632: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Convert_Currency');
3633: end if;
3634:
3635: print_debug('in When Others, l_progress = ' || l_progress, 'Convert_Currency');
3636: print_Debug(sqlerrm, 'Convert_Currency');

Line 3761: fnd_msg_pub.initialize;

3757: END IF;
3758:
3759: -- Initialize message list.
3760: IF fnd_api.to_boolean(p_init_msg_list) THEN
3761: fnd_msg_pub.initialize;
3762: END IF;
3763:
3764: --
3765: -- Bug 5171637/5138311 umoogala: INVCONV

Line 3867: FND_MSG_PUB.ADD;

3863:
3864: if( l_return_status <> G_RET_STS_SUCCESS ) then
3865: print_Debug('Error from mtl_intercompany_invoices.get_transfer_price', 'get_transfer_price_for_item');
3866: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_EXT_TRANSFER_PRICE');
3867: FND_MSG_PUB.ADD;
3868: raise FND_API.G_EXC_ERROR;
3869: end if;
3870:
3871: if( nvl(l_transfer_price, -1) = -1 ) then

Line 3978: FND_MSG_PUB.ADD;

3974: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
3975: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
3976: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
3977: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
3978: FND_MSG_PUB.ADD;
3979: raise fnd_api.g_exc_error;
3980: end if;
3981: end;
3982: when others then

Line 3987: FND_MSG_PUB.ADD;

3983: print_debug('sqlerrm = ' || sqlerrm, 'get_transfer_price_for_item');
3984: l_transfer_price := 0;
3985: l_return_status := G_RET_STS_ERROR;
3986: FND_MESSAGE.SET_NAME('INV', 'IC-No Transfer Price');
3987: FND_MSG_PUB.ADD;
3988: raise fnd_api.g_exc_error;
3989: END;
3990: else
3991: l_qp_price_flag := TRUE;

Line 4062: fnd_msg_pub.add;

4058: end if;
4059: EXCEPTION
4060: when others then
4061: fnd_message.set_name('INV', 'INV_INT_SQLCODE');
4062: fnd_msg_pub.add;
4063: raise FND_API.G_EXC_ERROR;
4064: end;*/
4065:
4066: /* Added this for bug 3141793

Line 4107: FND_MSG_PUB.ADD;

4103:
4104: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4105: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4106: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4107: FND_MSG_PUB.ADD;
4108: raise FND_API.G_EXC_ERROR;
4109: END;
4110:
4111:

Line 4197: FND_MSG_PUB.ADD;

4193: if( l_transfer_price = -99 ) THEN
4194: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4195: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4196: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4197: FND_MSG_PUB.ADD;
4198: l_transfer_price := 0;
4199: end if;
4200:
4201: if( l_transfer_price is null ) then

Line 4205: FND_MSG_PUB.ADD;

4201: if( l_transfer_price is null ) then
4202: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4203: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4204: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4205: FND_MSG_PUB.ADD;
4206: l_transfer_price := 0;
4207: end if;
4208: end if; -- if( QP_UTIL.get_qp_status <> 'I' OR l_qp_profile <> 1 )
4209: end if; -- if( nvl(l_transfer_price, -1) = -1 )

Line 4243: FND_MSG_PUB.ADD;

4239: print_debug('Error from Calling uom_conversion', 'get_transfer_price_for_item');
4240: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
4241: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
4242: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);
4243: FND_MSG_PUB.ADD;
4244: raise FND_API.G_EXC_ERROR;
4245: end if;
4246: print_debug('l_uom_rate is ' || l_uom_rate, 'get_transfer_price_for_item');
4247:

Line 4287: fnd_msg_pub.count_and_get(

4283: x_transfer_price := l_transfer_price;
4284: x_currency_code := l_functional_currency_code;
4285: x_return_status := l_return_status;
4286:
4287: fnd_msg_pub.count_and_get(
4288: p_encoded => fnd_api.g_false,
4289: p_count => x_msg_count,
4290: p_data => x_msg_data
4291: );

Line 4296: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

4292: EXCEPTION
4293: WHEN FND_API.G_EXC_ERROR THEN
4294: x_return_status := G_RET_STS_ERROR;
4295: x_transfer_price := -99;
4296: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4297: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4298:
4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 4297: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

4293: WHEN FND_API.G_EXC_ERROR THEN
4294: x_return_status := G_RET_STS_ERROR;
4295: x_transfer_price := -99;
4296: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4297: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4298:
4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: x_return_status := G_RET_STS_UNEXP_ERROR;
4301: x_transfer_price := -99;

Line 4302: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

4298:
4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: x_return_status := G_RET_STS_UNEXP_ERROR;
4301: x_transfer_price := -99;
4302: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4303: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4304:
4305: WHEN OTHERS then
4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4303: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: x_return_status := G_RET_STS_UNEXP_ERROR;
4301: x_transfer_price := -99;
4302: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4303: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4304:
4305: WHEN OTHERS then
4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4307: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 4307: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

4303: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4304:
4305: WHEN OTHERS then
4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4307: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4308: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4309:
4310: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4311: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

Line 4308: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

4304:
4305: WHEN OTHERS then
4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4307: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4308: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4309:
4310: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4311: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4312: end if;

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

4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4307: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4308: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4309:
4310: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4311: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4312: end if;
4313:
4314: print_debug('in When Others, l_progress = ' || l_progress, 'Get_Transfer_price');

Line 4311: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

4307: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4308: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4309:
4310: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4311: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4312: end if;
4313:
4314: print_debug('in When Others, l_progress = ' || l_progress, 'Get_Transfer_price');
4315:

Line 4423: fnd_msg_pub.initialize;

4419:
4420:
4421: -- Initialize message list.
4422: IF fnd_api.to_boolean(p_init_msg_list) THEN
4423: fnd_msg_pub.initialize;
4424: END IF;
4425:
4426:
4427: print_debug('START GET_TRANSFER_PRICE', 'GET_TRANSFER_PRICE');

Line 4487: FND_MSG_PUB.ADD;

4483:
4484: if( l_exists = 0 ) then
4485: print_debug('FROM OU is invalid', 'GET_TRANSFER_PRICE');
4486: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_FROM_OU');
4487: FND_MSG_PUB.ADD;
4488: raise FND_API.G_EXC_ERROR;
4489: -- throw error invalid from operating unit
4490: end if;
4491:

Line 4518: FND_MSG_PUB.ADD;

4514:
4515: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4516: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4517: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4518: FND_MSG_PUB.ADD;
4519: raise FND_API.G_EXC_ERROR;
4520: -- throw error invalid no intercompany parameters defined
4521: END;
4522:

Line 4540: FND_MSG_PUB.ADD;

4536: print_debug('Cannot find item ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4537: FND_MESSAGE.SET_NAME('INV', 'INV_IC_INVALID_ITEM_ORG');
4538: FND_MESSAGE.SET_TOKEN('ITEM', p_inventory_item_id);
4539: FND_MESSAGE.SET_TOKEN('ORG', l_organization_id);
4540: FND_MSG_PUB.ADD;
4541: raise FND_API.G_EXC_ERROR;
4542: END;
4543:
4544: l_progress := 4;

Line 4590: FND_MSG_PUB.ADD;

4586: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4587: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4588: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4589: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4590: FND_MSG_PUB.ADD;
4591: raise FND_API.G_EXC_ERROR;
4592: end if;
4593: EXCEPTION
4594: when no_data_found then

Line 4603: FND_MSG_PUB.ADD;

4599: WHERE organization_id = p_from_org_id;
4600:
4601: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid Customer');
4602: FND_MESSAGE.SET_TOKEN('OU', l_from_ou_name);
4603: FND_MSG_PUB.ADD;
4604: raise FND_API.G_EXC_ERROR;
4605: END;
4606:
4607: -- call get_transfer_price_for_item for the base item

Line 4728: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4724: x_currency_code := l_functional_currency_code;
4725: x_incr_transfer_price := l_inv_transfer_price;
4726: x_incr_currency_code := l_inv_currency_code;
4727: x_return_status := G_RET_STS_SUCCESS;
4728: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4729: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4730: EXCEPTION
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 4729: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

4725: x_incr_transfer_price := l_inv_transfer_price;
4726: x_incr_currency_code := l_inv_currency_code;
4727: x_return_status := G_RET_STS_SUCCESS;
4728: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4729: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4730: EXCEPTION
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732: x_return_status := G_RET_STS_UNEXP_ERROR;
4733: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4733: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4729: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4730: EXCEPTION
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732: x_return_status := G_RET_STS_UNEXP_ERROR;
4733: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4734: print_debug('In Exc_Unexpected_Error ' || l_progress, 'Get_Transfer_price');
4735: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4736:
4737: WHEN FND_API.G_EXC_ERROR THEN

Line 4735: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732: x_return_status := G_RET_STS_UNEXP_ERROR;
4733: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4734: print_debug('In Exc_Unexpected_Error ' || l_progress, 'Get_Transfer_price');
4735: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4736:
4737: WHEN FND_API.G_EXC_ERROR THEN
4738: x_return_status := G_RET_STS_ERROR;
4739: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4739: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4735: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4736:
4737: WHEN FND_API.G_EXC_ERROR THEN
4738: x_return_status := G_RET_STS_ERROR;
4739: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4740: print_debug('In EXC_ERROR ' || l_progress, 'Get_Transfer_Price');
4741: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4742:
4743:

Line 4741: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

4737: WHEN FND_API.G_EXC_ERROR THEN
4738: x_return_status := G_RET_STS_ERROR;
4739: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4740: print_debug('In EXC_ERROR ' || l_progress, 'Get_Transfer_Price');
4741: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4742:
4743:
4744: WHEN OTHERS then
4745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4746: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

4742:
4743:
4744: WHEN OTHERS then
4745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4746: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4747: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4748:
4749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4750: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

Line 4747: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

4743:
4744: WHEN OTHERS then
4745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4746: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4747: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4748:
4749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4750: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4751: end if;

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

4745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4746: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4747: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4748:
4749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4750: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4751: end if;
4752:
4753: print_debug('in When Others, l_progress = ' || l_progress, 'Get_Transfer_price');

Line 4750: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

4746: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4747: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4748:
4749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4750: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4751: end if;
4752:
4753: print_debug('in When Others, l_progress = ' || l_progress, 'Get_Transfer_price');
4754: