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.HZ_COPY_REL_PVT dependencies on FND_API

Line 58: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

54: BEGIN
55: FND_MSG_PUB.Reset;
56: log('---------------------------');
57: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
58: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
59: END LOOP;
60: IF (SQLERRM IS NOT NULL) THEN
61: l_msg_data := l_msg_data || SQLERRM;
62: END IF;

Line 143: x_return_status := fnd_api.g_ret_sts_error;

139: IF l_count <> 0
140: THEN
141: FND_MESSAGE.SET_NAME('AR', 'HZ_REL_TYPE_ROLE_MEANING_ERR');
142: FND_MSG_PUB.ADD;
143: x_return_status := fnd_api.g_ret_sts_error;
144: ELSE
145: BEGIN
146: FND_LOOKUP_VALUES_PKG.INSERT_ROW(
147: X_ROWID => x_rowid,

Line 187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

183: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
184: FND_MESSAGE.SET_TOKEN('PROC' ,'CREATE_LOOKUP');
185: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
186: FND_MSG_PUB.ADD;
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END;
189: END IF;
190:
191: end;

Line 521: x_return_status := FND_API.G_RET_STS_SUCCESS;

517: -- avoid api error.
518: FND_PROFILE.PUT('HZ_GENERATE_PARTY_NUMBER', 'Y');
519:
520: -- initialize return status
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522:
523:
524: FOR id_cur in c0
525: LOOP

Line 528: FND_API.G_FALSE,

524: FOR id_cur in c0
525: LOOP
526: -- GET RELATIONSHIP RECORD
527: hz_relationship_v2pub.get_relationship_rec(
528: FND_API.G_FALSE,
529: id_cur.relationship_id,
530: 'F',
531: p_relationship_rec,
532: x_return_status,

Line 554: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

550:
551: -- Bug 4288839.
552: -- Donot raise error when create relationship fails.
553: -- Instead log the errors in the log file and continue processing.
554: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
555:
556: THEN
557: log('NEWLINE');
558: log('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

Line 582: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

578: log('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
579: log('NEWLINE');
580:
581: G_RET_CODE := FALSE;
582: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583:
584: END IF;
585:
586:

Line 596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

592: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
593: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_RELATIONSHIPS');
594: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
595: FND_MSG_PUB.ADD;
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END copy_relationships ;
598:
599:
600: --------------------------------------------------------------------------------------

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

656:
657:
658: BEGIN
659: -- INITIALIZE RETURN STATUS
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662:
663: -- initialize the temporary variable
664: temp := -1;

Line 701: if (x_return_status <> FND_API.G_RET_STS_SUCCESS )

697: log('meaning is ' || temp1);
698: log('description is ' || temp2);
699: create_lookup(forward_role, temp1, temp2,x_return_status);
700: /* Bug 3620141 */
701: if (x_return_status <> FND_API.G_RET_STS_SUCCESS )
702: THEN
703: RAISE CREATE_LOOKUP_EXCEPTION;
704: END IF;
705: temp1 := p_dest_rel_type_role_prefix || get_meaning(rel_type_record.backward_role)

Line 723: if (x_return_status <> FND_API.G_RET_STS_SUCCESS )

719: log('meaning is ' || temp1);
720: log('description is ' || temp2);
721: create_lookup(backward_role, temp1, temp2,x_return_status);
722: /* Bug 3620141 */
723: if (x_return_status <> FND_API.G_RET_STS_SUCCESS )
724: THEN
725: RAISE CREATE_LOOKUP_EXCEPTION;
726: END IF;
727:

Line 749: if (x_return_status <> FND_API.G_RET_STS_SUCCESS)

745: log('meaning is ' || temp1);
746: log('description is ' || temp2);
747: create_lookup(forward_role, temp1, temp2,x_return_status);
748: /* Bug 3620141 */
749: if (x_return_status <> FND_API.G_RET_STS_SUCCESS)
750: THEN
751: RAISE CREATE_LOOKUP_EXCEPTION;
752: END IF;
753: backward_role := forward_role;

Line 783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

779: x_relationship_type_id,x_return_status,
780: x_msg_count,x_msg_data);
781:
782: -- RAISE HELL WHEN return status is not success
783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
784: THEN
785: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
786: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE');
787: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

Line 789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

785: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
786: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE');
787: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
788: FND_MSG_PUB.ADD;
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
790: END IF;
791:
792: END LOOP;
793:

Line 801: p_encoded => FND_API.G_FALSE,

797:
798: EXCEPTION
799: WHEN CREATE_LOOKUP_EXCEPTION THEN
800: FND_MSG_PUB.COUNT_AND_GET(
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );
805: WHEN OTHERS THEN

Line 811: p_encoded => FND_API.G_FALSE,

807: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_SELECTED_PHRASE_PAIR');
808: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
809: FND_MSG_PUB.ADD;
810: FND_MSG_PUB.COUNT_AND_GET(
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data
814: );
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data
814: );
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816:
817: END ;
818:
819: -------------------------------------------------------------------------------------

Line 850: x_return_status := FND_API.G_RET_STS_SUCCESS;

846: and (end_date is null or end_date > p_rel_valid_date )
847: and start_date < p_rel_valid_date ;
848: BEGIN
849: -- INITIALIZE RETURN STATUS
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851:
852: FOR id_rec in c0
853: LOOP
854: -- GET RELATIONSHIP RECORD

Line 856: FND_API.G_FALSE,

852: FOR id_rec in c0
853: LOOP
854: -- GET RELATIONSHIP RECORD
855: hz_relationship_v2pub.get_relationship_rec(
856: FND_API.G_FALSE,
857: id_rec.relationship_id,
858: 'F',
859: p_relationship_rec,
860: x_return_status,

Line 884: IF x_return_status = FND_API.G_RET_STS_SUCCESS

880: hz_relationship_v2pub.create_relationship('T',p_relationship_rec,x_relationship_id,
881: x_party_id,x_party_number,x_return_status,x_msg_count,x_msg_data,'');
882:
883:
884: IF x_return_status = FND_API.G_RET_STS_SUCCESS
885: THEN
886: -- this is the tricky bit, the child could be either the subject or the object.
887: -- in any case, the child should be the id in the record, which is not the parent.
888: IF p_relationship_rec.object_id = p_party_id

Line 927: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

923: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
924: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP');
925: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
926: -- FND_MSG_PUB.ADD;
927: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: l_message_text := FND_MESSAGE.GET;
929: log(l_message_text);
930:
931: log('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

Line 951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

947: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
948: FND_MESSAGE.SET_TOKEN('PROC' ,'CREATE_HIERARCHY');
949: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
950: FND_MSG_PUB.ADD;
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: END create_hierarchy;
953:
954:
955: --------------------------------------------------------------------------------------

Line 1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

1018:
1019: BEGIN
1020: savepoint copy_rel_type_only ;
1021: -- INITIALIZE RETURN STATUS
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:
1024: -- initialize the temporary variable
1025: temp := -1;
1026:

Line 1063: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )

1059: log('meaning is ' || temp1);
1060: log('description is ' || temp2);
1061: create_lookup(forward_role, temp1, temp2,x_return_status);
1062: /* Bug 3620141 */
1063: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
1064: THEN
1065: RAISE CREATE_LOOKUP_EXCEPTION;
1066: END IF;
1067:

Line 1088: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )

1084: log('meaning is ' || temp1);
1085: log('description is ' || temp2);
1086: create_lookup(backward_role, temp1, temp2, x_return_status);
1087: /* Bug 3620141 */
1088: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
1089: THEN
1090: RAISE CREATE_LOOKUP_EXCEPTION;
1091: END IF;
1092:

Line 1122: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )

1118: log('meaning is ' || temp1);
1119: log('description is ' || temp2);
1120: create_lookup(forward_role, temp1, temp2,x_return_status);
1121: /* Bug 3620141 */
1122: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
1123: THEN
1124: RAISE CREATE_LOOKUP_EXCEPTION;
1125: END IF;
1126: backward_role := forward_role;

Line 1154: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1150: hz_relationship_type_v2pub.create_relationship_type('T',p_relationship_type_rec,
1151: x_relationship_type_id,x_return_status,
1152: x_msg_count,x_msg_data);
1153: -- RAISE HELL WHEN return status is not success
1154: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1155: THEN
1156: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1157: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE');
1158: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

Line 1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1156: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1157: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE');
1158: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;
1162:
1163: END LOOP;
1164:

Line 1169: x_return_status := FND_API.G_RET_STS_ERROR;

1165:
1166: EXCEPTION
1167: WHEN CREATE_LOOKUP_EXCEPTION THEN
1168: ROLLBACK TO copy_rel_type_only;
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: FND_MSG_PUB.Count_And_Get(
1171: p_encoded => FND_API.G_FALSE,
1172: p_count => x_msg_count,
1173: p_data => x_msg_data);

Line 1171: p_encoded => FND_API.G_FALSE,

1167: WHEN CREATE_LOOKUP_EXCEPTION THEN
1168: ROLLBACK TO copy_rel_type_only;
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: FND_MSG_PUB.Count_And_Get(
1171: p_encoded => FND_API.G_FALSE,
1172: p_count => x_msg_count,
1173: p_data => x_msg_data);
1174:
1175:

Line 1178: x_return_status := FND_API.G_RET_STS_ERROR;

1174:
1175:
1176: WHEN OTHERS THEN
1177: rollback to copy_rel_type_only ;
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1180: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_ONLY');
1181: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1182: FND_MSG_PUB.ADD;

Line 1184: p_encoded => FND_API.G_FALSE,

1180: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_ONLY');
1181: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1182: FND_MSG_PUB.ADD;
1183: FND_MSG_PUB.Count_And_Get(
1184: p_encoded => FND_API.G_FALSE,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data);
1187:
1188: END copy_rel_type_only ;

Line 1223: x_return_status := FND_API.G_RET_STS_SUCCESS;

1219:
1220: G_RET_CODE := TRUE;
1221:
1222: -- return is status unless otherwise changed
1223: x_return_status := FND_API.G_RET_STS_SUCCESS;
1224:
1225: log('-------------------------------------------');
1226: log('Passed in Source Rel Type is ' || p_source_rel_type );
1227: log('Passed in Destination Rel Type is ' || p_dest_rel_type );

Line 1242: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1238:
1239:
1240:
1241: -- RAISE HELL WHEN return status is not success
1242: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1243: THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: END IF;
1246:

Line 1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1240:
1241: -- RAISE HELL WHEN return status is not success
1242: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1243: THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: END IF;
1246:
1247:
1248: -- NOW, CREATE ALL THE RELATIONSHIPS FOR THE NEWLY CREATED RELATIONSHIP TYPE

Line 1258: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1254: -- Error out the concurrent program and rollback all changes.
1255:
1256:
1257: -- RAISE HELL WHEN return status is not success
1258: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1259: THEN
1260: -- dbms_output.put_line('Return status after copy relationships is ' || x_return_status);
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END IF;*/

Line 1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1257: -- RAISE HELL WHEN return status is not success
1258: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1259: THEN
1260: -- dbms_output.put_line('Return status after copy relationships is ' || x_return_status);
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END IF;*/
1263:
1264: IF G_RET_CODE = FALSE THEN
1265: ROLLBACK TO copy_rel_type_and_all_rels;

Line 1275: x_return_status := FND_API.G_RET_STS_ERROR;

1271: EXCEPTION
1272: WHEN OTHERS
1273: THEN
1274: ROLLBACK TO copy_rel_type_and_all_rels ;
1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1277: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_AND_ALL_RELS');
1278: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1279: FND_MSG_PUB.ADD;

Line 1281: p_encoded => FND_API.G_FALSE,

1277: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_AND_ALL_RELS');
1278: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1279: FND_MSG_PUB.ADD;
1280: FND_MSG_PUB.Count_And_Get(
1281: p_encoded => FND_API.G_FALSE,
1282: p_count => x_msg_count,
1283: p_data => x_msg_data);
1284:
1285:

Line 1289: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

1285:
1286: -- LOG MESSAGE TO FILE
1287: /*
1288: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1289: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1290: END LOOP;
1291: */
1292: logerror;
1293: FND_MESSAGE.CLEAR;

Line 1321: x_return_status := FND_API.G_RET_STS_SUCCESS;

1317: IS
1318: l_request_id NUMBER := NULL;
1319:
1320: BEGIN
1321: x_return_status := FND_API.G_RET_STS_SUCCESS;
1322:
1323:
1324: -- CALL THE PROCEDURE THAT IS RUN AS A CONCURRENT REQUEST
1325: l_request_id := fnd_request.submit_request('AR','ARHCPRLA','Copy Rel Type and All Rels',

Line 1337: RAISE FND_API.G_EXC_ERROR;

1333: IF l_request_id = 0
1334: THEN
1335: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1336: FND_MSG_PUB.ADD;
1337: RAISE FND_API.G_EXC_ERROR;
1338: END IF;
1339:
1340: x_request_id := l_request_id;
1341:

Line 1346: x_return_status := FND_API.G_RET_STS_ERROR;

1342:
1343: EXCEPTION
1344: WHEN OTHERS
1345: THEN
1346: x_return_status := FND_API.G_RET_STS_ERROR;
1347: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1348: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_REL_TYPE_RELS_CONC');
1349: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1350: FND_MSG_PUB.ADD;

Line 1352: p_encoded => FND_API.G_FALSE,

1348: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_REL_TYPE_RELS_CONC');
1349: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1350: FND_MSG_PUB.ADD;
1351: FND_MSG_PUB.Count_And_Get(
1352: p_encoded => FND_API.G_FALSE,
1353: p_count => x_msg_count,
1354: p_data => x_msg_data);
1355:
1356: END submit_copy_rel_type_rels_conc ;

Line 1408: x_return_status := FND_API.G_RET_STS_SUCCESS;

1404:
1405: G_RET_CODE := TRUE;
1406:
1407: -- return is status unless otherwise changed
1408: x_return_status := FND_API.G_RET_STS_SUCCESS;
1409:
1410: log('-------------------------------------------');
1411: log('Passed in Source Rel Type is ' || p_source_rel_type );
1412: log('Passed in Destination Rel Type is ' || p_dest_rel_type );

Line 1430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1426:
1427: END LOOP;
1428:
1429: -- RAISE HELL WHEN return status is not success
1430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1431: THEN
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: END IF;
1434:

Line 1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1428:
1429: -- RAISE HELL WHEN return status is not success
1430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1431: THEN
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: END IF;
1434:
1435: -- COPY THE HIERARCHY (STARTING FROM P AND GOING BELOW) FROM SOURCE TO DESTINATION,
1436: -- BY CREATING ALL NECESSARY RELATIONSHIPS IN B.

Line 1446: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1442: -- If G_RET_CODE IS FALSE, then it means that some relationships could not be created.
1443: -- Error out the concurrent program and rollback all changes.
1444: /*
1445: -- RAISE HELL WHEN return status is not success
1446: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1447: THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;
1450: */

Line 1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1444: /*
1445: -- RAISE HELL WHEN return status is not success
1446: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1447: THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;
1450: */
1451: IF G_RET_CODE = FALSE THEN
1452: rollback to copy_hierarchy;

Line 1461: x_return_status := FND_API.G_RET_STS_ERROR;

1457: WHEN OTHERS
1458: THEN
1459: -- rollback if you get this far
1460: rollback to copy_hierarchy ;
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1463: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_HIERARCHY');
1464: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1465: FND_MSG_PUB.ADD;

Line 1467: p_encoded => FND_API.G_FALSE,

1463: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_HIERARCHY');
1464: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1465: FND_MSG_PUB.ADD;
1466: FND_MSG_PUB.Count_And_Get(
1467: p_encoded => FND_API.G_FALSE,
1468: p_count => x_msg_count,
1469: p_data => x_msg_data);
1470:
1471: -- LOG MESSAGE TO FILE

Line 1474: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

1470:
1471: -- LOG MESSAGE TO FILE
1472: /*
1473: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1474: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1475: END LOOP;
1476: */
1477: logerror;
1478:

Line 1505: x_return_status := FND_API.G_RET_STS_SUCCESS;

1501: IS
1502: l_request_id NUMBER := NULL;
1503:
1504: BEGIN
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;
1506:
1507:
1508:
1509: -- CALL THE PROCEDURE THAT IS RUN AS A CONCURRENT REQUEST

Line 1519: RAISE FND_API.G_EXC_ERROR;

1515: IF l_request_id = 0
1516: THEN
1517: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1518: FND_MSG_PUB.ADD;
1519: RAISE FND_API.G_EXC_ERROR;
1520: END IF;
1521:
1522: x_request_id := l_request_id;
1523:

Line 1528: x_return_status := FND_API.G_RET_STS_ERROR;

1524:
1525: EXCEPTION
1526: WHEN OTHERS
1527: THEN
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1530: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_HIERARCHY_CONC');
1531: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1532: FND_MSG_PUB.ADD;

Line 1534: p_encoded => FND_API.G_FALSE,

1530: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_HIERARCHY_CONC');
1531: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1532: FND_MSG_PUB.ADD;
1533: FND_MSG_PUB.Count_And_Get(
1534: p_encoded => FND_API.G_FALSE,
1535: p_count => x_msg_count,
1536: p_data => x_msg_data);
1537: END submit_copy_hierarchy_conc ;
1538:

Line 1615: x_return_status := FND_API.G_RET_STS_SUCCESS;

1611: -- save and be ready to rollback
1612: savepoint convert_rel_type ;
1613:
1614: -- initialize return status
1615: x_return_status := FND_API.G_RET_STS_SUCCESS;
1616:
1617: -- Bug 3615970: point 2
1618: -- clean up hierarchy nodes table
1619: DELETE hz_hierarchy_nodes

Line 1703: p_init_msg_list => FND_API.G_FALSE,

1699: l_hierarchy_rec.relationship_id := i_relationship_id(i);
1700: l_hierarchy_rec.status := NVL(i_status(i), 'A');
1701:
1702: HZ_HIERARCHY_PUB.create_link(
1703: p_init_msg_list => FND_API.G_FALSE,
1704: p_hierarchy_node_rec => l_hierarchy_rec,
1705: x_return_status => l_return_status,
1706: x_msg_count => l_msg_count,
1707: x_msg_data => l_msg_data

Line 1711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1707: x_msg_data => l_msg_data
1708: );
1709:
1710: -- RAISE HELL WHEN return status is not success
1711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1712: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');
1713: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_HIERARCHY_PUB.CREATE_LINK');
1714: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1715: FND_MSG_PUB.ADD;

Line 1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1712: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');
1713: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_HIERARCHY_PUB.CREATE_LINK');
1714: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1717:
1718: ROLLBACK TO convert_rel_type ;
1719:
1720: l_create_hierarchy_link := 'N';

Line 1815: x_return_status := FND_API.G_RET_STS_ERROR;

1811: WHEN OTHERS THEN
1812: -- rollback if this happens
1813: rollback to convert_rel_type ;
1814:
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');
1817: FND_MESSAGE.SET_TOKEN('PROC' ,'CONVERT_REL_TYPE');
1818: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1819: FND_MSG_PUB.ADD;

Line 1821: p_encoded => FND_API.G_FALSE,

1817: FND_MESSAGE.SET_TOKEN('PROC' ,'CONVERT_REL_TYPE');
1818: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1819: FND_MSG_PUB.ADD;
1820: FND_MSG_PUB.Count_And_Get(
1821: p_encoded => FND_API.G_FALSE,
1822: p_count => l_msg_count,
1823: p_data => l_msg_data);
1824:
1825: logerror;

Line 1851: x_return_status := FND_API.G_RET_STS_SUCCESS;

1847: IS
1848: l_request_id NUMBER := NULL;
1849:
1850: BEGIN
1851: x_return_status := FND_API.G_RET_STS_SUCCESS;
1852:
1853:
1854:
1855: -- CALL THE PROCEDURE THAT IS RUN AS A CONCURRENT REQUEST

Line 1868: RAISE FND_API.G_EXC_ERROR;

1864: IF l_request_id = 0
1865: THEN
1866: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1867: FND_MSG_PUB.ADD;
1868: RAISE FND_API.G_EXC_ERROR;
1869: END IF;
1870:
1871: x_request_id := l_request_id;
1872:

Line 1876: x_return_status := FND_API.G_RET_STS_ERROR;

1872:
1873: EXCEPTION
1874: WHEN OTHERS
1875: THEN
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');
1878: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_CONVERT_REL_TYPE_CONC');
1879: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1880: FND_MSG_PUB.ADD;

Line 1882: p_encoded => FND_API.G_FALSE,

1878: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_CONVERT_REL_TYPE_CONC');
1879: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1880: FND_MSG_PUB.ADD;
1881: FND_MSG_PUB.Count_And_Get(
1882: p_encoded => FND_API.G_FALSE,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data);
1885:
1886: END submit_convert_rel_type_conc ;