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_API

Line 112: x_return_status := FND_API.G_RET_STS_SUCCESS;

108:
109: BEGIN
110:
111: -- Initialize API return status to success
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113: x_loading_status := p_loading_status;
114:
115: -- Start of API body
116:

Line 901: p_init_msg_list => fnd_api.g_true,

897:
898:
899: cn_calc_classify_pvt.classify_batch
900: ( p_api_version => 1.0,
901: p_init_msg_list => fnd_api.g_true,
902: p_commit => fnd_api.g_true ,
903: x_return_status => x_return_status,
904: x_msg_count => x_msg_count,
905: x_msg_data => x_msg_data,

Line 902: p_commit => fnd_api.g_true ,

898:
899: cn_calc_classify_pvt.classify_batch
900: ( p_api_version => 1.0,
901: p_init_msg_list => fnd_api.g_true,
902: p_commit => fnd_api.g_true ,
903: x_return_status => x_return_status,
904: x_msg_count => x_msg_count,
905: x_msg_data => x_msg_data,
906: p_physical_batch_id => p_physical_batch_id,

Line 918: p_encoded => FND_API.G_FALSE));

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
922: debugmsg('Loader : load_worker : Classification Failed.');

Line 921: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

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
922: debugmsg('Loader : load_worker : Classification Failed.');
923: x_loading_status := 'CN_FAIL_CLASSIFICATION';
924: RAISE FND_API.G_EXC_ERROR;
925: END IF;

Line 924: RAISE FND_API.G_EXC_ERROR;

920:
921: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
922: debugmsg('Loader : load_worker : Classification Failed.');
923: x_loading_status := 'CN_FAIL_CLASSIFICATION';
924: RAISE FND_API.G_EXC_ERROR;
925: END IF;
926:
927: debugmsg('Loader : Load_Worker : Rollup : p_physical_batch_id = '
928: || p_physical_batch_id);

Line 933: p_init_msg_list => fnd_api.g_true,

929: debugmsg('Loader : Load_Worker : Rollup : calling cn_calc_classify_pvt.classify_batch');
930:
931: cn_calc_rollup_pvt.rollup_batch
932: ( p_api_version => 1.0,
933: p_init_msg_list => fnd_api.g_true,
934: p_commit => fnd_api.g_true ,
935: x_return_status => x_return_status,
936: x_msg_count => x_msg_count,
937: x_msg_data => x_msg_data,

Line 934: p_commit => fnd_api.g_true ,

930:
931: cn_calc_rollup_pvt.rollup_batch
932: ( p_api_version => 1.0,
933: p_init_msg_list => fnd_api.g_true,
934: p_commit => fnd_api.g_true ,
935: x_return_status => x_return_status,
936: x_msg_count => x_msg_count,
937: x_msg_data => x_msg_data,
938: p_physical_batch_id => p_physical_batch_id,

Line 951: p_encoded => FND_API.G_FALSE));

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
955: debugmsg('Loader : load_worker : Rollup Failed.');

Line 954: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

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
955: debugmsg('Loader : load_worker : Rollup Failed.');
956: x_loading_status := 'CN_FAIL_ROLLUP';
957: RAISE FND_API.G_EXC_ERROR;
958: END IF;

Line 957: RAISE FND_API.G_EXC_ERROR;

953:
954: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
955: debugmsg('Loader : load_worker : Rollup Failed.');
956: x_loading_status := 'CN_FAIL_ROLLUP';
957: RAISE FND_API.G_EXC_ERROR;
958: END IF;
959:
960: ELSE
961:

Line 973: p_encoded => FND_API.G_FALSE

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
974: );
975:
976: EXCEPTION
977: WHEN FND_API.G_EXC_ERROR THEN

Line 977: WHEN FND_API.G_EXC_ERROR THEN

973: p_encoded => FND_API.G_FALSE
974: );
975:
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: (

Line 978: x_return_status := FND_API.G_RET_STS_ERROR ;

974: );
975:
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 ,

Line 984: p_encoded => FND_API.G_FALSE

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
985: );
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';

Line 986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

982: p_count => x_msg_count ,
983: p_data => x_msg_data ,
984: p_encoded => FND_API.G_FALSE
985: );
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

Line 987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

983: p_data => x_msg_data ,
984: p_encoded => FND_API.G_FALSE
985: );
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: (

Line 994: p_encoded => FND_API.G_FALSE

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
995: );
996: WHEN OTHERS THEN
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
998: x_loading_status := 'UNEXPECTED_ERR';

Line 997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

993: p_data => x_msg_data ,
994: p_encoded => FND_API.G_FALSE
995: );
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

Line 1008: p_encoded => FND_API.G_FALSE

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
1009: );
1010: END Load_worker;
1011:
1012:

Line 1022: -- Default = FND_API.G_FALSE

1018: -- to HEADER table (CN_COMMISSION_HEADERS)
1019: -- Parameters :
1020: -- IN : p_api_version IN NUMBER Require
1021: -- : p_init_msg_list IN VARCHAR2 Optional
1022: -- Default = FND_API.G_FALSE
1023: -- : p_commit IN VARCHAR2 Optional
1024: -- Default = FND_API.G_FALSE
1025: -- : p_validation_level IN NUMBER Optional
1026: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1024: -- Default = FND_API.G_FALSE

1020: -- IN : p_api_version IN NUMBER Require
1021: -- : p_init_msg_list IN VARCHAR2 Optional
1022: -- Default = FND_API.G_FALSE
1023: -- : p_commit IN VARCHAR2 Optional
1024: -- Default = FND_API.G_FALSE
1025: -- : p_validation_level IN NUMBER Optional
1026: -- Default = FND_API.G_VALID_LEVEL_FULL
1027: -- OUT : x_return_status OUT VARCHAR2(1)
1028: -- : x_msg_count OUT NUMBER

Line 1026: -- Default = FND_API.G_VALID_LEVEL_FULL

1022: -- Default = FND_API.G_FALSE
1023: -- : p_commit IN VARCHAR2 Optional
1024: -- Default = FND_API.G_FALSE
1025: -- : p_validation_level IN NUMBER Optional
1026: -- Default = FND_API.G_VALID_LEVEL_FULL
1027: -- OUT : x_return_status OUT VARCHAR2(1)
1028: -- : x_msg_count OUT NUMBER
1029: -- : x_msg_data OUT VARCHAR2(2000)
1030: -- : x_loading_status OUT VARCHAR2

Line 1059: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1055:
1056: PROCEDURE load
1057: (
1058: p_api_version IN NUMBER,
1059: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1060: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1061: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1062: p_salesrep_id IN NUMBER,
1063: p_start_date IN DATE,

Line 1060: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1056: PROCEDURE load
1057: (
1058: p_api_version IN NUMBER,
1059: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1060: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1061: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1062: p_salesrep_id IN NUMBER,
1063: p_start_date IN DATE,
1064: p_end_date IN DATE,

Line 1061: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1057: (
1058: p_api_version IN NUMBER,
1059: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1060: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1061: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1062: p_salesrep_id IN NUMBER,
1063: p_start_date IN DATE,
1064: p_end_date IN DATE,
1065: p_cls_rol_flag IN VARCHAR2,

Line 1209: IF NOT FND_API.compatible_api_call

1205: -- Standard Start of API savepoint
1206: SAVEPOINT load_savepoint;
1207:
1208: -- Standard call to check for call compatibility.
1209: IF NOT FND_API.compatible_api_call
1210: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
1211: THEN
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213: END IF;

Line 1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1208: -- Standard call to check for call compatibility.
1209: IF NOT FND_API.compatible_api_call
1210: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
1211: THEN
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1216: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1221: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1222: x_loading_status := 'CN_LOADED';
1223:
1224:
1225: -- User hooks

Line 1245: IF (x_return_status = FND_API.G_RET_STS_ERROR )

1241: x_msg_data => x_msg_data,
1242: x_loading_status => x_loading_status
1243: );
1244:
1245: IF (x_return_status = FND_API.G_RET_STS_ERROR )
1246: THEN
1247: RAISE FND_API.G_EXC_ERROR;
1248: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1249: THEN

Line 1247: RAISE FND_API.G_EXC_ERROR;

1243: );
1244:
1245: IF (x_return_status = FND_API.G_RET_STS_ERROR )
1246: THEN
1247: RAISE FND_API.G_EXC_ERROR;
1248: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1249: THEN
1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1251: END IF;

Line 1248: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1244:
1245: IF (x_return_status = FND_API.G_RET_STS_ERROR )
1246: THEN
1247: RAISE FND_API.G_EXC_ERROR;
1248: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1249: THEN
1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1251: END IF;
1252: END IF;

Line 1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1246: THEN
1247: RAISE FND_API.G_EXC_ERROR;
1248: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1249: THEN
1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1251: END IF;
1252: END IF;
1253:
1254:

Line 1274: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1270: x_msg_data => x_msg_data,
1271: x_loading_status => x_loading_status
1272: );
1273:
1274: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1275: THEN
1276: RAISE FND_API.G_EXC_ERROR;
1277: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1278: THEN

Line 1276: RAISE FND_API.G_EXC_ERROR;

1272: );
1273:
1274: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1275: THEN
1276: RAISE FND_API.G_EXC_ERROR;
1277: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1278: THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;

Line 1277: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1273:
1274: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1275: THEN
1276: RAISE FND_API.G_EXC_ERROR;
1277: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1278: THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281: END IF;

Line 1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1275: THEN
1276: RAISE FND_API.G_EXC_ERROR;
1277: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1278: THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281: END IF;
1282:
1283:

Line 1323: RAISE FND_API.G_EXC_ERROR ;

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 ;
1324: END IF;
1325:
1326: /* verify that parameter end date is within an open acc period */
1327: l_count := 0;

Line 1348: RAISE FND_API.G_EXC_ERROR ;

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 ;
1349: END IF;
1350:
1351: /* Get the value of the profile "OIC: Skip Credit Allocation" */
1352: l_skip_credit_flag := 'Y';

Line 1380: RAISE FND_API.G_EXC_ERROR ;

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;
1382: END IF;
1383:
1384:

Line 1431: RAISE FND_API.G_EXC_ERROR ;

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
1433: FOR i IN l_srp_id_tbl.FIRST .. l_srp_id_tbl.LAST LOOP
1434:
1435: -- sequence s1 is for process batch id

Line 1632: IF (x_return_status = FND_API.G_RET_STS_ERROR )

1628: x_msg_data => x_msg_data,
1629: x_loading_status => x_loading_status
1630: );
1631:
1632: IF (x_return_status = FND_API.G_RET_STS_ERROR )
1633: THEN
1634: RAISE FND_API.G_EXC_ERROR;
1635: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1636: THEN

Line 1634: RAISE FND_API.G_EXC_ERROR;

1630: );
1631:
1632: IF (x_return_status = FND_API.G_RET_STS_ERROR )
1633: THEN
1634: RAISE FND_API.G_EXC_ERROR;
1635: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1636: THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: END IF;

Line 1635: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1631:
1632: IF (x_return_status = FND_API.G_RET_STS_ERROR )
1633: THEN
1634: RAISE FND_API.G_EXC_ERROR;
1635: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1636: THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: END IF;
1639: END IF;

Line 1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1633: THEN
1634: RAISE FND_API.G_EXC_ERROR;
1635: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1636: THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: END IF;
1639: END IF;
1640:
1641:

Line 1661: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1657: x_msg_data => x_msg_data,
1658: x_loading_status => x_loading_status
1659: );
1660:
1661: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1662: THEN
1663: RAISE FND_API.G_EXC_ERROR;
1664: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1665: THEN

Line 1663: RAISE FND_API.G_EXC_ERROR;

1659: );
1660:
1661: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1662: THEN
1663: RAISE FND_API.G_EXC_ERROR;
1664: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1665: THEN
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;

Line 1664: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1660:
1661: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1662: THEN
1663: RAISE FND_API.G_EXC_ERROR;
1664: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1665: THEN
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668: END IF;

Line 1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1662: THEN
1663: RAISE FND_API.G_EXC_ERROR;
1664: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1665: THEN
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668: END IF;
1669:
1670:

Line 1705: IF (x_return_status = FND_API.G_RET_STS_ERROR)

1701: p_oai_param => null,
1702: p_oai_array => l_oai_array,
1703: x_return_code => x_return_status) ;
1704:
1705: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1706: THEN
1707: RAISE FND_API.G_EXC_ERROR;
1708: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1709: THEN

Line 1707: RAISE FND_API.G_EXC_ERROR;

1703: x_return_code => x_return_status) ;
1704:
1705: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1706: THEN
1707: RAISE FND_API.G_EXC_ERROR;
1708: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1709: THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;

Line 1708: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1704:
1705: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1706: THEN
1707: RAISE FND_API.G_EXC_ERROR;
1708: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1709: THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712: END IF;

Line 1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1706: THEN
1707: RAISE FND_API.G_EXC_ERROR;
1708: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1709: THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712: END IF;
1713: END IF;
1714:

Line 1720: p_encoded => FND_API.G_FALSE

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: );
1722:
1723: EXCEPTION
1724: WHEN no_valid_transactions THEN

Line 1743: x_return_status := FND_API.G_RET_STS_ERROR ;

1739:
1740: debugmsg('Loader : exception : exc_error : End of Loader');
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 ,

Line 1749: p_encoded => FND_API.G_FALSE

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
1750: );
1751: WHEN FND_API.G_EXC_ERROR THEN
1752: ROLLBACK TO load_savepoint;
1753: debugmsg('Loader : exception : exc_error : End of Loader');

Line 1751: WHEN FND_API.G_EXC_ERROR THEN

1747: p_count => x_msg_count ,
1748: p_data => x_msg_data ,
1749: p_encoded => FND_API.G_FALSE
1750: );
1751: WHEN FND_API.G_EXC_ERROR THEN
1752: ROLLBACK TO load_savepoint;
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';

Line 1756: x_return_status := FND_API.G_RET_STS_ERROR ;

1752: ROLLBACK TO load_savepoint;
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 ,

Line 1761: p_encoded => FND_API.G_FALSE

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
1762: );
1763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1764: ROLLBACK TO load_savepoint;
1765: debugmsg('Loader : exception : unexc_error : End of Loader');

Line 1763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1759: p_count => x_msg_count ,
1760: p_data => x_msg_data ,
1761: p_encoded => FND_API.G_FALSE
1762: );
1763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1764: ROLLBACK TO load_savepoint;
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';

Line 1768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1764: ROLLBACK TO load_savepoint;
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 ,

Line 1773: p_encoded => FND_API.G_FALSE

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
1774: );
1775: WHEN OTHERS THEN
1776: ROLLBACK TO load_savepoint;
1777: debugmsg('Loader : exception : others : End of Loader');

Line 1780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1776: ROLLBACK TO load_savepoint;
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;

Line 1789: p_encoded => FND_API.G_FALSE

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
1790: );
1791: END load;
1792:
1793: END cn_transaction_load_pub;