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_SCA_INTERFACE_MAP_PVT dependencies on FND_MSG_PUB

Line 242: FND_MSG_PUB.initialize;

238: SAVEPOINT check_create_object;
239:
240: IF FND_API.to_Boolean( p_init_msg_list )
241: THEN
242: FND_MSG_PUB.initialize;
243: END IF;
244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:

Line 286: FND_MSG_PUB.Count_And_Get

282: AND object_type = P_OBJECT_TYPE
283: AND org_id = p_org_id; -- MOAC Change
284: END IF;
285:
286: FND_MSG_PUB.Count_And_Get
287: (p_count => x_msg_count,
288: p_data => x_msg_data,
289: p_encoded => FND_API.G_FALSE);
290:

Line 297: FND_MSG_PUB.Add_Exc_Msg( P_NAME ,'check_create_object' );

293: WHEN FND_API.G_EXC_ERROR
294: THEN
295: ROLLBACK TO check_create_object;
296: x_return_status := FND_API.G_RET_STS_ERROR ;
297: FND_MSG_PUB.Add_Exc_Msg( P_NAME ,'check_create_object' );
298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count,
300: p_data => x_msg_data,
301: p_encoded => FND_API.G_FALSE);

Line 298: FND_MSG_PUB.Count_And_Get

294: THEN
295: ROLLBACK TO check_create_object;
296: x_return_status := FND_API.G_RET_STS_ERROR ;
297: FND_MSG_PUB.Add_Exc_Msg( P_NAME ,'check_create_object' );
298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count,
300: p_data => x_msg_data,
301: p_encoded => FND_API.G_FALSE);
302:

Line 307: FND_MSG_PUB.Add_Exc_Msg( P_NAME ,'check_create_object' );

303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
304: THEN
305: ROLLBACK TO check_create_object;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
307: FND_MSG_PUB.Add_Exc_Msg( P_NAME ,'check_create_object' );
308: FND_MSG_PUB.Count_And_Get
309: (p_count => x_msg_count,
310: p_data => x_msg_data,
311: p_encoded => FND_API.G_FALSE);

Line 308: FND_MSG_PUB.Count_And_Get

304: THEN
305: ROLLBACK TO check_create_object;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
307: FND_MSG_PUB.Add_Exc_Msg( P_NAME ,'check_create_object' );
308: FND_MSG_PUB.Count_And_Get
309: (p_count => x_msg_count,
310: p_data => x_msg_data,
311: p_encoded => FND_API.G_FALSE);
312: WHEN OTHERS THEN

Line 316: FND_MSG_PUB.ADD_EXC_MSG( P_NAME ,'check_create_object');

312: WHEN OTHERS THEN
313: ROLLBACK TO check_create_object;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315:
316: FND_MSG_PUB.ADD_EXC_MSG( P_NAME ,'check_create_object');
317:
318: FND_MSG_PUB.Count_And_Get
319: (p_count => x_msg_count,
320: p_data => x_msg_data,

Line 318: FND_MSG_PUB.Count_And_Get

314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315:
316: FND_MSG_PUB.ADD_EXC_MSG( P_NAME ,'check_create_object');
317:
318: FND_MSG_PUB.Count_And_Get
319: (p_count => x_msg_count,
320: p_data => x_msg_data,
321: p_encoded => FND_API.G_FALSE);
322:

Line 478: FND_MSG_PUB.Count_And_Get

474: ELSE
475: x_compile_status := 'COMPLETE';
476: END IF;
477:
478: FND_MSG_PUB.Count_And_Get
479: (p_count => x_msg_count,
480: p_data => x_msg_data,
481: p_encoded => FND_API.G_FALSE);
482:

Line 489: FND_MSG_PUB.Count_And_Get

485: THEN
486: ROLLBACK TO install_package_object;
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: x_compile_status := 'INCOMPLETE';
489: FND_MSG_PUB.Count_And_Get
490: (p_count => x_msg_count,
491: p_data => x_msg_data);
492: WHEN OTHERS
493: THEN

Line 497: FND_MSG_PUB.Count_And_Get

493: THEN
494: ROLLBACK TO install_package_object;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: x_compile_status := 'INCOMPLETE';
497: FND_MSG_PUB.Count_And_Get
498: (p_count => x_msg_count,
499: p_data => x_msg_data);
500: END install_package_object;
501:

Line 612: FND_MSG_PUB.initialize;

608: -- Initialize message list if p_init_msg_list is set to TRUE.
609: ------++
610: IF FND_API.to_Boolean( p_init_msg_list )
611: THEN
612: FND_MSG_PUB.initialize;
613: END IF;
614: ------++
615: -- Initialize API return status to success
616: ------++

Line 660: FND_MSG_PUB.Add_Exc_Msg( 'CN_SCA_INTERFACE_MAP_PVT' ,'GENERATE');

656: l_trx_src_column_name(l_loop_cntr1) := cnracv.trx_src_column_name;
657: ELSE
658: x_return_status := fnd_api.g_ret_sts_error;
659: FND_MESSAGE.SET_NAME('CN','CN_SCA_NO_ATTR_MAP');
660: FND_MSG_PUB.Add_Exc_Msg( 'CN_SCA_INTERFACE_MAP_PVT' ,'GENERATE');
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: END IF;
663:
664: END LOOP;

Line 856: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');

852: cn_utils.appendcr(l_body_code,' END IF;');
853:
854: cn_utils.appendcr(l_body_code,' IF FND_API.to_Boolean( p_init_msg_list )');
855: cn_utils.appendcr(l_body_code,' THEN');
856: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');
857: cn_utils.appendcr(l_body_code,' END IF;');
858:
859: cn_utils.appendcr(l_body_code,' -- Initialize API return status to success');
860: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_SUCCESS;');

Line 871: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');

867: cn_utils.appendcr(l_body_code,' IF ((x_start_id IS NULL) OR (x_end_id IS NULL))');
868: cn_utils.appendcr(l_body_code,' THEN');
869: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_ERROR;');
870: cn_utils.appendcr(l_body_code,' FND_MESSAGE.SET_NAME(''CN'',''CN_SCA_INVALID_BATCH_ID'');');
871: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');
872: cn_utils.appendcr(l_body_code,' RAISE FND_API.G_EXC_ERROR;');
873: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
874: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
875: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');

Line 873: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

869: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_ERROR;');
870: cn_utils.appendcr(l_body_code,' FND_MESSAGE.SET_NAME(''CN'',''CN_SCA_INVALID_BATCH_ID'');');
871: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');
872: cn_utils.appendcr(l_body_code,' RAISE FND_API.G_EXC_ERROR;');
873: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
874: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
875: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
876: cn_utils.appendcr(l_body_code,' END IF;');
877:

Line 884: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

880: cn_utils.appendcr(l_body_code,' THEN');
881: cn_utils.appendcr(l_body_code,' ROLLBACK TO get_init_values;');
882: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_ERROR;');
883: cn_utils.appendcr(l_body_code,' debugmsg(''Error In Procedure GET_INIT_VALUES'');');
884: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
885: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
886: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
887: cn_utils.appendcr(l_body_code,' WHEN FND_API.G_EXC_UNEXPECTED_ERROR');
888: cn_utils.appendcr(l_body_code,' THEN');

Line 892: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');

888: cn_utils.appendcr(l_body_code,' THEN');
889: cn_utils.appendcr(l_body_code,' ROLLBACK TO get_init_values;');
890: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
891: cn_utils.appendcr(l_body_code,' debugmsg(''Unexpected Error In Procedure GET_INIT_VALUES''||SQLERRM);');
892: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');
893: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
894: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
895: cn_utils.appendcr(l_body_code,' WHEN OTHERS');
896: cn_utils.appendcr(l_body_code,' THEN ');

Line 900: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');

896: cn_utils.appendcr(l_body_code,' THEN ');
897: cn_utils.appendcr(l_body_code,' ROLLBACK TO get_init_values;');
898: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
899: cn_utils.appendcr(l_body_code,' debugmsg(''Unhandled Error In Procedure GET_INIT_VALUES''||SQLERRM);');
900: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');
901: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
902: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
903: cn_utils.appendcr(l_body_code,' END get_init_values;');
904:

Line 982: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');

978: cn_utils.appendcr(l_body_code,' -----+');
979: cn_utils.appendcr(l_body_code,' -- Initialize message list if p_init_msg_list is set to TRUE.');
980: cn_utils.appendcr(l_body_code,' -----+');
981: cn_utils.appendcr(l_body_code,' IF FND_API.to_Boolean( p_init_msg_list ) THEN');
982: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');
983: cn_utils.appendcr(l_body_code,' END IF;');
984:
985: cn_utils.appendcr(l_body_code,' l_adj_by := get_adjusted_by(p_sca_process_batch_id, p_org_id);');
986:

Line 1048: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');

1044: cn_utils.appendcr(l_body_code,' THEN');
1045: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_reset_error_normal;');
1046: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
1047: cn_utils.appendcr(l_body_code,' debugmsg(''Unexpected Error In Procedure CHECK_RESET_ERROR_NORMAL''||SQLERRM);');
1048: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');
1049: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1050: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1051: cn_utils.appendcr(l_body_code,' WHEN OTHERS');
1052: cn_utils.appendcr(l_body_code,' THEN');

Line 1056: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

1052: cn_utils.appendcr(l_body_code,' THEN');
1053: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_reset_error_normal;');
1054: cn_utils.appendcr(l_body_code,' debugmsg(''Error In Procedure CHECK_RESET_ERROR_NORMAL''||SQLERRM);');
1055: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_ERROR;');
1056: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
1057: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1058: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1059: cn_utils.appendcr(l_body_code,' END check_reset_error_normal;');
1060: cn_utils.appendcr(l_body_code,' PROCEDURE check_update_revenue_error(');

Line 1163: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');

1159: cn_utils.appendcr(l_body_code,' -----+');
1160: cn_utils.appendcr(l_body_code,' -- Initialize message list if p_init_msg_list is set to TRUE.');
1161: cn_utils.appendcr(l_body_code,' -----+');
1162: cn_utils.appendcr(l_body_code,' IF FND_API.to_Boolean( p_init_msg_list ) THEN');
1163: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');
1164: cn_utils.appendcr(l_body_code,' END IF;');
1165:
1166: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1167:

Line 1234: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');

1230: cn_utils.appendcr(l_body_code,' THEN');
1231: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_update_revenue_error;');
1232: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
1233: cn_utils.appendcr(l_body_code,' debugmsg(''Unexpected Error In Procedure CHECK_UPDATE_REVENUE_ERROR''||SQLERRM);');
1234: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');
1235: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1236: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1237: cn_utils.appendcr(l_body_code,' WHEN OTHERS');
1238: cn_utils.appendcr(l_body_code,' THEN');

Line 1242: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

1238: cn_utils.appendcr(l_body_code,' THEN');
1239: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_update_revenue_error;');
1240: cn_utils.appendcr(l_body_code,' debugmsg(''Error In Procedure CHECK_UPDATE_REVENUE_ERROR''||SQLERRM);');
1241: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_ERROR;');
1242: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
1243: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1244: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1245: cn_utils.appendcr(l_body_code,' END check_update_revenue_error;');
1246:

Line 1308: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');

1304: cn_utils.appendcr(l_body_code,' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
1305: cn_utils.appendcr(l_body_code,' END IF;');
1306: cn_utils.appendcr(l_body_code,' -- Initialize message list if p_init_msg_list is set to TRUE.');
1307: cn_utils.appendcr(l_body_code,' IF FND_API.to_Boolean( p_init_msg_list ) THEN');
1308: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');
1309: cn_utils.appendcr(l_body_code,' END IF;');
1310:
1311: cn_utils.appendcr(l_body_code,' -- Initialize API return status to success');
1312: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_SUCCESS;');

Line 1408: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');

1404: cn_utils.appendcr(l_body_code,' THEN');
1405: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_update_role_error;');
1406: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
1407: cn_utils.appendcr(l_body_code,' debugmsg(''Unexpected Error In Procedure CHECK_UPDATE_ROLE_ERROR''||SQLERRM);');
1408: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');
1409: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1410: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1411: cn_utils.appendcr(l_body_code,' WHEN OTHERS');
1412: cn_utils.appendcr(l_body_code,' THEN');

Line 1416: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

1412: cn_utils.appendcr(l_body_code,' THEN');
1413: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_update_role_error;');
1414: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_ERROR;');
1415: cn_utils.appendcr(l_body_code,' debugmsg(''Unhandled Error In Procedure CHECK_UPDATE_ROLE_ERROR''||SQLERRM);');
1416: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
1417: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1418: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1419: cn_utils.appendcr(l_body_code,' END check_update_role_error;');
1420: ------++

Line 1480: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');

1476: cn_utils.appendcr(l_body_code,' END IF;');
1477:
1478: cn_utils.appendcr(l_body_code,' -- Initialize message list if p_init_msg_list is set to TRUE.');
1479: cn_utils.appendcr(l_body_code,' IF FND_API.to_Boolean( p_init_msg_list ) THEN');
1480: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');
1481: cn_utils.appendcr(l_body_code,' END IF;');
1482:
1483: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1484:

Line 1578: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');

1574: cn_utils.appendcr(l_body_code,' THEN');
1575: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_update_resource_error;');
1576: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
1577: cn_utils.appendcr(l_body_code,' debugmsg(''Unexpected Error In Procedure CHECK_UPDATE_RESOURCE_ERROR''||SQLERRM);');
1578: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');
1579: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1580: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1581: cn_utils.appendcr(l_body_code,' WHEN OTHERS');
1582: cn_utils.appendcr(l_body_code,' THEN');

Line 1586: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

1582: cn_utils.appendcr(l_body_code,' THEN');
1583: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_update_resource_error;');
1584: cn_utils.appendcr(l_body_code,' debugmsg(''Error In Procedure CHECK_UPDATE_RESOURCE_ERROR''||SQLERRM);');
1585: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_ERROR;');
1586: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
1587: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1588: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1589: cn_utils.appendcr(l_body_code,' END check_update_resource_error;');
1590: ------++

Line 1627: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');

1623: cn_utils.appendcr(l_body_code,' END IF;');
1624:
1625: cn_utils.appendcr(l_body_code,' -- Initialize message list if p_init_msg_list is set to TRUE.');
1626: cn_utils.appendcr(l_body_code,' IF FND_API.to_Boolean( p_init_msg_list ) THEN');
1627: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.initialize;');
1628: cn_utils.appendcr(l_body_code,' END IF;');
1629:
1630: cn_utils.appendcr(l_body_code,' -- Initialize API return status to success');
1631: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_SUCCESS;');

Line 1721: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');

1717: cn_utils.appendcr(l_body_code,' THEN');
1718: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_update_distinct_error;');
1719: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
1720: cn_utils.appendcr(l_body_code,' debugmsg(''Unexpected Error In Procedure CHECK_UPDATE_DISTINCT_ERROR''||SQLERRM);');
1721: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');
1722: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1723: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1724: cn_utils.appendcr(l_body_code,' WHEN OTHERS');
1725: cn_utils.appendcr(l_body_code,' THEN');

Line 1729: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

1725: cn_utils.appendcr(l_body_code,' THEN');
1726: cn_utils.appendcr(l_body_code,' ROLLBACK TO check_update_distinct_error;');
1727: cn_utils.appendcr(l_body_code,' debugmsg(''Error In Procedure CHECK_UPDATE_DISTINCT_ERROR''||SQLERRM); ');
1728: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
1729: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
1730: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
1731: cn_utils.appendcr(l_body_code,' p_data => x_msg_data);');
1732: cn_utils.appendcr(l_body_code,' END check_update_distinct_error;');
1733:

Line 2032: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');

2028: cn_utils.appendcr(l_body_code,' IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)');
2029: cn_utils.appendcr(l_body_code,' THEN');
2030: cn_utils.appendcr(l_body_code,' x_return_status := l_return_status;');
2031: cn_utils.appendcr(l_body_code,' FND_MESSAGE.SET_NAME(''CN'',''CN_GET_INIT_VALUES_ERROR'');');
2032: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');
2033: cn_utils.appendcr(l_body_code,' RAISE FND_API.G_EXC_ERROR;');
2034: cn_utils.appendcr(l_body_code,' END IF;');
2035:
2036: cn_utils.appendcr(l_body_code,' check_reset_error_normal(');

Line 2055: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');

2051: cn_utils.appendcr(l_body_code,' IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)');
2052: cn_utils.appendcr(l_body_code,' THEN');
2053: cn_utils.appendcr(l_body_code,' x_return_status := l_return_status;');
2054: cn_utils.appendcr(l_body_code,' FND_MESSAGE.SET_NAME(''CN'',''CN_CHECK_RESET_ERROR_NORMAL'');');
2055: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');
2056: cn_utils.appendcr(l_body_code,' RAISE FND_API.G_EXC_ERROR;');
2057: cn_utils.appendcr(l_body_code,' END IF;');
2058:
2059: cn_utils.appendcr(l_body_code,' check_update_revenue_error(');

Line 2077: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');

2073: cn_utils.appendcr(l_body_code,' IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)');
2074: cn_utils.appendcr(l_body_code,' THEN');
2075: cn_utils.appendcr(l_body_code,' x_return_status := l_return_status;');
2076: cn_utils.appendcr(l_body_code,' FND_MESSAGE.SET_NAME(''CN'',''CN_CHK_REV_ERROR'');');
2077: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');
2078: cn_utils.appendcr(l_body_code,' RAISE FND_API.G_EXC_ERROR;');
2079: cn_utils.appendcr(l_body_code,' END IF;');
2080:
2081: cn_utils.appendcr(l_body_code,' check_update_role_error(');

Line 2100: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');

2096: cn_utils.appendcr(l_body_code,' IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)');
2097: cn_utils.appendcr(l_body_code,' THEN');
2098: cn_utils.appendcr(l_body_code,' x_return_status := l_return_status;');
2099: cn_utils.appendcr(l_body_code,' FND_MESSAGE.SET_NAME(''CN'',''CN_CHK_ROLE_ERROR'');');
2100: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');
2101: cn_utils.appendcr(l_body_code,' RAISE FND_API.G_EXC_ERROR;');
2102: cn_utils.appendcr(l_body_code,' END IF;');
2103:
2104: cn_utils.appendcr(l_body_code,' check_update_resource_error(');

Line 2123: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');

2119: cn_utils.appendcr(l_body_code,' IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)');
2120: cn_utils.appendcr(l_body_code,' THEN');
2121: cn_utils.appendcr(l_body_code,' x_return_status := l_return_status;');
2122: cn_utils.appendcr(l_body_code,' FND_MESSAGE.SET_NAME(''CN'',''CN_CHK_RES_ERROR'');');
2123: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');
2124: cn_utils.appendcr(l_body_code,' RAISE FND_API.G_EXC_ERROR;');
2125: cn_utils.appendcr(l_body_code,' END IF;');
2126:
2127: cn_utils.appendcr(l_body_code,' check_update_distinct_error(');

Line 2146: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');

2142: cn_utils.appendcr(l_body_code,' IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)');
2143: cn_utils.appendcr(l_body_code,' THEN');
2144: cn_utils.appendcr(l_body_code,' x_return_status := l_return_status;');
2145: cn_utils.appendcr(l_body_code,' FND_MESSAGE.SET_NAME(''CN'',''CN_CHK_DIST_ERROR'');');
2146: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.ADD;');
2147: cn_utils.appendcr(l_body_code,' RAISE FND_API.G_EXC_ERROR;');
2148: cn_utils.appendcr(l_body_code,' END IF;');
2149:
2150: cn_utils.appendcr(l_body_code,' IF l_trx_type = ''ORD'' ');

Line 2234: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

2230: cn_utils.appendcr(l_body_code,' last_update_date = SYSDATE');
2231: cn_utils.appendcr(l_body_code,' WHERE comm_lines_api_id = sca_ccla_id_var(k)');
2232: cn_utils.appendcr(l_body_code,' AND org_id = p_org_id;');
2233: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2234: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
2235: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
2236: cn_utils.appendcr(l_body_code,' p_data => x_msg_data,');
2237: cn_utils.appendcr(l_body_code,' p_encoded => FND_API.G_TRUE);');
2238: cn_utils.appendcr(l_body_code,' END IF;');

Line 2324: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

2320: cn_utils.appendcr(l_body_code,' last_update_date = SYSDATE');
2321: cn_utils.appendcr(l_body_code,' WHERE comm_lines_api_id = sca_ccla_id_var(k)');
2322: cn_utils.appendcr(l_body_code,' AND org_id = p_org_id;');
2323: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2324: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
2325: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
2326: cn_utils.appendcr(l_body_code,' p_data => x_msg_data,');
2327: cn_utils.appendcr(l_body_code,' p_encoded => FND_API.G_TRUE);');
2328: cn_utils.appendcr(l_body_code,' END IF;');

Line 2380: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');

2376: cn_utils.appendcr(l_body_code,' THEN');
2377: cn_utils.appendcr(l_body_code,' ROLLBACK TO map_package_savepoint;');
2378: cn_utils.appendcr(l_body_code,' debugmsg(''User Error In Dynamic Mapping Package'');');
2379: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_ERROR;');
2380: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.count_and_get');
2381: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
2382: cn_utils.appendcr(l_body_code,' p_data => x_msg_data,');
2383: cn_utils.appendcr(l_body_code,' p_encoded => FND_API.G_TRUE);');
2384: cn_utils.appendcr(l_body_code,' WHEN FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2389: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');

2385: cn_utils.appendcr(l_body_code,' THEN');
2386: cn_utils.appendcr(l_body_code,' ROLLBACK TO map_package_savepoint;');
2387: cn_utils.appendcr(l_body_code,' debugmsg(''Unexpected Error In Dynamic Mapping Package'');');
2388: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
2389: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');
2390: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
2391: cn_utils.appendcr(l_body_code,' p_data => x_msg_data,');
2392: cn_utils.appendcr(l_body_code,' p_encoded => FND_API.G_TRUE);');
2393: cn_utils.appendcr(l_body_code,' WHEN OTHERS');

Line 2398: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');

2394: cn_utils.appendcr(l_body_code,' THEN');
2395: cn_utils.appendcr(l_body_code,' ROLLBACK TO map_package_savepoint;');
2396: cn_utils.appendcr(l_body_code,' debugmsg(''Unhandled Error In Dynamic Mapping Package''||SQLCODE||'' ''||SQLERRM);');
2397: cn_utils.appendcr(l_body_code,' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
2398: cn_utils.appendcr(l_body_code,' FND_MSG_PUB.Count_And_Get');
2399: cn_utils.appendcr(l_body_code,' (p_count => x_msg_count,');
2400: cn_utils.appendcr(l_body_code,' p_data => x_msg_data,');
2401: cn_utils.appendcr(l_body_code,' p_encoded => FND_API.G_TRUE);');
2402:

Line 2421: FND_MSG_PUB.count_and_get

2417:
2418: IF (l_compile_status = 'COMPLETE')
2419: THEN
2420: x_return_status := FND_API.G_RET_STS_SUCCESS;
2421: FND_MSG_PUB.count_and_get
2422: (p_count => x_msg_count,
2423: p_data => x_msg_data,
2424: p_encoded => FND_API.G_TRUE);
2425: ELSE

Line 2436: FND_MSG_PUB.Count_And_Get

2432: EXCEPTION
2433: WHEN FND_API.G_EXC_ERROR THEN
2434: -- ROLLBACK TO generate_map_package;
2435: x_return_status := FND_API.G_RET_STS_ERROR ;
2436: FND_MSG_PUB.Count_And_Get
2437: (p_count => x_msg_count,
2438: p_data => x_msg_data);
2439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2441: FND_MSG_PUB.Count_And_Get

2437: (p_count => x_msg_count,
2438: p_data => x_msg_data);
2439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2441: FND_MSG_PUB.Count_And_Get
2442: (p_count => x_msg_count,
2443: p_data => x_msg_data);
2444: WHEN OTHERS THEN
2445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2446: FND_MSG_PUB.Count_And_Get

2442: (p_count => x_msg_count,
2443: p_data => x_msg_data);
2444: WHEN OTHERS THEN
2445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2446: FND_MSG_PUB.Count_And_Get
2447: (p_count => x_msg_count,
2448: p_data => x_msg_data);
2449: END generate;
2450: END cn_sca_interface_map_pvt;