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 66: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

62: x_return_status := G_RET_STS_SUCCESS;
63: EXCEPTION
64: WHEN no_data_found THEN
65: x_return_status := G_RET_STS_ERROR;
66: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
67: IF (l_debug = 1) THEN
68: print_debug('GET_ACCT_PERIOD: no_data_found error', 9);
69: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
70: END IF;

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

70: END IF;
71: WHEN OTHERS THEN
72: x_return_status := G_RET_STS_UNEXP_ERROR;
73:
74: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
75: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
76: END IF;
77: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
78: IF (l_debug = 1) THEN

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

71: WHEN OTHERS THEN
72: x_return_status := G_RET_STS_UNEXP_ERROR;
73:
74: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
75: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
76: END IF;
77: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
78: IF (l_debug = 1) THEN
79: print_debug('GET_ACCT_PERIOD: others error', 9);

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

73:
74: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
75: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
76: END IF;
77: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
78: IF (l_debug = 1) THEN
79: print_debug('GET_ACCT_PERIOD: others error', 9);
80: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
81: END IF;

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

278: EXCEPTION
279: WHEN no_data_found THEN
280: x_return_status := G_RET_STS_ERROR;
281:
282: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
283: IF (l_debug = 1) THEN
284: print_debug('GET_DEFAULT_COSTGROUP: No Data Found Error', 9);
285: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
286: END IF;

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

286: END IF;
287: WHEN OTHERS THEN
288: x_return_status := G_RET_STS_UNEXP_ERROR;
289:
290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
292: END IF;
293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
294: IF (l_debug = 1) THEN

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

287: WHEN OTHERS THEN
288: x_return_status := G_RET_STS_UNEXP_ERROR;
289:
290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
292: END IF;
293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
294: IF (l_debug = 1) THEN
295: print_debug('GET_DEFAULT_COSTGROUP: Others Error', 9);

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

289:
290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
292: END IF;
293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
294: IF (l_debug = 1) THEN
295: print_debug('GET_DEFAULT_COSTGROUP: Others Error', 9);
296: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
297: END IF;

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

327: x_return_status := G_RET_STS_SUCCESS;
328: EXCEPTION
329: WHEN no_data_found THEN
330: x_return_status := G_RET_STS_ERROR;
331: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
332: IF (l_debug = 1) THEN
333: print_debug('GET_PROJECT_COSTGROUP: No Data Found Error', 9);
334: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
335: END IF;

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

335: END IF;
336: WHEN OTHERS THEN
337: x_return_status := G_RET_STS_UNEXP_ERROR;
338:
339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
340: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
341: END IF;
342: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
343: IF (l_debug = 1) THEN

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

336: WHEN OTHERS THEN
337: x_return_status := G_RET_STS_UNEXP_ERROR;
338:
339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
340: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
341: END IF;
342: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
343: IF (l_debug = 1) THEN
344: print_debug('GET_PROJECT_COSTGROUP: Others Error', 9);

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

338:
339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
340: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_acct_period');
341: END IF;
342: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
343: IF (l_debug = 1) THEN
344: print_debug('GET_PROJECT_COSTGROUP: Others Error', 9);
345: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
346: END IF;

Line 514: FND_MSG_PUB.ADD;

510: print_debug('get_default_costgroup returns error', 9);
511: print_debug('l_msg_data = ' || l_msg_data, 9);
512: END IF;
513: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
514: FND_MSG_PUB.ADD;
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:
518:

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

699:
700: EXCEPTION
701: WHEN no_data_found THEN
702: x_return_status := G_RET_STS_ERROR;
703: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
704: IF (l_debug = 1) THEN
705: print_debug('create_exp_req_rcpt_trx: no_data_found error', 9);
706: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
707: END IF;

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

707: END IF;
708: WHEN OTHERS THEN
709: x_return_status := G_RET_STS_UNEXP_ERROR;
710:
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'create_logical_exp_req_rcpt_trx');
713: END IF;
714: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
715: IF (l_debug = 1) THEN

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

708: WHEN OTHERS THEN
709: x_return_status := G_RET_STS_UNEXP_ERROR;
710:
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'create_logical_exp_req_rcpt_trx');
713: END IF;
714: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
715: IF (l_debug = 1) THEN
716: print_debug('create_exp_req_rcpt_trx: others error', 9);

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

710:
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'create_logical_exp_req_rcpt_trx');
713: END IF;
714: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
715: IF (l_debug = 1) THEN
716: print_debug('create_exp_req_rcpt_trx: others error', 9);
717: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
718: END IF;

Line 813: fnd_msg_pub.initialize;

809: END IF;
810:
811: -- Initialize message list.
812: IF fnd_api.to_boolean(l_init_msg_lst) THEN
813: fnd_msg_pub.initialize;
814: END IF;
815:
816:
817: -- Determine if it's sales order shipment transaction or Logical PO receipt transaction

Line 913: FND_MSG_PUB.ADD;

909: IF (l_debug = 1) THEN
910: print_debug('Cannot find the selling and shipping OU of the sales order', 9);
911: END IF;
912: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OU');
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_ERROR;
915: END;
916:
917: -- check if the selling OU is not the same as the shipping OU, the

Line 1070: FND_MSG_PUB.ADD;

1066: IF (l_debug = 1) THEN
1067: print_debug('Costing Release Level < Costing J Release Level', 9);
1068: END IF;
1069: FND_MESSAGE.SET_NAME('INV', 'INV_CST_JRELEASE');
1070: FND_MSG_PUB.ADD;
1071: RAISE FND_API.G_EXC_ERROR;
1072: ELSIF (OE_CODE_CONTROL.Get_Code_Release_Level < '110510') THEN
1073: IF (l_debug = 1) THEN
1074: print_debug('OM Release Level < 110510', 9);

Line 1077: FND_MSG_PUB.ADD;

1073: IF (l_debug = 1) THEN
1074: print_debug('OM Release Level < 110510', 9);
1075: END IF;
1076: FND_MESSAGE.SET_NAME('INV', 'INV_OM_JRELEASE');
1077: FND_MSG_PUB.ADD;
1078: RAISE FND_API.G_EXC_ERROR;
1079: END IF;
1080:
1081: IF (l_debug = 1) THEN

Line 1204: FND_MSG_PUB.ADD;

1200: IF (l_debug = 1) THEN
1201: print_debug('Error when creating logical trx table', 9);
1202: END IF;
1203: FND_MESSAGE.SET_NAME('INV', 'INV_LOG_TRX_REC_ERROR');
1204: FND_MSG_PUB.ADD;
1205: RAISE FND_API.G_EXC_ERROR ;
1206: END;
1207:
1208: --bug fix - the defer flag should be set only if it is being

Line 1265: FND_MSG_PUB.ADD;

1261: print_debug('No MMT record is found for defcogsupdate with trx id:'
1262: || p_transaction_id ,9);
1263: END IF;
1264: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
1265: FND_MSG_PUB.ADD;
1266: RAISE FND_API.G_EXC_ERROR;
1267: END IF;
1268: ELSIF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND
1269: AND l_new_accounting_flag = 'N') THEN

Line 1286: FND_MSG_PUB.ADD;

1282: print_debug('No MMT record is found for update with trx id:'
1283: || p_transaction_id ,9);
1284: END IF;
1285: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
1286: FND_MSG_PUB.ADD;
1287: RAISE FND_API.G_EXC_ERROR;
1288: END IF;
1289:
1290: END IF;--end of (l_transaction_flow_exists = 1 AND l_new_accounting_flag = 'Y')

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

1296: print_debug('create_logical_trx_wrapper error exception, l_progress = '
1297: || l_progress, 9);
1298: END IF;
1299: x_return_status := FND_API.G_RET_STS_ERROR;
1300: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1301:
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1303: IF (l_debug = 1) THEN
1304: print_debug('create_logical_trx_wrapper unexpected error exception,l_progress = ' || l_progress, 9);

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

1303: IF (l_debug = 1) THEN
1304: print_debug('create_logical_trx_wrapper unexpected error exception,l_progress = ' || l_progress, 9);
1305: END IF;
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1308:
1309: WHEN OTHERS THEN
1310: IF (l_debug = 1) THEN
1311: print_debug('create_logical_trx_wrapper other exception, l_progress = ' || l_progress || ' ' || substr(sqlerrm, 1, 100), 9);

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

1310: IF (l_debug = 1) THEN
1311: print_debug('create_logical_trx_wrapper other exception, l_progress = ' || l_progress || ' ' || substr(sqlerrm, 1, 100), 9);
1312: END IF;
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1315:
1316: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1317: FND_MSG_PUB.Add_Exc_Msg
1318: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');

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

1312: END IF;
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1315:
1316: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1317: FND_MSG_PUB.Add_Exc_Msg
1318: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
1319: END IF;
1320: END create_logical_trx_wrapper;

Line 1317: FND_MSG_PUB.Add_Exc_Msg

1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1315:
1316: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1317: FND_MSG_PUB.Add_Exc_Msg
1318: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
1319: END IF;
1320: END create_logical_trx_wrapper;
1321:

Line 1501: fnd_msg_pub.initialize;

1497: END IF;
1498:
1499: -- Initialize message list.
1500: IF fnd_api.to_boolean(l_init_msg_lst) THEN
1501: fnd_msg_pub.initialize;
1502: END IF;
1503:
1504:
1505: l_progress := 10;

Line 1531: FND_MSG_PUB.ADD;

1527: IF (l_debug = 1) THEN
1528: print_debug('Cannot get defer logical trx flag from mtl_parameters', 9);
1529: END IF;
1530: FND_MESSAGE.SET_NAME('INV', 'INV_DEFER_LOGICAL_ERR');
1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;
1533: END;
1534: END IF;
1535:

Line 1568: FND_MSG_PUB.ADD;

1564: || l_mtl_trx_tbl(i).organization_id, 9);
1565: print_debug('x_msg_data = ' || x_msg_data, 9);
1566: END IF;
1567: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
1568: FND_MSG_PUB.ADD;
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;
1571: END IF;
1572:

Line 1626: FND_MSG_PUB.ADD;

1622: print_debug('get_default_costgroup returns error', 9);
1623: print_debug('l_msg_data = ' || l_msg_data, 9);
1624: END IF;
1625: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
1626: FND_MSG_PUB.ADD;
1627: RAISE FND_API.G_EXC_ERROR;
1628: END IF;
1629:
1630: l_mtl_trx_tbl(i).costed_flag := 'N';

Line 1661: FND_MSG_PUB.ADD;

1657: IF (l_debug = 1) THEN
1658: print_debug('Records are not exploded', 9);
1659: END IF;
1660: FND_MESSAGE.SET_NAME('INV', 'INV_REC_NOT_EXPLODED');
1661: FND_MSG_PUB.ADD;
1662: RAISE FND_API.G_EXC_ERROR;
1663: END IF;
1664:
1665: IF (l_debug = 1) THEN

Line 1717: FND_MSG_PUB.ADD;

1713: || l_mtl_trx_tbl(1).organization_id, 9);
1714: print_debug('x_msg_data = ' || x_msg_data, 9);
1715: END IF;
1716: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
1717: FND_MSG_PUB.ADD;
1718: RAISE FND_API.G_EXC_ERROR;
1719: END IF;
1720: END IF;
1721:

Line 1783: FND_MSG_PUB.ADD;

1779: print_debug('get_default_costgroup returns error', 9);
1780: print_debug('l_msg_data = ' || l_msg_data, 9);
1781: END IF;
1782: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
1783: FND_MSG_PUB.ADD;
1784: RAISE FND_API.G_EXC_ERROR;
1785: END IF;
1786: END IF;
1787:

Line 1805: FND_MSG_PUB.ADD;

1801: print_debug('get_default_costgroup returns error', 9);
1802: print_debug('l_msg_data = ' || l_msg_data, 9);
1803: END IF;
1804: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
1805: FND_MSG_PUB.ADD;
1806: RAISE FND_API.G_EXC_ERROR;
1807: END IF;
1808: END IF;
1809: END IF;

Line 1830: FND_MSG_PUB.ADD;

1826: END IF;
1827:
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MESSAGE.SET_NAME('INV', 'INV_CANNOT_DEFER_LOGICAL_TRX');
1830: FND_MSG_PUB.ADD;
1831: RAISE FND_API.G_EXC_ERROR;
1832: END IF; -- end of if (l_defer_logical_trx = G_NOT_DEFER_LOGICAL_TRX)
1833: -- true dropship(shipping flow)/SO issue across OUs/RMA return
1834: ELSIF (p_logical_trx_type_code = G_LOGTRXCODE_DSDELIVER

Line 1845: FND_MSG_PUB.ADD;

1841: END IF;
1842:
1843: x_return_status := FND_API.G_RET_STS_ERROR;
1844: FND_MESSAGE.SET_NAME('INV', 'INV_CANNOT_DEFER_LOGICAL_TRX');
1845: FND_MSG_PUB.ADD;
1846: RAISE FND_API.G_EXC_ERROR;
1847: ELSIF (p_logical_trx_type_code = G_LOGTRXCODE_RMASOISSUE
1848: and l_defer_logical_trx = G_DEFER_LOGICAL_TRX) THEN
1849: -- If sales order issue/RMA and yes defer flag, update the MMT record

Line 1868: FND_MSG_PUB.ADD;

1864: IF (l_debug = 1) THEN
1865: print_debug('No MMT record is found to update with logical_transactions_created=N', 9);
1866: END IF;
1867: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
1868: FND_MSG_PUB.ADD;
1869: RAISE FND_API.G_EXC_ERROR;
1870: END IF;
1871: return;
1872: END IF;

Line 1903: FND_MSG_PUB.ADD;

1899: IF (l_debug = 1) THEN
1900: print_debug('Transaction flow not defined for header_id = ' || p_trx_flow_header_id, 9);
1901: END IF;
1902: FND_MESSAGE.SET_NAME('INV', 'INV_NO_TRX_FLOW');
1903: FND_MSG_PUB.ADD;
1904: RAISE FND_API.G_EXC_ERROR;
1905: END;
1906:
1907: -- For dropship deliver, get the sales order id and populate to transaction_source_id

Line 1987: FND_MSG_PUB.ADD;

1983: IF (l_debug = 1) THEN
1984: print_debug('no sales order found for line id = ' || l_mtl_trx_tbl(1).trx_source_line_id, 9);
1985: END IF;
1986: FND_MESSAGE.SET_NAME('INV', 'INV_NO_SO');
1987: FND_MSG_PUB.ADD;
1988: RAISE FND_API.G_EXC_ERROR;
1989:
1990: WHEN others THEN
1991: IF (l_debug = 1) THEN

Line 1996: FND_MSG_PUB.ADD;

1992: print_debug('when others ' || sqlerrm, 9);
1993: print_Debug('l_progress = ' || l_progress, 9);
1994: END IF;
1995: FND_MESSAGE.SET_NAME('INV', 'INV_NO_SO');
1996: FND_MSG_PUB.ADD;
1997: RAISE FND_API.G_EXC_ERROR;
1998: END;
1999:
2000: IF (l_debug = 1) THEN

Line 2082: FND_MSG_PUB.ADD;

2078: print_debug('get_default_costgroup returns error', 9);
2079: print_debug('l_msg_data = ' || l_msg_data, 9);
2080: END IF;
2081: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
2082: FND_MSG_PUB.ADD;
2083: RAISE FND_API.G_EXC_ERROR;
2084: END IF;
2085:
2086: IF (l_mtl_trx_tbl(1).acct_period_id IS NULL) THEN

Line 2101: FND_MSG_PUB.ADD;

2097: || l_mtl_trx_tbl(1).organization_id, 9);
2098: print_debug('x_msg_data = ' || x_msg_data, 9);
2099: END IF;
2100: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
2101: FND_MSG_PUB.ADD;
2102: RAISE FND_API.G_EXC_ERROR;
2103: END IF;
2104: END IF;
2105:

Line 2151: FND_MSG_PUB.ADD;

2147: print_debug('get_default_costgroup returns error', 9);
2148: print_debug('l_msg_data = ' || l_msg_data, 9);
2149: END IF;
2150: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;
2154: END IF;
2155:

Line 2188: FND_MSG_PUB.ADD;

2184: print_debug('get_cogs_acct_for_logical_so returns error', 9);
2185: print_debug('l_msg_data = ' || l_msg_data, 9);
2186: END IF;
2187: FND_MESSAGE.SET_NAME('INV', 'INV_NO_COGS_FOR_LOG_SO');
2188: FND_MSG_PUB.ADD;
2189: RAISE FND_API.G_EXC_ERROR;
2190: END IF;
2191:
2192: l_progress := 300;

Line 2347: FND_MSG_PUB.ADD;

2343: print_debug('No item is found for item id: '
2344: || l_mtl_trx_tbl(1).inventory_item_id, 9);
2345: END IF;
2346: FND_MESSAGE.SET_NAME('INV', 'INV_NO_ITEM_FOUND');
2347: FND_MSG_PUB.ADD;
2348: RAISE FND_API.G_EXC_ERROR;
2349: END;
2350:
2351: -- loop for each record of transaction flow table and construct the logical

Line 2457: FND_MSG_PUB.ADD;

2453: || l_mtl_trx_tbl(1).organization_id, 9);
2454: print_debug('x_msg_data = ' || x_msg_data, 9);
2455: END IF;
2456: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
2457: FND_MSG_PUB.ADD;
2458: RAISE FND_API.G_EXC_ERROR;
2459: END IF;
2460:
2461: IF (l_inv_asset_flag = 'Y') THEN

Line 2486: FND_MSG_PUB.ADD;

2482: EXCEPTION
2483: WHEN NO_DATA_FOUND THEN
2484: print_debug('Item not found for item id: '|| l_mtl_trx_tbl(1).inventory_item_id, 9);
2485: FND_MESSAGE.SET_NAME('INV', 'INV_NO_ITEM_FOUND');
2486: FND_MSG_PUB.ADD;
2487: RAISE FND_API.G_EXC_ERROR;
2488: END;
2489:
2490: print_debug('Transaction UOM is: '||p_mtl_trx_tbl(1).transaction_uom, 9);

Line 2661: FND_MSG_PUB.ADD;

2657: || l_mtl_trx_tbl(1).organization_id, 9);
2658: print_debug('x_msg_data = ' || x_msg_data, 9);
2659: END IF;
2660: FND_MESSAGE.SET_NAME('INV', 'INV_PERIOD_RETRIEVAL_ERROR');
2661: FND_MSG_PUB.ADD;
2662: RAISE FND_API.G_EXC_ERROR;
2663: END IF;
2664:
2665: IF (l_inv_asset_flag = 'Y') THEN

Line 2686: FND_MSG_PUB.ADD;

2682: EXCEPTION
2683: WHEN NO_DATA_FOUND THEN
2684: print_debug('Item not found for item id: '|| l_mtl_trx_tbl(1).inventory_item_id, 9);
2685: FND_MESSAGE.SET_NAME('INV', 'INV_NO_ITEM_FOUND');
2686: FND_MSG_PUB.ADD;
2687: RAISE FND_API.G_EXC_ERROR;
2688: END;
2689: l_uom_rate := 1;
2690:

Line 2812: FND_MSG_PUB.ADD;

2808: print_debug('get_cogs_acct_for_logical_so returns error', 9);
2809: print_debug('l_msg_data = ' || l_msg_data, 9);
2810: END IF;
2811: FND_MESSAGE.SET_NAME('INV', 'INV_NO_COGS_FOR_LOG_SO');
2812: FND_MSG_PUB.ADD;
2813: RAISE FND_API.G_EXC_ERROR;
2814: END IF;
2815:
2816: l_mtl_trx_tbl(l_index).currency_code := null;

Line 2971: FND_MSG_PUB.ADD;

2967: IF (l_debug = 1) THEN
2968: print_debug('Transaction type not found', 9);
2969: END IF;
2970: FND_MESSAGE.SET_NAME('INV', 'INV_TRX_TYPE_ERROR');
2971: FND_MSG_PUB.ADD;
2972: RAISE FND_API.G_EXC_ERROR;
2973: END;
2974: ELSE
2975: IF (l_debug = 1) THEN

Line 2979: FND_MSG_PUB.ADD;

2975: IF (l_debug = 1) THEN
2976: print_debug('Trx action id, trx source type id or trx type is invalid', 9);
2977: END IF;
2978: FND_MESSAGE.SET_NAME('INV', 'INV_TRX_TYPE_ERROR');
2979: FND_MSG_PUB.ADD;
2980: RAISE FND_API.G_EXC_ERROR;
2981: END IF;
2982: END IF;
2983: END LOOP;

Line 3095: FND_MSG_PUB.ADD;

3091: print_debug('No wms_license_plate_number record is found for update with lpn_id'
3092: || l_mtl_trx_tbl(1).lpn_id ,9);
3093: END IF;
3094: FND_MESSAGE.SET_NAME('INV', 'INV_LPN_UPDATE_FAILURE');
3095: FND_MSG_PUB.ADD;
3096: RAISE FND_API.G_EXC_ERROR;
3097: END IF;
3098: ******/
3099: --Calling wms_container_pvt.Modify_LPN API to update the

Line 3123: FND_MSG_PUB.ADD;

3119: print_debug('Error from modify LPN API', 9);
3120: print_debug('l_msg_data = ' || l_msg_data, 9);
3121: END IF;
3122: FND_MESSAGE.SET_NAME('INV', 'INV_LPN_UPDATE_FAILURE');
3123: FND_MSG_PUB.ADD;
3124: RAISE FND_API.G_EXC_ERROR;
3125: END IF;
3126: END IF;
3127: END IF;

Line 3189: FND_MSG_PUB.ADD;

3185: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);
3186: print_debug('l_row_id = ' || l_row_id, 9);
3187: END IF;
3188: FND_MESSAGE.SET_NAME('INV', 'INV_INSERT_COST_ERR');
3189: FND_MSG_PUB.ADD;
3190: RAISE FND_API.G_EXC_ERROR;
3191: END IF;
3192: ELSE
3193: IF (l_debug = 1)

Line 3237: FND_MSG_PUB.ADD;

3233: print_debug('Error from calling uom_conversion', 9);
3234: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
3235: FND_MESSAGE.SET_TOKEN('VALUE1', l_mtl_trx_tbl(i).transaction_uom);
3236: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);
3237: FND_MSG_PUB.ADD;
3238: RAISE FND_API.G_EXC_ERROR;
3239: END IF;
3240:
3241: print_debug('l_uom_rate = ' || l_uom_rate, 9);

Line 3271: FND_MSG_PUB.ADD;

3267: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);
3268: print_debug('l_row_id = ' || l_row_id, 9);
3269: END IF;
3270: FND_MESSAGE.SET_NAME('INV', 'INV_INSERT_COST_ERR');
3271: FND_MSG_PUB.ADD;
3272: RAISE FND_API.G_EXC_ERROR;
3273: ELSE
3274: IF (l_debug = 1) THEN
3275: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns success', 9);

Line 3303: FND_MSG_PUB.ADD;

3299: IF (l_debug = 1) THEN
3300: print_debug('OE_DS_PVT.DropShipReceive returns false', 9);
3301: END IF;
3302: FND_MESSAGE.SET_NAME('INV', 'INV_DS_UPDATE_ERROR');
3303: FND_MSG_PUB.ADD;
3304: RAISE FND_API.G_EXC_ERROR;
3305: ELSE
3306: IF (l_debug = 1) THEN
3307: print_debug('OE_DS_PVT.DropShipReceive returns true', 9);

Line 3335: FND_MSG_PUB.ADD;

3331: print_debug('No MMT record is found for update with trx id:'
3332: || p_mtl_trx_tbl(1).transaction_id ,9);
3333: END IF;
3334: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
3335: FND_MSG_PUB.ADD;
3336: RAISE FND_API.G_EXC_ERROR;
3337: END IF;
3338:
3339: -- Call INV_TXNSTUB_PUB.postTransaction only for logical PO receipt record

Line 3394: FND_MSG_PUB.ADD;

3390: print_debug('No MMT record is found for update with trx id:'
3391: || p_mtl_trx_tbl(1).transaction_id ,9);
3392: END IF;
3393: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
3394: FND_MSG_PUB.ADD;
3395: RAISE FND_API.G_EXC_ERROR;
3396: END IF;
3397: END IF;
3398:

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

3453: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3454: print_debug('Return Status :' || x_return_status, 9);
3455: END IF;
3456:
3457: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3458:
3459:
3460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3466: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3467: print_debug('Return Status :' || x_return_status, 9);
3468: END IF;
3469:
3470: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3471:
3472: WHEN OTHERS THEN
3473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3474: ROLLBACK TO create_logical_transactions;

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

3478: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3479: print_debug('Return Status :' || x_return_status, 9);
3480: END IF;
3481:
3482: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3483:
3484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3485: FND_MSG_PUB.Add_Exc_Msg
3486: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');

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

3480: END IF;
3481:
3482: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3483:
3484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3485: FND_MSG_PUB.Add_Exc_Msg
3486: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3487: END IF;
3488: END create_logical_transactions;

Line 3485: FND_MSG_PUB.Add_Exc_Msg

3481:
3482: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3483:
3484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3485: FND_MSG_PUB.Add_Exc_Msg
3486: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3487: END IF;
3488: END create_logical_transactions;
3489:

Line 3723: fnd_msg_pub.initialize;

3719: END IF;
3720:
3721: -- Initialize message list.
3722: IF fnd_api.to_boolean(l_init_msg_lst) THEN
3723: fnd_msg_pub.initialize;
3724: END IF;
3725:
3726: IF (l_debug = 1) THEN
3727: print_debug('After calling init API', 9);

Line 3908: FND_MSG_PUB.count_and_get

3904: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3905: print_debug('Return Status :' || x_return_status, 9);
3906: END IF;
3907:
3908: FND_MSG_PUB.count_and_get
3909: (p_count => x_msg_count, p_data => x_msg_data);
3910:
3911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3920: FND_MSG_PUB.count_and_get

3916: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3917: print_debug('Return Status :' || x_return_status, 9);
3918: END IF;
3919:
3920: FND_MSG_PUB.count_and_get
3921: (p_count => x_msg_count, p_data => x_msg_data);
3922:
3923: WHEN OTHERS THEN
3924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3932: FND_MSG_PUB.count_and_get

3928: print_debug('SQL Error: ' || Sqlerrm(SQLCODE),9);
3929: print_debug('Return Status :' || x_return_status, 9);
3930: END IF;
3931:
3932: FND_MSG_PUB.count_and_get
3933: (p_count => x_msg_count, p_data => x_msg_data);
3934:
3935: IF FND_MSG_PUB.check_msg_level
3936: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3935: IF FND_MSG_PUB.check_msg_level

3931:
3932: FND_MSG_PUB.count_and_get
3933: (p_count => x_msg_count, p_data => x_msg_data);
3934:
3935: IF FND_MSG_PUB.check_msg_level
3936: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3937: FND_MSG_PUB.Add_Exc_Msg
3938: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3939: END IF;

Line 3936: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3932: FND_MSG_PUB.count_and_get
3933: (p_count => x_msg_count, p_data => x_msg_data);
3934:
3935: IF FND_MSG_PUB.check_msg_level
3936: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3937: FND_MSG_PUB.Add_Exc_Msg
3938: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3939: END IF;
3940:

Line 3937: FND_MSG_PUB.Add_Exc_Msg

3933: (p_count => x_msg_count, p_data => x_msg_data);
3934:
3935: IF FND_MSG_PUB.check_msg_level
3936: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3937: FND_MSG_PUB.Add_Exc_Msg
3938: (G_PKG_NAME, 'INV_LOGICAL_TRANSACTIONS_PUB');
3939: END IF;
3940:
3941: END CHECK_ACCOUNTING_PERIOD_CLOSE;

Line 4368: fnd_msg_pub.initialize;

4364:
4365: -- Initialize message list.
4366: IF fnd_api.to_boolean(l_init_msg_lst)
4367: THEN
4368: fnd_msg_pub.initialize;
4369: END IF;
4370:
4371:
4372: l_stmt_num := 10;

Line 5192: FND_MSG_PUB.ADD;

5188: print_debug(l_procedure_name || 'get_default_costgroup returns error', 9);
5189: print_debug(l_procedure_name || 'l_msg_data = ' || l_msg_data, 9);
5190: END IF;
5191: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_COST_GROUP');
5192: FND_MSG_PUB.ADD;
5193: RAISE FND_API.G_EXC_ERROR;
5194: END IF;
5195: */
5196: EXCEPTION

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

5196: EXCEPTION
5197: WHEN no_data_found
5198: THEN
5199: x_return_status := G_RET_STS_ERROR;
5200: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
5201:
5202: IF (l_debug = 1)
5203: THEN
5204: print_debug(l_procedure_name || ' (' || l_stmt_num ||'): no_data_found error', 9);

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

5208: WHEN OTHERS
5209: THEN
5210: x_return_status := G_RET_STS_UNEXP_ERROR;
5211:
5212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5213: THEN
5214: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_procedure_name);
5215: END IF;
5216:

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

5210: x_return_status := G_RET_STS_UNEXP_ERROR;
5211:
5212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5213: THEN
5214: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_procedure_name);
5215: END IF;
5216:
5217: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
5218: IF (l_debug = 1)

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

5213: THEN
5214: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_procedure_name);
5215: END IF;
5216:
5217: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => x_msg_data);
5218: IF (l_debug = 1)
5219: THEN
5220: print_debug(l_procedure_name || ' (' || l_stmt_num ||'): others error', 9);
5221: print_debug(l_procedure_name || 'SQL Error ' || '(' || l_stmt_num || '): ' || Sqlerrm(SQLCODE), 9);