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 1217: FND_MSG_PUB.initialize;

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

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

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

Line 1319: FND_MSG_PUB.Add;

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

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

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

Line 1344: FND_MSG_PUB.Add;

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

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

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

Line 1377: FND_MSG_PUB.Add;

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

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

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

Line 1428: FND_MSG_PUB.Add;

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

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

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

Line 1518: FND_MSG_PUB.Add;

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

Line 1717: FND_MSG_PUB.Count_And_Get

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

Line 1745: FND_MSG_PUB.Count_And_Get

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

Line 1757: FND_MSG_PUB.Count_And_Get

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

Line 1769: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 1785: FND_MSG_PUB.Count_And_Get

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