eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on FND_MSG_PUB

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

46: x_return_status := G_RET_STS_SUCCESS;
47: EXCEPTION
48: WHEN no_data_found THEN
49: x_return_status := G_RET_STS_ERROR;
50: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
51: IF (l_debug = 1) THEN
52: print_debug('GET_ACCT_PERIOD: no_data_found error', 9);
53: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
54: END IF;

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

54: END IF;
55: WHEN OTHERS THEN
56: x_return_status := G_RET_STS_UNEXP_ERROR;
57:
58: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
59: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
60: END IF;
61: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
62: IF (l_debug = 1) THEN

Line 59: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');

55: WHEN OTHERS THEN
56: x_return_status := G_RET_STS_UNEXP_ERROR;
57:
58: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
59: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
60: END IF;
61: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
62: IF (l_debug = 1) THEN
63: print_debug('GET_ACCT_PERIOD: others error', 9);

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

57:
58: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
59: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
60: END IF;
61: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
62: IF (l_debug = 1) THEN
63: print_debug('GET_ACCT_PERIOD: others error', 9);
64: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
65: END IF;

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

262: EXCEPTION
263: WHEN no_data_found THEN
264: x_return_status := G_RET_STS_ERROR;
265:
266: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
267: IF (l_debug = 1) THEN
268: print_debug('GET_DEFAULT_COSTGROUP: No Data Found Error', 9);
269: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
270: END IF;

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

270: END IF;
271: WHEN OTHERS THEN
272: x_return_status := G_RET_STS_UNEXP_ERROR;
273:
274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
276: END IF;
277: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
278: IF (l_debug = 1) THEN

Line 275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');

271: WHEN OTHERS THEN
272: x_return_status := G_RET_STS_UNEXP_ERROR;
273:
274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
276: END IF;
277: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
278: IF (l_debug = 1) THEN
279: print_debug('GET_DEFAULT_COSTGROUP: Others Error', 9);

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

273:
274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
276: END IF;
277: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
278: IF (l_debug = 1) THEN
279: print_debug('GET_DEFAULT_COSTGROUP: Others Error', 9);
280: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
281: END IF;

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

311: x_return_status := G_RET_STS_SUCCESS;
312: EXCEPTION
313: WHEN no_data_found THEN
314: x_return_status := G_RET_STS_ERROR;
315: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
316: IF (l_debug = 1) THEN
317: print_debug('GET_PROJECT_COSTGROUP: No Data Found Error', 9);
318: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
319: END IF;

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

319: END IF;
320: WHEN OTHERS THEN
321: x_return_status := G_RET_STS_UNEXP_ERROR;
322:
323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
324: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
325: END IF;
326: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
327: IF (l_debug = 1) THEN

Line 324: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');

320: WHEN OTHERS THEN
321: x_return_status := G_RET_STS_UNEXP_ERROR;
322:
323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
324: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
325: END IF;
326: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
327: IF (l_debug = 1) THEN
328: print_debug('GET_PROJECT_COSTGROUP: Others Error', 9);

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

322:
323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
324: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
325: END IF;
326: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
327: IF (l_debug = 1) THEN
328: print_debug('GET_PROJECT_COSTGROUP: Others Error', 9);
329: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
330: END IF;

Line 498: FND_MSG_PUB.ADD;

494: print_debug('get_default_costgroup returns error', 9);
495: print_debug('l_msg_data = ' || l_msg_data, 9);
496: END IF;
497: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
498: FND_MSG_PUB.ADD;
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:
502:

Line 687: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);

683:
684: EXCEPTION
685: WHEN no_data_found THEN
686: x_return_status := G_RET_STS_ERROR;
687: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
688: IF (l_debug = 1) THEN
689: print_debug('create_exp_req_rcpt_trx: no_data_found error', 9);
690: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
691: END IF;

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

691: END IF;
692: WHEN OTHERS THEN
693: x_return_status := G_RET_STS_UNEXP_ERROR;
694:
695: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
696: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'create_logical_exp_req_rcpt_trx');
697: END IF;
698: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
699: IF (l_debug = 1) THEN

Line 696: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'create_logical_exp_req_rcpt_trx');

692: WHEN OTHERS THEN
693: x_return_status := G_RET_STS_UNEXP_ERROR;
694:
695: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
696: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'create_logical_exp_req_rcpt_trx');
697: END IF;
698: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
699: IF (l_debug = 1) THEN
700: print_debug('create_exp_req_rcpt_trx: others error', 9);

Line 698: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);

694:
695: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
696: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'create_logical_exp_req_rcpt_trx');
697: END IF;
698: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
699: IF (l_debug = 1) THEN
700: print_debug('create_exp_req_rcpt_trx: others error', 9);
701: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
702: END IF;

Line 797: fnd_msg_pub.initialize;

793: END IF;
794:
795: -- Initialize message list.
796: IF fnd_api.to_boolean(l_init_msg_lst) THEN
797: fnd_msg_pub.initialize;
798: END IF;
799:
800:
801: -- Determine if it's sales order shipment transaction or Logical PO receipt transaction

Line 897: FND_MSG_PUB.ADD;

893: IF (l_debug = 1) THEN
894: print_debug('Cannot find the selling and shipping OU of the sales order', 9);
895: END IF;
896: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OU');
897: FND_MSG_PUB.ADD;
898: RAISE FND_API.G_EXC_ERROR;
899: END;
900:
901: -- check if the selling OU is not the same as the shipping OU, the

Line 1054: FND_MSG_PUB.ADD;

1050: IF (l_debug = 1) THEN
1051: print_debug('Costing Release Level < Costing J Release Level', 9);
1052: END IF;
1053: FND_MESSAGE.SET_NAME('INV', 'INV_CST_JRELEASE');
1054: FND_MSG_PUB.ADD;
1055: RAISE FND_API.G_EXC_ERROR;
1056: ELSIF (OE_CODE_CONTROL.Get_Code_Release_Level < '110510') THEN
1057: IF (l_debug = 1) THEN
1058: print_debug('OM Release Level < 110510', 9);

Line 1061: FND_MSG_PUB.ADD;

1057: IF (l_debug = 1) THEN
1058: print_debug('OM Release Level < 110510', 9);
1059: END IF;
1060: FND_MESSAGE.SET_NAME('INV', 'INV_OM_JRELEASE');
1061: FND_MSG_PUB.ADD;
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;
1064:
1065: IF (l_debug = 1) THEN

Line 1188: FND_MSG_PUB.ADD;

1184: IF (l_debug = 1) THEN
1185: print_debug('Error when creating logical trx table', 9);
1186: END IF;
1187: FND_MESSAGE.SET_NAME('INV', 'INV_LOG_TRX_REC_ERROR');
1188: FND_MSG_PUB.ADD;
1189: RAISE FND_API.G_EXC_ERROR ;
1190: END;
1191:
1192: --bug fix - the defer flag should be set only if it is being

Line 1249: FND_MSG_PUB.ADD;

1245: print_debug('No MMT record is found for defcogsupdate with trx id:'
1246: || p_transaction_id ,9);
1247: END IF;
1248: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
1249: FND_MSG_PUB.ADD;
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252: ELSIF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND
1253: AND l_new_accounting_flag = 'N') THEN

Line 1270: FND_MSG_PUB.ADD;

1266: print_debug('No MMT record is found for update with trx id:'
1267: || p_transaction_id ,9);
1268: END IF;
1269: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
1270: FND_MSG_PUB.ADD;
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273:
1274: END IF;--end of (l_transaction_flow_exists = 1 AND l_new_accounting_flag = 'Y')

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

1280: print_debug('create_logical_trx_wrapper error exception, l_progress = '
1281: || l_progress, 9);
1282: END IF;
1283: x_return_status := FND_API.G_RET_STS_ERROR;
1284: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1285:
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: IF (l_debug = 1) THEN
1288: print_debug('create_logical_trx_wrapper unexpected error exception,l_progress = ' || l_progress, 9);

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

1287: IF (l_debug = 1) THEN
1288: print_debug('create_logical_trx_wrapper unexpected error exception,l_progress = ' || l_progress, 9);
1289: END IF;
1290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1292:
1293: WHEN OTHERS THEN
1294: IF (l_debug = 1) THEN
1295: print_debug('create_logical_trx_wrapper other exception, l_progress = ' || l_progress || ' ' || substr(sqlerrm, 1, 100), 9);

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

1294: IF (l_debug = 1) THEN
1295: print_debug('create_logical_trx_wrapper other exception, l_progress = ' || l_progress || ' ' || substr(sqlerrm, 1, 100), 9);
1296: END IF;
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1299:
1300: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1301: FND_MSG_PUB.Add_Exc_Msg
1302: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');

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

1296: END IF;
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1299:
1300: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1301: FND_MSG_PUB.Add_Exc_Msg
1302: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
1303: END IF;
1304: END create_logical_trx_wrapper;

Line 1301: FND_MSG_PUB.Add_Exc_Msg

1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1299:
1300: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1301: FND_MSG_PUB.Add_Exc_Msg
1302: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
1303: END IF;
1304: END create_logical_trx_wrapper;
1305:

Line 1484: fnd_msg_pub.initialize;

1480: END IF;
1481:
1482: -- Initialize message list.
1483: IF fnd_api.to_boolean(l_init_msg_lst) THEN
1484: fnd_msg_pub.initialize;
1485: END IF;
1486:
1487:
1488: l_progress := 10;

Line 1514: FND_MSG_PUB.ADD;

1510: IF (l_debug = 1) THEN
1511: print_debug('Cannot get defer logical trx flag from mtl_parameters', 9);
1512: END IF;
1513: FND_MESSAGE.SET_NAME('INV', 'INV_DEFER_LOGICAL_ERR');
1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;
1516: END;
1517: END IF;
1518:

Line 1551: FND_MSG_PUB.ADD;

1547: || l_mtl_trx_tbl(i).organization_id, 9);
1548: print_debug('x_msg_data = ' || x_msg_data, 9);
1549: END IF;
1550: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
1551: FND_MSG_PUB.ADD;
1552: RAISE FND_API.G_EXC_ERROR;
1553: END IF;
1554: END IF;
1555:

Line 1609: FND_MSG_PUB.ADD;

1605: print_debug('get_default_costgroup returns error', 9);
1606: print_debug('l_msg_data = ' || l_msg_data, 9);
1607: END IF;
1608: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
1609: FND_MSG_PUB.ADD;
1610: RAISE FND_API.G_EXC_ERROR;
1611: END IF;
1612:
1613: l_mtl_trx_tbl(i).costed_flag := 'N';

Line 1644: FND_MSG_PUB.ADD;

1640: IF (l_debug = 1) THEN
1641: print_debug('Records are not exploded', 9);
1642: END IF;
1643: FND_MESSAGE.SET_NAME('INV', 'INV_REC_NOT_EXPLODED');
1644: FND_MSG_PUB.ADD;
1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647:
1648: IF (l_debug = 1) THEN

Line 1700: FND_MSG_PUB.ADD;

1696: || l_mtl_trx_tbl(1).organization_id, 9);
1697: print_debug('x_msg_data = ' || x_msg_data, 9);
1698: END IF;
1699: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: END IF;
1703: END IF;
1704:

Line 1766: FND_MSG_PUB.ADD;

1762: print_debug('get_default_costgroup returns error', 9);
1763: print_debug('l_msg_data = ' || l_msg_data, 9);
1764: END IF;
1765: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
1766: FND_MSG_PUB.ADD;
1767: RAISE FND_API.G_EXC_ERROR;
1768: END IF;
1769: END IF;
1770:

Line 1788: FND_MSG_PUB.ADD;

1784: print_debug('get_default_costgroup returns error', 9);
1785: print_debug('l_msg_data = ' || l_msg_data, 9);
1786: END IF;
1787: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
1788: FND_MSG_PUB.ADD;
1789: RAISE FND_API.G_EXC_ERROR;
1790: END IF;
1791: END IF;
1792: END IF;

Line 1813: FND_MSG_PUB.ADD;

1809: END IF;
1810:
1811: x_return_status := FND_API.G_RET_STS_ERROR;
1812: FND_MESSAGE.SET_NAME('INV', 'INV_CANNOT_DEFER_LOGICAL_TRX');
1813: FND_MSG_PUB.ADD;
1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF; -- end of if (l_defer_logical_trx = G_NOT_DEFER_LOGICAL_TRX)
1816: -- true dropship(shipping flow)/SO issue across OUs/RMA return
1817: ELSIF (p_logical_trx_type_code = G_LOGTRXCODE_DSDELIVER

Line 1828: FND_MSG_PUB.ADD;

1824: END IF;
1825:
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: FND_MESSAGE.SET_NAME('INV', 'INV_CANNOT_DEFER_LOGICAL_TRX');
1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_ERROR;
1830: ELSIF (p_logical_trx_type_code = G_LOGTRXCODE_RMASOISSUE
1831: and l_defer_logical_trx = G_DEFER_LOGICAL_TRX) THEN
1832: -- If sales order issue/RMA and yes defer flag, update the MMT record

Line 1851: FND_MSG_PUB.ADD;

1847: IF (l_debug = 1) THEN
1848: print_debug('No MMT record is found to update with logical_transactions_created=N', 9);
1849: END IF;
1850: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
1851: FND_MSG_PUB.ADD;
1852: RAISE FND_API.G_EXC_ERROR;
1853: END IF;
1854: return;
1855: END IF;

Line 1886: FND_MSG_PUB.ADD;

1882: IF (l_debug = 1) THEN
1883: print_debug('Transaction flow not defined for header_id = ' || p_trx_flow_header_id, 9);
1884: END IF;
1885: FND_MESSAGE.SET_NAME('INV', 'INV_NO_TRX_FLOW');
1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: END;
1889:
1890: -- For dropship deliver, get the sales order id and populate to transaction_source_id

Line 1970: FND_MSG_PUB.ADD;

1966: IF (l_debug = 1) THEN
1967: print_debug('no sales order found for line id = ' || l_mtl_trx_tbl(1).trx_source_line_id, 9);
1968: END IF;
1969: FND_MESSAGE.SET_NAME('INV', 'INV_NO_SO');
1970: FND_MSG_PUB.ADD;
1971: RAISE FND_API.G_EXC_ERROR;
1972:
1973: WHEN others THEN
1974: IF (l_debug = 1) THEN

Line 1979: FND_MSG_PUB.ADD;

1975: print_debug('when others ' || sqlerrm, 9);
1976: print_Debug('l_progress = ' || l_progress, 9);
1977: END IF;
1978: FND_MESSAGE.SET_NAME('INV', 'INV_NO_SO');
1979: FND_MSG_PUB.ADD;
1980: RAISE FND_API.G_EXC_ERROR;
1981: END;
1982:
1983: IF (l_debug = 1) THEN

Line 2065: FND_MSG_PUB.ADD;

2061: print_debug('get_default_costgroup returns error', 9);
2062: print_debug('l_msg_data = ' || l_msg_data, 9);
2063: END IF;
2064: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
2065: FND_MSG_PUB.ADD;
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:
2069: IF (l_mtl_trx_tbl(1).acct_period_id IS NULL) THEN

Line 2084: FND_MSG_PUB.ADD;

2080: || l_mtl_trx_tbl(1).organization_id, 9);
2081: print_debug('x_msg_data = ' || x_msg_data, 9);
2082: END IF;
2083: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
2084: FND_MSG_PUB.ADD;
2085: RAISE FND_API.G_EXC_ERROR;
2086: END IF;
2087: END IF;
2088:

Line 2134: FND_MSG_PUB.ADD;

2130: print_debug('get_default_costgroup returns error', 9);
2131: print_debug('l_msg_data = ' || l_msg_data, 9);
2132: END IF;
2133: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
2134: FND_MSG_PUB.ADD;
2135: RAISE FND_API.G_EXC_ERROR;
2136: END IF;
2137: END IF;
2138:

Line 2171: FND_MSG_PUB.ADD;

2167: print_debug('get_cogs_acct_for_logical_so returns error', 9);
2168: print_debug('l_msg_data = ' || l_msg_data, 9);
2169: END IF;
2170: FND_MESSAGE.SET_NAME('INV', 'INV_NO_COGS_FOR_LOG_SO');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;
2174:
2175: l_progress := 300;

Line 2330: FND_MSG_PUB.ADD;

2326: print_debug('No item is found for item id: '
2327: || l_mtl_trx_tbl(1).inventory_item_id, 9);
2328: END IF;
2329: FND_MESSAGE.SET_NAME('INV', 'INV_NO_ITEM_FOUND');
2330: FND_MSG_PUB.ADD;
2331: RAISE FND_API.G_EXC_ERROR;
2332: END;
2333:
2334: -- loop for each record of transaction flow table and construct the logical

Line 2440: FND_MSG_PUB.ADD;

2436: || l_mtl_trx_tbl(1).organization_id, 9);
2437: print_debug('x_msg_data = ' || x_msg_data, 9);
2438: END IF;
2439: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
2440: FND_MSG_PUB.ADD;
2441: RAISE FND_API.G_EXC_ERROR;
2442: END IF;
2443:
2444: IF (l_inv_asset_flag = 'Y') THEN

Line 2469: FND_MSG_PUB.ADD;

2465: EXCEPTION
2466: WHEN NO_DATA_FOUND THEN
2467: print_debug('Item not found for item id: '|| l_mtl_trx_tbl(1).inventory_item_id, 9);
2468: FND_MESSAGE.SET_NAME('INV', 'INV_NO_ITEM_FOUND');
2469: FND_MSG_PUB.ADD;
2470: RAISE FND_API.G_EXC_ERROR;
2471: END;
2472:
2473: print_debug('Transaction UOM is: '||p_mtl_trx_tbl(1).transaction_uom, 9);

Line 2631: FND_MSG_PUB.ADD;

2627: || l_mtl_trx_tbl(1).organization_id, 9);
2628: print_debug('x_msg_data = ' || x_msg_data, 9);
2629: END IF;
2630: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
2631: FND_MSG_PUB.ADD;
2632: RAISE FND_API.G_EXC_ERROR;
2633: END IF;
2634:
2635: IF (l_inv_asset_flag = 'Y') THEN

Line 2656: FND_MSG_PUB.ADD;

2652: EXCEPTION
2653: WHEN NO_DATA_FOUND THEN
2654: print_debug('Item not found for item id: '|| l_mtl_trx_tbl(1).inventory_item_id, 9);
2655: FND_MESSAGE.SET_NAME('INV', 'INV_NO_ITEM_FOUND');
2656: FND_MSG_PUB.ADD;
2657: RAISE FND_API.G_EXC_ERROR;
2658: END;
2659: l_uom_rate := 1;
2660:

Line 2767: FND_MSG_PUB.ADD;

2763: print_debug('get_cogs_acct_for_logical_so returns error', 9);
2764: print_debug('l_msg_data = ' || l_msg_data, 9);
2765: END IF;
2766: FND_MESSAGE.SET_NAME('INV', 'INV_NO_COGS_FOR_LOG_SO');
2767: FND_MSG_PUB.ADD;
2768: RAISE FND_API.G_EXC_ERROR;
2769: END IF;
2770:
2771: l_mtl_trx_tbl(l_index).currency_code := null;

Line 2926: FND_MSG_PUB.ADD;

2922: IF (l_debug = 1) THEN
2923: print_debug('Transaction type not found', 9);
2924: END IF;
2925: FND_MESSAGE.SET_NAME('INV', 'INV_TRX_TYPE_ERROR');
2926: FND_MSG_PUB.ADD;
2927: RAISE FND_API.G_EXC_ERROR;
2928: END;
2929: ELSE
2930: IF (l_debug = 1) THEN

Line 2934: FND_MSG_PUB.ADD;

2930: IF (l_debug = 1) THEN
2931: print_debug('Trx action id, trx source type id or trx type is invalid', 9);
2932: END IF;
2933: FND_MESSAGE.SET_NAME('INV', 'INV_TRX_TYPE_ERROR');
2934: FND_MSG_PUB.ADD;
2935: RAISE FND_API.G_EXC_ERROR;
2936: END IF;
2937: END IF;
2938: END LOOP;

Line 3050: FND_MSG_PUB.ADD;

3046: print_debug('No wms_license_plate_number record is found for update with lpn_id'
3047: || l_mtl_trx_tbl(1).lpn_id ,9);
3048: END IF;
3049: FND_MESSAGE.SET_NAME('INV', 'INV_LPN_UPDATE_FAILURE');
3050: FND_MSG_PUB.ADD;
3051: RAISE FND_API.G_EXC_ERROR;
3052: END IF;
3053: ******/
3054: --Calling wms_container_pvt.Modify_LPN API to update the

Line 3078: FND_MSG_PUB.ADD;

3074: print_debug('Error from modify LPN API', 9);
3075: print_debug('l_msg_data = ' || l_msg_data, 9);
3076: END IF;
3077: FND_MESSAGE.SET_NAME('INV', 'INV_LPN_UPDATE_FAILURE');
3078: FND_MSG_PUB.ADD;
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081: END IF;
3082: END IF;

Line 3144: FND_MSG_PUB.ADD;

3140: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);
3141: print_debug('l_row_id = ' || l_row_id, 9);
3142: END IF;
3143: FND_MESSAGE.SET_NAME('INV', 'INV_INSERT_COST_ERR');
3144: FND_MSG_PUB.ADD;
3145: RAISE FND_API.G_EXC_ERROR;
3146: END IF;
3147: ELSE
3148: IF (l_debug = 1)

Line 3184: FND_MSG_PUB.ADD;

3180: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);
3181: print_debug('l_row_id = ' || l_row_id, 9);
3182: END IF;
3183: FND_MESSAGE.SET_NAME('INV', 'INV_INSERT_COST_ERR');
3184: FND_MSG_PUB.ADD;
3185: RAISE FND_API.G_EXC_ERROR;
3186: ELSE
3187: IF (l_debug = 1) THEN
3188: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns success', 9);

Line 3216: FND_MSG_PUB.ADD;

3212: IF (l_debug = 1) THEN
3213: print_debug('OE_DS_PVT.DropShipReceive returns false', 9);
3214: END IF;
3215: FND_MESSAGE.SET_NAME('INV', 'INV_DS_UPDATE_ERROR');
3216: FND_MSG_PUB.ADD;
3217: RAISE FND_API.G_EXC_ERROR;
3218: ELSE
3219: IF (l_debug = 1) THEN
3220: print_debug('OE_DS_PVT.DropShipReceive returns true', 9);

Line 3248: FND_MSG_PUB.ADD;

3244: print_debug('No MMT record is found for update with trx id:'
3245: || p_mtl_trx_tbl(1).transaction_id ,9);
3246: END IF;
3247: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
3248: FND_MSG_PUB.ADD;
3249: RAISE FND_API.G_EXC_ERROR;
3250: END IF;
3251:
3252: -- Call INV_TXNSTUB_PUB.postTransaction only for logical PO receipt record

Line 3307: FND_MSG_PUB.ADD;

3303: print_debug('No MMT record is found for update with trx id:'
3304: || p_mtl_trx_tbl(1).transaction_id ,9);
3305: END IF;
3306: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
3307: FND_MSG_PUB.ADD;
3308: RAISE FND_API.G_EXC_ERROR;
3309: END IF;
3310: END IF;
3311:

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

3366: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3367: print_debug('Return Status :' || x_return_status, 9);
3368: END IF;
3369:
3370: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3371:
3372:
3373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3379: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3380: print_debug('Return Status :' || x_return_status, 9);
3381: END IF;
3382:
3383: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3384:
3385: WHEN OTHERS THEN
3386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3387: ROLLBACK TO create_logical_transactions;

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

3391: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3392: print_debug('Return Status :' || x_return_status, 9);
3393: END IF;
3394:
3395: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3396:
3397: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3398: FND_MSG_PUB.Add_Exc_Msg
3399: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');

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

3393: END IF;
3394:
3395: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3396:
3397: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3398: FND_MSG_PUB.Add_Exc_Msg
3399: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3400: END IF;
3401: END create_logical_transactions;

Line 3398: FND_MSG_PUB.Add_Exc_Msg

3394:
3395: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3396:
3397: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3398: FND_MSG_PUB.Add_Exc_Msg
3399: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3400: END IF;
3401: END create_logical_transactions;
3402:

Line 3636: fnd_msg_pub.initialize;

3632: END IF;
3633:
3634: -- Initialize message list.
3635: IF fnd_api.to_boolean(l_init_msg_lst) THEN
3636: fnd_msg_pub.initialize;
3637: END IF;
3638:
3639: IF (l_debug = 1) THEN
3640: print_debug('After calling init API', 9);

Line 3821: FND_MSG_PUB.count_and_get

3817: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3818: print_debug('Return Status :' || x_return_status, 9);
3819: END IF;
3820:
3821: FND_MSG_PUB.count_and_get
3822: (p_count => x_msg_count, p_data => x_msg_data);
3823:
3824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3833: FND_MSG_PUB.count_and_get

3829: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3830: print_debug('Return Status :' || x_return_status, 9);
3831: END IF;
3832:
3833: FND_MSG_PUB.count_and_get
3834: (p_count => x_msg_count, p_data => x_msg_data);
3835:
3836: WHEN OTHERS THEN
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3845: FND_MSG_PUB.count_and_get

3841: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3842: print_debug('Return Status :' || x_return_status, 9);
3843: END IF;
3844:
3845: FND_MSG_PUB.count_and_get
3846: (p_count => x_msg_count, p_data => x_msg_data);
3847:
3848: IF FND_MSG_PUB.check_msg_level
3849: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3848: IF FND_MSG_PUB.check_msg_level

3844:
3845: FND_MSG_PUB.count_and_get
3846: (p_count => x_msg_count, p_data => x_msg_data);
3847:
3848: IF FND_MSG_PUB.check_msg_level
3849: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3850: FND_MSG_PUB.Add_Exc_Msg
3851: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3852: END IF;

Line 3849: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3845: FND_MSG_PUB.count_and_get
3846: (p_count => x_msg_count, p_data => x_msg_data);
3847:
3848: IF FND_MSG_PUB.check_msg_level
3849: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3850: FND_MSG_PUB.Add_Exc_Msg
3851: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3852: END IF;
3853:

Line 3850: FND_MSG_PUB.Add_Exc_Msg

3846: (p_count => x_msg_count, p_data => x_msg_data);
3847:
3848: IF FND_MSG_PUB.check_msg_level
3849: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3850: FND_MSG_PUB.Add_Exc_Msg
3851: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3852: END IF;
3853:
3854: END CHECK_ACCOUNTING_PERIOD_CLOSE;

Line 4281: fnd_msg_pub.initialize;

4277:
4278: -- Initialize message list.
4279: IF fnd_api.to_boolean(l_init_msg_lst)
4280: THEN
4281: fnd_msg_pub.initialize;
4282: END IF;
4283:
4284:
4285: l_stmt_num := 10;

Line 5104: FND_MSG_PUB.ADD;

5100: print_debug(l_procedure_name || 'get_default_costgroup returns error', 9);
5101: print_debug(l_procedure_name || 'l_msg_data = ' || l_msg_data, 9);
5102: END IF;
5103: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
5104: FND_MSG_PUB.ADD;
5105: RAISE FND_API.G_EXC_ERROR;
5106: END IF;
5107: */
5108: EXCEPTION

Line 5112: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);

5108: EXCEPTION
5109: WHEN no_data_found
5110: THEN
5111: x_return_status := G_RET_STS_ERROR;
5112: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
5113:
5114: IF (l_debug = 1)
5115: THEN
5116: print_debug(l_procedure_name || ' (' || l_stmt_num ||'): no_data_found error', 9);

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

5120: WHEN OTHERS
5121: THEN
5122: x_return_status := G_RET_STS_UNEXP_ERROR;
5123:
5124: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5125: THEN
5126: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_procedure_name);
5127: END IF;
5128:

Line 5126: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_procedure_name);

5122: x_return_status := G_RET_STS_UNEXP_ERROR;
5123:
5124: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5125: THEN
5126: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_procedure_name);
5127: END IF;
5128:
5129: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
5130: IF (l_debug = 1)

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

5125: THEN
5126: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_procedure_name);
5127: END IF;
5128:
5129: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
5130: IF (l_debug = 1)
5131: THEN
5132: print_debug(l_procedure_name || ' (' || l_stmt_num ||'): others error', 9);
5133: print_debug(l_procedure_name || 'SQL Error ' || '(' || l_stmt_num || '): ' || Sqlerrm(SQLCODE), 9);