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 2924: fnd_msg_pub.initialize;

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

Line 2942: fnd_msg_pub.add;

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

Line 2964: fnd_msg_pub.add;

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

Line 2983: fnd_msg_pub.add;

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

Line 3061: fnd_msg_pub.add;

3057: IF l_debug = 1 then
3058: print_debug('cannot find sales order line ', l_api_name);
3059: END IF;
3060: fnd_message.set_name('INV', 'INV_NO_SALES_ORDER_LINE');
3061: fnd_msg_pub.add;
3062: RAISE fnd_api.g_exc_error;
3063: END;
3064:
3065: IF l_debug = 1 then

Line 3090: fnd_msg_pub.add;

3086: END IF;
3087:
3088: IF (l_selling_ou IS NULL) OR (l_ship_from_ou IS NULL) THEN
3089: fnd_message.set_name('INV', 'INV_NULL_SELLSHIP_OU');
3090: fnd_msg_pub.add;
3091: RAISE fnd_api.g_exc_error;
3092: END IF;
3093:
3094: /******* Calling get transaction flow for the operating units*******/

Line 3120: fnd_msg_pub.add;

3116: l_qualifier_value_tbl.DELETE;
3117:
3118: when too_many_rows then
3119: fnd_message.set_name('INV', 'INV_TOO_MANY_CATEGORIES');
3120: fnd_msg_pub.add;
3121: RAISE fnd_api.g_exc_error;
3122: END;
3123:
3124: INV_TRANSACTION_FLOW_PUB.CHECK_TRANSACTION_FLOW

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

3196: x_dropship_type_code := -99;
3197: x_transaction_type_id := -99;
3198: x_transaction_action_id := -99;
3199: x_transaction_source_type_id := -99;
3200: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3201:
3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3204: x_dropship_type_code := -99;

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

3204: x_dropship_type_code := -99;
3205: x_transaction_type_id := -99;
3206: x_transaction_action_id := -99;
3207: x_transaction_source_type_id := -99;
3208: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3209:
3210: WHEN OTHERS THEN
3211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3212: x_dropship_type_code := -99;

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

3213: x_transaction_type_id := -99;
3214: x_transaction_action_id := -99;
3215: x_transaction_source_type_id := -99;
3216:
3217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3218: FND_MSG_PUB.Add_Exc_Msg
3219: ( G_PACKAGE_NAME, 'GET_DROPSHIP_PO_TXN_TYPE');
3220: end if;
3221: END GET_DROPSHIP_PO_TXN_TYPE;

Line 3218: FND_MSG_PUB.Add_Exc_Msg

3214: x_transaction_action_id := -99;
3215: x_transaction_source_type_id := -99;
3216:
3217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3218: FND_MSG_PUB.Add_Exc_Msg
3219: ( G_PACKAGE_NAME, 'GET_DROPSHIP_PO_TXN_TYPE');
3220: end if;
3221: END GET_DROPSHIP_PO_TXN_TYPE;
3222:

Line 3305: FND_MSG_PUB.ADD;

3301: EXCEPTION
3302: WHEN NO_DATA_FOUND then
3303: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
3304: FND_MESSAGE.SET_TOKEN('ID', p_reference_id);
3305: FND_MSG_PUB.ADD;
3306: raise FND_API.G_EXC_ERROR;
3307: END;
3308: else
3309: l_progress := 2;

Line 3321: FND_MSG_PUB.ADD;

3317: EXCEPTION
3318: WHEN NO_DATA_FOUND then
3319: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
3320: FND_MESSAGE.SET_TOKEN('LINE', p_reference_id);
3321: FND_MSG_PUB.ADD;
3322: raise FND_API.G_EXC_ERROR;
3323: END;
3324: end if;
3325: else

Line 3337: FND_MSG_PUB.ADD;

3333: EXCEPTION
3334: WHEN NO_DATA_FOUND then
3335: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
3336: FND_MESSAGE.SET_TOKEN('RCVID', p_reference_id);
3337: FND_MSG_PUB.ADD;
3338: raise FND_API.G_EXC_ERROR;
3339: END;
3340: end if;
3341: -- end if; OPM INVCONV

Line 3345: fnd_msg_pub.count_and_get(

3341: -- end if; OPM INVCONV
3342:
3343: x_transaction_date := l_transaction_date;
3344: x_return_status := G_RET_STS_SUCCESS;
3345: fnd_msg_pub.count_and_get(
3346: p_encoded => fnd_api.g_false,
3347: p_count => x_msg_count,
3348: p_data => x_msg_data
3349: );

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

3351: return l_organization_id;
3352: EXCEPTION
3353: WHEN FND_API.G_EXC_ERROR then
3354: x_return_status := G_RET_STS_ERROR;
3355: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3356: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3357:
3358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3359: x_return_status := G_RET_STS_UNEXP_ERROR;

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

3352: EXCEPTION
3353: WHEN FND_API.G_EXC_ERROR then
3354: x_return_status := G_RET_STS_ERROR;
3355: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3356: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3357:
3358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3359: x_return_status := G_RET_STS_UNEXP_ERROR;
3360: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

3356: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3357:
3358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3359: x_return_status := G_RET_STS_UNEXP_ERROR;
3360: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3361: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3362:
3363: WHEN OTHERS then
3364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

3357:
3358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3359: x_return_status := G_RET_STS_UNEXP_ERROR;
3360: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3361: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3362:
3363: WHEN OTHERS then
3364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3365: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

3361: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3362:
3363: WHEN OTHERS then
3364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3365: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3366: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3367:
3368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3369: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Get_Inventory_Org');

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

3362:
3363: WHEN OTHERS then
3364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3365: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3366: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3367:
3368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3369: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Get_Inventory_Org');
3370: end if;

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

3364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3365: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3366: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3367:
3368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3369: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Get_Inventory_Org');
3370: end if;
3371:
3372: print_debug('in When Others, l_progress = ' || l_progress, 'GET_INVENTORY_ORG');

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

3365: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3366: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3367:
3368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3369: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Get_Inventory_Org');
3370: end if;
3371:
3372: print_debug('in When Others, l_progress = ' || l_progress, 'GET_INVENTORY_ORG');
3373:

Line 3428: FND_MSG_PUB.ADD;

3424: -- Modified the message text set of books to ledger for making the message compatible with LE uptake project
3425: print_Debug('cannot find the ledger of the ou ', 'Get_Functional_Currency_Code');
3426: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3427: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3428: FND_MSG_PUB.ADD;
3429: raise FND_API.G_EXC_ERROR;
3430: END;
3431: */
3432: BEGIN

Line 3445: FND_MSG_PUB.ADD;

3441: p_account_info_context => 'SOB');
3442: IF NVL(lreturn_status , 'S') = 'E' THEN
3443: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3444: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3445: FND_MSG_PUB.ADD;
3446: print_debug('Cannot find the ledger information for operating unit = '||p_org_id , 9);
3447: RAISE FND_API.G_EXC_ERROR;
3448: END IF;
3449: l_set_of_book_id := lsob_id;

Line 3464: FND_MSG_PUB.ADD;

3460: EXCEPTION
3461: when NO_DATA_FOUND then
3462: print_debug('cannot find the functional currency code', 'get_functional_currency_code');
3463: FND_MESSAGE.SET_NAME('SQLGL', 'GL funct curr does not exist');
3464: FND_MSG_PUB.ADD;
3465: raise FND_API.G_EXC_ERROR;
3466: end;
3467:
3468: print_debug('l_functional_currency_code is ' || l_functional_currency_code, 'get_functional_currency_code');

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

3471:
3472: EXCEPTION
3473: WHEN FND_API.G_EXC_ERROR then
3474: x_return_status := G_RET_STS_ERROR;
3475: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3476: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3477: return null;
3478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3479: x_return_status := G_RET_STS_UNEXP_ERROR;

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

3472: EXCEPTION
3473: WHEN FND_API.G_EXC_ERROR then
3474: x_return_status := G_RET_STS_ERROR;
3475: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3476: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3477: return null;
3478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3479: x_return_status := G_RET_STS_UNEXP_ERROR;
3480: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

3476: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3477: return null;
3478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3479: x_return_status := G_RET_STS_UNEXP_ERROR;
3480: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3481: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3482: return null;
3483:
3484: WHEN OTHERS THEN

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

3477: return null;
3478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3479: x_return_status := G_RET_STS_UNEXP_ERROR;
3480: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3481: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3482: return null;
3483:
3484: WHEN OTHERS THEN
3485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

3482: return null;
3483:
3484: WHEN OTHERS THEN
3485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3486: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3487: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3488:
3489: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3490: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'get_functional_currency_code');

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

3483:
3484: WHEN OTHERS THEN
3485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3486: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3487: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3488:
3489: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3490: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'get_functional_currency_code');
3491: end if;

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

3485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3486: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3487: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3488:
3489: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3490: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'get_functional_currency_code');
3491: end if;
3492:
3493: print_debug('in When Others, l_progress = ' || l_progress, 'get_functional_currency_code');

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

3486: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3487: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3488:
3489: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3490: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'get_functional_currency_code');
3491: end if;
3492:
3493: print_debug('in When Others, l_progress = ' || l_progress, 'get_functional_currency_code');
3494: print_Debug(sqlerrm, 'get_functional_currency_code');

Line 3631: FND_MSG_PUB.ADD;

3627: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3628: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3629: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3630: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3631: FND_MSG_PUB.ADD;
3632: raise FND_API.G_EXC_ERROR;
3633: elsif( l_transfer_price = -2 ) then
3634: print_Debug('ic invalid currency', 'convert_currency');
3635: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid_Currency');

Line 3637: FND_MSG_PUB.ADD;

3633: elsif( l_transfer_price = -2 ) then
3634: print_Debug('ic invalid currency', 'convert_currency');
3635: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid_Currency');
3636: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3637: FND_MSG_PUB.ADD;
3638: raise FND_API.G_EXC_ERROR;
3639: end if;
3640: else
3641: l_transfer_price := p_transfer_price;

Line 3646: fnd_msg_pub.count_and_get (

3642: end if;
3643:
3644: print_debug('l_transfer_price is ' || l_transfer_price, 'convert_currency');
3645: x_return_status := G_RET_STS_SUCCESS;
3646: fnd_msg_pub.count_and_get (
3647: p_encoded => fnd_api.g_false,
3648: p_count => x_msg_count,
3649: p_data => x_msg_data
3650: );

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

3654:
3655: EXCEPTION
3656: WHEN FND_API.G_EXC_ERROR then
3657: x_return_status := G_RET_STS_ERROR;
3658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3659: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3660: return -99;
3661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3662: x_return_status := G_RET_STS_UNEXP_ERROR;

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

3655: EXCEPTION
3656: WHEN FND_API.G_EXC_ERROR then
3657: x_return_status := G_RET_STS_ERROR;
3658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3659: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3660: return -99;
3661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3662: x_return_status := G_RET_STS_UNEXP_ERROR;
3663: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

3659: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3660: return -99;
3661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3662: x_return_status := G_RET_STS_UNEXP_ERROR;
3663: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3664: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3665: return -99;
3666:
3667: WHEN OTHERS THEN

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

3660: return -99;
3661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3662: x_return_status := G_RET_STS_UNEXP_ERROR;
3663: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3664: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3665: return -99;
3666:
3667: WHEN OTHERS THEN
3668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

3665: return -99;
3666:
3667: WHEN OTHERS THEN
3668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3669: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3670: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3671:
3672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3673: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Convert_Currency');

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

3666:
3667: WHEN OTHERS THEN
3668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3669: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3670: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3671:
3672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3673: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Convert_Currency');
3674: end if;

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

3668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3669: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3670: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3671:
3672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3673: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Convert_Currency');
3674: end if;
3675:
3676: print_debug('in When Others, l_progress = ' || l_progress, 'Convert_Currency');

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

3669: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3670: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
3671:
3672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3673: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'Convert_Currency');
3674: end if;
3675:
3676: print_debug('in When Others, l_progress = ' || l_progress, 'Convert_Currency');
3677: print_Debug(sqlerrm, 'Convert_Currency');

Line 3803: fnd_msg_pub.initialize;

3799: END IF;
3800:
3801: -- Initialize message list.
3802: IF fnd_api.to_boolean(p_init_msg_list) THEN
3803: fnd_msg_pub.initialize;
3804: END IF;
3805:
3806: --
3807: -- Bug 5171637/5138311 umoogala: INVCONV

Line 3920: FND_MSG_PUB.ADD;

3916:
3917: if( l_return_status <> G_RET_STS_SUCCESS ) then
3918: print_Debug('Error from mtl_intercompany_invoices.get_transfer_price', 'get_transfer_price_for_item');
3919: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_EXT_TRANSFER_PRICE');
3920: FND_MSG_PUB.ADD;
3921: raise FND_API.G_EXC_ERROR;
3922: end if;
3923:
3924: if( nvl(l_transfer_price, -1) = -1 ) then

Line 4060: FND_MSG_PUB.ADD;

4056: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
4057: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4058: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
4059: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
4060: FND_MSG_PUB.ADD;
4061: raise fnd_api.g_exc_error;
4062: end if;
4063: end;
4064: when others then

Line 4069: FND_MSG_PUB.ADD;

4065: print_debug('sqlerrm = ' || sqlerrm, 'get_transfer_price_for_item');
4066: l_transfer_price := 0;
4067: l_return_status := G_RET_STS_ERROR;
4068: FND_MESSAGE.SET_NAME('INV', 'IC-No Transfer Price');
4069: FND_MSG_PUB.ADD;
4070: raise fnd_api.g_exc_error;
4071: END;
4072: else
4073: l_qp_price_flag := TRUE;

Line 4144: fnd_msg_pub.add;

4140: end if;
4141: EXCEPTION
4142: when others then
4143: fnd_message.set_name('INV', 'INV_INT_SQLCODE');
4144: fnd_msg_pub.add;
4145: raise FND_API.G_EXC_ERROR;
4146: end;*/
4147:
4148: /* Added this for bug 3141793

Line 4189: FND_MSG_PUB.ADD;

4185:
4186: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4187: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4188: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4189: FND_MSG_PUB.ADD;
4190: raise FND_API.G_EXC_ERROR;
4191: END;
4192:
4193:

Line 4301: FND_MSG_PUB.ADD;

4297: if( l_transfer_price = -99 ) THEN
4298: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4299: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4300: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4301: FND_MSG_PUB.ADD;
4302: l_transfer_price := 0;
4303: end if;
4304:
4305: if( l_transfer_price is null ) then

Line 4309: FND_MSG_PUB.ADD;

4305: if( l_transfer_price is null ) then
4306: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4307: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4308: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4309: FND_MSG_PUB.ADD;
4310: l_transfer_price := 0;
4311: end if;
4312: end if; -- if( QP_UTIL.get_qp_status <> 'I' OR l_qp_profile <> 1 )
4313: end if; -- if( nvl(l_transfer_price, -1) = -1 )

Line 4347: FND_MSG_PUB.ADD;

4343: print_debug('Error from Calling uom_conversion', 'get_transfer_price_for_item');
4344: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
4345: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
4346: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);
4347: FND_MSG_PUB.ADD;
4348: raise FND_API.G_EXC_ERROR;
4349: end if;
4350: print_debug('l_uom_rate is ' || l_uom_rate, 'get_transfer_price_for_item');
4351:

Line 4391: fnd_msg_pub.count_and_get(

4387: x_transfer_price := l_transfer_price;
4388: x_currency_code := l_functional_currency_code;
4389: x_return_status := l_return_status;
4390:
4391: fnd_msg_pub.count_and_get(
4392: p_encoded => fnd_api.g_false,
4393: p_count => x_msg_count,
4394: p_data => x_msg_data
4395: );

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

4396: EXCEPTION
4397: WHEN FND_API.G_EXC_ERROR THEN
4398: x_return_status := G_RET_STS_ERROR;
4399: x_transfer_price := -99;
4400: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4401: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4402:
4403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4404: x_return_status := G_RET_STS_UNEXP_ERROR;

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

4397: WHEN FND_API.G_EXC_ERROR THEN
4398: x_return_status := G_RET_STS_ERROR;
4399: x_transfer_price := -99;
4400: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4401: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4402:
4403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4404: x_return_status := G_RET_STS_UNEXP_ERROR;
4405: x_transfer_price := -99;

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

4402:
4403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4404: x_return_status := G_RET_STS_UNEXP_ERROR;
4405: x_transfer_price := -99;
4406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4407: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4408:
4409: WHEN OTHERS then
4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

4403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4404: x_return_status := G_RET_STS_UNEXP_ERROR;
4405: x_transfer_price := -99;
4406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4407: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4408:
4409: WHEN OTHERS then
4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4411: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

4407: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4408:
4409: WHEN OTHERS then
4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4411: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4412: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4413:
4414: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4415: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

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

4408:
4409: WHEN OTHERS then
4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4411: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4412: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4413:
4414: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4415: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4416: end if;

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

4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4411: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4412: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4413:
4414: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4415: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4416: end if;
4417:
4418: print_debug('in When Others, l_progress = ' || l_progress, 'Get_Transfer_price');

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

4411: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4412: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4413:
4414: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4415: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4416: end if;
4417:
4418: print_debug('in When Others, l_progress = ' || l_progress, 'Get_Transfer_price');
4419:

Line 4528: fnd_msg_pub.initialize;

4524:
4525:
4526: -- Initialize message list.
4527: IF fnd_api.to_boolean(p_init_msg_list) THEN
4528: fnd_msg_pub.initialize;
4529: END IF;
4530:
4531:
4532: print_debug('START GET_TRANSFER_PRICE', 'GET_TRANSFER_PRICE');

Line 4585: FND_MSG_PUB.ADD;

4581: EXCEPTION
4582: WHEN NO_DATA_FOUND then
4583: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
4584: FND_MESSAGE.SET_TOKEN('ID', p_transaction_id);
4585: FND_MSG_PUB.ADD;
4586: raise FND_API.G_EXC_ERROR;
4587: END;
4588: else
4589: print_debug('Inside p_drop_ship_flag = Y', 'GET_TRANSFER_PRICE');

Line 4600: FND_MSG_PUB.ADD;

4596: EXCEPTION
4597: WHEN NO_DATA_FOUND then
4598: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
4599: FND_MESSAGE.SET_TOKEN('LINE', p_transaction_id);
4600: FND_MSG_PUB.ADD;
4601: raise FND_API.G_EXC_ERROR;
4602: END;
4603: end if;
4604: else

Line 4615: FND_MSG_PUB.ADD;

4611: EXCEPTION
4612: WHEN NO_DATA_FOUND then
4613: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
4614: FND_MESSAGE.SET_TOKEN('RCVID', p_transaction_id);
4615: FND_MSG_PUB.ADD;
4616: raise FND_API.G_EXC_ERROR;
4617: END;
4618: end if;
4619:

Line 4656: FND_MSG_PUB.ADD;

4652:
4653: if( l_exists = 0 ) then
4654: print_debug('FROM OU is invalid', 'GET_TRANSFER_PRICE');
4655: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_FROM_OU');
4656: FND_MSG_PUB.ADD;
4657: raise FND_API.G_EXC_ERROR;
4658: -- throw error invalid from operating unit
4659: end if;
4660:

Line 4687: FND_MSG_PUB.ADD;

4683:
4684: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4685: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4686: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4687: FND_MSG_PUB.ADD;
4688: raise FND_API.G_EXC_ERROR;
4689: -- throw error invalid no intercompany parameters defined
4690: END;
4691:

Line 4709: FND_MSG_PUB.ADD;

4705: print_debug('Cannot find item ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4706: FND_MESSAGE.SET_NAME('INV', 'INV_IC_INVALID_ITEM_ORG');
4707: FND_MESSAGE.SET_TOKEN('ITEM', p_inventory_item_id);
4708: FND_MESSAGE.SET_TOKEN('ORG', l_organization_id);
4709: FND_MSG_PUB.ADD;
4710: raise FND_API.G_EXC_ERROR;
4711: END;
4712:
4713: l_progress := 4;

Line 4759: FND_MSG_PUB.ADD;

4755: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4756: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4757: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4758: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4759: FND_MSG_PUB.ADD;
4760: raise FND_API.G_EXC_ERROR;
4761: end if;
4762: EXCEPTION
4763: when no_data_found then

Line 4772: FND_MSG_PUB.ADD;

4768: WHERE organization_id = p_from_org_id;
4769:
4770: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid Customer');
4771: FND_MESSAGE.SET_TOKEN('OU', l_from_ou_name);
4772: FND_MSG_PUB.ADD;
4773: raise FND_API.G_EXC_ERROR;
4774: END;
4775:
4776: -- call get_transfer_price_for_item for the base item

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

4894: x_currency_code := l_functional_currency_code;
4895: x_incr_transfer_price := l_inv_transfer_price;
4896: x_incr_currency_code := l_inv_currency_code;
4897: x_return_status := G_RET_STS_SUCCESS;
4898: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4899: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4900: EXCEPTION
4901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4902: x_return_status := G_RET_STS_UNEXP_ERROR;

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

4895: x_incr_transfer_price := l_inv_transfer_price;
4896: x_incr_currency_code := l_inv_currency_code;
4897: x_return_status := G_RET_STS_SUCCESS;
4898: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4899: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4900: EXCEPTION
4901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4902: x_return_status := G_RET_STS_UNEXP_ERROR;
4903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4899: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4900: EXCEPTION
4901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4902: x_return_status := G_RET_STS_UNEXP_ERROR;
4903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4904: print_debug('In Exc_Unexpected_Error ' || l_progress, 'Get_Transfer_price');
4905: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4906:
4907: WHEN FND_API.G_EXC_ERROR THEN

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

4901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4902: x_return_status := G_RET_STS_UNEXP_ERROR;
4903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4904: print_debug('In Exc_Unexpected_Error ' || l_progress, 'Get_Transfer_price');
4905: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4906:
4907: WHEN FND_API.G_EXC_ERROR THEN
4908: x_return_status := G_RET_STS_ERROR;
4909: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4905: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4906:
4907: WHEN FND_API.G_EXC_ERROR THEN
4908: x_return_status := G_RET_STS_ERROR;
4909: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4910: print_debug('In EXC_ERROR ' || l_progress, 'Get_Transfer_Price');
4911: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4912:
4913:

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

4907: WHEN FND_API.G_EXC_ERROR THEN
4908: x_return_status := G_RET_STS_ERROR;
4909: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4910: print_debug('In EXC_ERROR ' || l_progress, 'Get_Transfer_Price');
4911: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4912:
4913:
4914: WHEN OTHERS then
4915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

4912:
4913:
4914: WHEN OTHERS then
4915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4916: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4917: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4918:
4919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4920: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

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

4913:
4914: WHEN OTHERS then
4915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4916: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4917: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4918:
4919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4920: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4921: end if;

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

4915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4916: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4917: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4918:
4919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4920: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4921: end if;
4922:
4923: print_debug('in When Others, l_progress = ' || l_progress, 'Get_Transfer_price');

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

4916: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
4917: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
4918:
4919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4920: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
4921: end if;
4922:
4923: print_debug('in When Others, l_progress = ' || l_progress, 'Get_Transfer_price');
4924:

Line 4993: FND_MSG_PUB.ADD;

4989: exception
4990: when no_data_found then
4991: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
4992: FND_MESSAGE.SET_TOKEN('LINE', p_order_line_id);
4993: FND_MSG_PUB.ADD;
4994: raise FND_API.G_EXC_ERROR;
4995: end;
4996: else
4997: -- this is global procurement flow.

Line 5008: FND_MSG_PUB.ADD;

5004: and pol.po_line_id = p_order_line_id;
5005: exception
5006: when no_data_found then
5007: FND_MESSAGE.SET_NAME('INV', 'INV_INT_PO');
5008: FND_MSG_PUB.ADD;
5009: raise FND_API.G_EXC_ERROR;
5010: end;
5011: end if; --p_global_procurement_flag = 'N'
5012: else

Line 5032: FND_MSG_PUB.ADD;

5028: exception
5029: when no_data_found then
5030: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
5031: FND_MESSAGE.SET_TOKEN('ID', l_line_id);
5032: FND_MSG_PUB.ADD;
5033: raise FND_API.G_EXC_ERROR;
5034: end;
5035: elsif l_doc_type = 'PORC' THEN
5036: begin

Line 5052: FND_MSG_PUB.ADD;

5048: exception
5049: when no_data_found then
5050: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
5051: FND_MESSAGE.SET_TOKEN('RCVID', l_line_id);
5052: FND_MSG_PUB.ADD;
5053: raise FND_API.G_EXC_ERROR;
5054: end;
5055: end if;
5056: else

Line 5071: FND_MSG_PUB.ADD;

5067: exception
5068: when no_data_found then
5069: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
5070: FND_MESSAGE.SET_TOKEN('ID', p_order_line_id);
5071: FND_MSG_PUB.ADD;
5072: raise FND_API.G_EXC_ERROR;
5073: end;
5074: else
5075: -- this is a true drop ship with procuring flow

Line 5085: FND_MSG_PUB.ADD;

5081: EXCEPTION
5082: WHEN NO_DATA_FOUND then
5083: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
5084: FND_MESSAGE.SET_TOKEN('LINE', p_transaction_id);
5085: FND_MSG_PUB.ADD;
5086: raise FND_API.G_EXC_ERROR;
5087: END;
5088: end if; --if( p_drop_ship_flag = 'N')
5089: else

Line 5102: FND_MSG_PUB.ADD;

5098: exception
5099: when no_data_found then
5100: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
5101: FND_MESSAGE.SET_TOKEN('RCVID', p_transaction_id);
5102: FND_MSG_PUB.ADD;
5103: raise FND_API.G_EXC_ERROR;
5104: end;
5105: end if; --if( p_global_procurement_flag = 'N' )
5106: end if; --if ( GML_PROCESS_FLAGS.process_orgn = 1

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

5121:
5122: EXCEPTION
5123: WHEN FND_API.G_EXC_ERROR then
5124: x_return_status := G_RET_STS_ERROR;
5125: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5126: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5128: x_return_status := G_RET_STS_UNEXP_ERROR;
5129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

5122: EXCEPTION
5123: WHEN FND_API.G_EXC_ERROR then
5124: x_return_status := G_RET_STS_ERROR;
5125: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5126: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5128: x_return_status := G_RET_STS_UNEXP_ERROR;
5129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5130: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

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

5125: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5126: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5128: x_return_status := G_RET_STS_UNEXP_ERROR;
5129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5130: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5131: WHEN OTHERS then
5132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5133: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

5126: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5128: x_return_status := G_RET_STS_UNEXP_ERROR;
5129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5130: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5131: WHEN OTHERS then
5132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5133: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5134: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

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

5129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5130: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5131: WHEN OTHERS then
5132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5133: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5134: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5135:
5136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5137: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'GET_TRANSFER_PRICE_DATE');

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

5130: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5131: WHEN OTHERS then
5132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5133: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5134: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5135:
5136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5137: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'GET_TRANSFER_PRICE_DATE');
5138: end if;

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

5132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5133: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5134: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5135:
5136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5137: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'GET_TRANSFER_PRICE_DATE');
5138: end if;
5139: END get_transfer_price_date;
5140:

Line 5137: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'GET_TRANSFER_PRICE_DATE');

5133: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
5134: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
5135:
5136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5137: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, 'GET_TRANSFER_PRICE_DATE');
5138: end if;
5139: END get_transfer_price_date;
5140:
5141: END INV_TRANSACTION_FLOW_PUB;