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.CN_TRANSACTION_LOAD_PUB dependencies on FND_MSG_PUB

Line 917: debugmsg( FND_MSG_PUB.get(p_msg_index => l_counter,

913: debugmsg('Loader : Load_Workder : Classify : l_msg_data is '
914: || x_msg_data );
915:
916: FOR l_counter IN 1..x_msg_count LOOP
917: debugmsg( FND_MSG_PUB.get(p_msg_index => l_counter,
918: p_encoded => FND_API.G_FALSE));
919: END LOOP;
920:
921: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 950: debugmsg( FND_MSG_PUB.get(p_msg_index => l_counter,

946: || x_msg_data );
947:
948:
949: FOR l_counter IN 1..x_msg_count LOOP
950: debugmsg( FND_MSG_PUB.get(p_msg_index => l_counter,
951: p_encoded => FND_API.G_FALSE));
952: END LOOP;
953:
954: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 969: FND_MSG_PUB.Count_And_Get

965: -- End of API body.
966:
967: -- Standard call to get message count and if count is 1, get message info.
968:
969: FND_MSG_PUB.Count_And_Get
970: (
971: p_count => x_msg_count ,
972: p_data => x_msg_data ,
973: p_encoded => FND_API.G_FALSE

Line 980: FND_MSG_PUB.Count_And_Get

976: EXCEPTION
977: WHEN FND_API.G_EXC_ERROR THEN
978: x_return_status := FND_API.G_RET_STS_ERROR ;
979: debugmsg('Loader : load_worker : Exception : Error msg : ' || x_msg_data);
980: FND_MSG_PUB.Count_And_Get
981: (
982: p_count => x_msg_count ,
983: p_data => x_msg_data ,
984: p_encoded => FND_API.G_FALSE

Line 990: FND_MSG_PUB.Count_And_Get

986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
988: x_loading_status := 'UNEXPECTED_ERR';
989: debugmsg('Loader : load_worker : Exception : Unexpected Error : Error message : ' || x_msg_data);
990: FND_MSG_PUB.Count_And_Get
991: (
992: p_count => x_msg_count ,
993: p_data => x_msg_data ,
994: p_encoded => FND_API.G_FALSE

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

996: WHEN OTHERS THEN
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
998: x_loading_status := 'UNEXPECTED_ERR';
999: debugmsg('Loader : load_worker : Exception Others : Error : Error message : ' || x_msg_data);
1000: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1001: THEN
1002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1003: END IF;
1004: FND_MSG_PUB.Count_And_Get

Line 1002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

998: x_loading_status := 'UNEXPECTED_ERR';
999: debugmsg('Loader : load_worker : Exception Others : Error : Error message : ' || x_msg_data);
1000: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1001: THEN
1002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1003: END IF;
1004: FND_MSG_PUB.Count_And_Get
1005: (
1006: p_count => x_msg_count ,

Line 1004: FND_MSG_PUB.Count_And_Get

1000: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1001: THEN
1002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1003: END IF;
1004: FND_MSG_PUB.Count_And_Get
1005: (
1006: p_count => x_msg_count ,
1007: p_data => x_msg_data ,
1008: p_encoded => FND_API.G_FALSE

Line 1219: FND_MSG_PUB.initialize;

1215: END IF;
1216:
1217: -- Initialize message list if p_init_msg_list is set to TRUE.
1218: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1219: FND_MSG_PUB.initialize;
1220: END IF;
1221:
1222: -- Initialize API return status to success
1223: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1314: and p_start_date between start_date and end_date;
1315: IF (l_count = 0) THEN
1316: debugmsg('Loader : Parameter Start Date is not within an open acc period');
1317:
1318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1319: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
1320: FND_MESSAGE.SET_TOKEN('DATE', p_start_date);
1321: FND_MSG_PUB.Add;
1322: END IF;

Line 1321: FND_MSG_PUB.Add;

1317:
1318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1319: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
1320: FND_MESSAGE.SET_TOKEN('DATE', p_start_date);
1321: FND_MSG_PUB.Add;
1322: END IF;
1323:
1324: x_loading_status := 'CN_CALC_SUB_OPEN_DATE';
1325: RAISE FND_API.G_EXC_ERROR ;

Line 1343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1339: and p_end_date between start_date and end_date;
1340: IF (l_count = 0) THEN
1341: debugmsg('Loader : Parameter End Date is not within an open acc period');
1342:
1343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1344: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
1345: FND_MESSAGE.SET_TOKEN('DATE', p_end_date);
1346: FND_MSG_PUB.Add;
1347: END IF;

Line 1346: FND_MSG_PUB.Add;

1342:
1343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1344: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
1345: FND_MESSAGE.SET_TOKEN('DATE', p_end_date);
1346: FND_MSG_PUB.Add;
1347: END IF;
1348:
1349: x_loading_status := 'CN_CALC_SUB_OPEN_DATE';
1350: RAISE FND_API.G_EXC_ERROR ;

Line 1376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1372:
1373: IF NOT cn_proc_batches_pkg.validate_ruleset_status
1374: (p_start_date, p_end_date, p_org_id) THEN
1375: debugmsg('Loader : validate ruleset fails.');
1376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1377: THEN
1378: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOAD_INVALID_RULESET');
1379: FND_MSG_PUB.Add;
1380: END IF;

Line 1379: FND_MSG_PUB.Add;

1375: debugmsg('Loader : validate ruleset fails.');
1376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1377: THEN
1378: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOAD_INVALID_RULESET');
1379: FND_MSG_PUB.Add;
1380: END IF;
1381: x_loading_status := 'CN_LOAD_INVALID_RULESET';
1382: RAISE FND_API.G_EXC_ERROR ;
1383: END IF;

Line 1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1423:
1424: IF (l_logical_batch_count <= 0) THEN
1425: debugmsg('Loader : No transactions to load.');
1426:
1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1428: THEN
1429: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOAD_NO_TRX_TO_LOAD');
1430: FND_MSG_PUB.Add;
1431: END IF;

Line 1430: FND_MSG_PUB.Add;

1426:
1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1428: THEN
1429: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOAD_NO_TRX_TO_LOAD');
1430: FND_MSG_PUB.Add;
1431: END IF;
1432: x_loading_status := 'CN_LOAD_NO_TRX_TO_LOAD';
1433: RAISE FND_API.G_EXC_ERROR ;
1434: ELSE

Line 1517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1513: IF (valid_transactions%NOTFOUND) THEN
1514:
1515: debugmsg('Loader : All transactions to load have invalid salesrep id.');
1516:
1517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1518: THEN
1519: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOAD_SALESREP_ERROR');
1520: FND_MSG_PUB.Add;
1521: END IF;

Line 1520: FND_MSG_PUB.Add;

1516:
1517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1518: THEN
1519: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOAD_SALESREP_ERROR');
1520: FND_MSG_PUB.Add;
1521: END IF;
1522: x_loading_status := 'CN_LOAD_SALESREP_ERROR';
1523:
1524: RAISE no_valid_transactions;

Line 1719: FND_MSG_PUB.Count_And_Get

1715: END IF;
1716:
1717:
1718: -- Standard call to get message count and if count is 1, get message info.
1719: FND_MSG_PUB.Count_And_Get
1720: (p_count => x_msg_count ,
1721: p_data => x_msg_data ,
1722: p_encoded => FND_API.G_FALSE
1723: );

Line 1747: FND_MSG_PUB.Count_And_Get

1743: cn_message_pkg.end_batch(x_process_audit_id);
1744: x_loading_status := 'EXC_ERR';
1745: x_return_status := FND_API.G_RET_STS_ERROR ;
1746:
1747: FND_MSG_PUB.Count_And_Get
1748: (
1749: p_count => x_msg_count ,
1750: p_data => x_msg_data ,
1751: p_encoded => FND_API.G_FALSE

Line 1759: FND_MSG_PUB.Count_And_Get

1755: debugmsg('Loader : exception : exc_error : End of Loader');
1756: cn_message_pkg.end_batch(x_process_audit_id);
1757: x_loading_status := 'EXC_ERR';
1758: x_return_status := FND_API.G_RET_STS_ERROR ;
1759: FND_MSG_PUB.Count_And_Get
1760: (
1761: p_count => x_msg_count ,
1762: p_data => x_msg_data ,
1763: p_encoded => FND_API.G_FALSE

Line 1771: FND_MSG_PUB.Count_And_Get

1767: debugmsg('Loader : exception : unexc_error : End of Loader');
1768: cn_message_pkg.end_batch(x_process_audit_id);
1769: x_loading_status := 'UNEXPECTED_ERR';
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1771: FND_MSG_PUB.Count_And_Get
1772: (
1773: p_count => x_msg_count ,
1774: p_data => x_msg_data ,
1775: p_encoded => FND_API.G_FALSE

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

1779: debugmsg('Loader : exception : others : End of Loader');
1780: cn_message_pkg.end_batch(x_process_audit_id);
1781: x_loading_status := 'UNEXPECTED_ERR';
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1783: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1784: THEN
1785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1786: END IF;
1787: FND_MSG_PUB.Count_And_Get

Line 1785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1781: x_loading_status := 'UNEXPECTED_ERR';
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1783: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1784: THEN
1785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1786: END IF;
1787: FND_MSG_PUB.Count_And_Get
1788: (
1789: p_count => x_msg_count ,

Line 1787: FND_MSG_PUB.Count_And_Get

1783: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1784: THEN
1785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1786: END IF;
1787: FND_MSG_PUB.Count_And_Get
1788: (
1789: p_count => x_msg_count ,
1790: p_data => x_msg_data ,
1791: p_encoded => FND_API.G_FALSE