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

Line 113: x_return_status := FND_API.G_RET_STS_SUCCESS;

109:
110: SAVEPOINT sp_populate_prof_mat_req;
111:
112: -- Initialize API return status to success
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: -- Check Whether profile exist or not
116:
117: OPEN get_profile_ident_seqs(p_mr_header_id);

Line 330: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

326:
327: EXCEPTION
328: WHEN OTHERS THEN
329: ROLLBACK TO sp_populate_prof_mat_req;
330: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331:
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

Line 338: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
335: p_procedure_name => 'POPULATE_PROF_MAT_REQ',
336: p_error_text => SUBSTR(SQLERRM,1,240));
337: END IF;
338: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => X_msg_data);
341:
342:

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445:
446: SAVEPOINT sp_populate_prof_res_req;
447:
448: -- Initialize API return status to success
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: -- Check Whether profile exist or not
452:
453: OPEN get_profile_ident_seqs(p_mr_header_id);

Line 654: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

650:
651: EXCEPTION
652: WHEN OTHERS THEN
653: ROLLBACK TO sp_populate_prof_res_req;
654: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655:
656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
657: THEN
658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

Line 662: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
659: p_procedure_name => 'POPULATE_PROF_RES_REQ',
660: p_error_text => SUBSTR(SQLERRM,1,240));
661: END IF;
662: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => X_msg_data);
665:
666: END populate_prof_res_req;

Line 680: p_nr_prof_est_rec.cmro_resource_type <> FND_API.G_MISS_NUM ) THEN

676:
677: BEGIN
678:
679: IF ( p_nr_prof_est_rec.cmro_resource_type IS NOT NULL AND
680: p_nr_prof_est_rec.cmro_resource_type <> FND_API.G_MISS_NUM ) THEN
681: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.cmro_resource_type;
682: l_record_identifier := l_record_identifier || ' - ';
683: END IF;
684:

Line 686: p_nr_prof_est_rec.cmro_resource_name <> FND_API.G_MISS_CHAR ) THEN

682: l_record_identifier := l_record_identifier || ' - ';
683: END IF;
684:
685: IF ( p_nr_prof_est_rec.cmro_resource_name IS NOT NULL AND
686: p_nr_prof_est_rec.cmro_resource_name <> FND_API.G_MISS_CHAR ) THEN
687: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.cmro_resource_name;
688: l_record_identifier := l_record_identifier || ' - ';
689: END IF;
690:

Line 692: p_nr_prof_est_rec.inventory_item <> FND_API.G_MISS_CHAR ) THEN

688: l_record_identifier := l_record_identifier || ' - ';
689: END IF;
690:
691: IF ( p_nr_prof_est_rec.inventory_item IS NOT NULL AND
692: p_nr_prof_est_rec.inventory_item <> FND_API.G_MISS_CHAR ) THEN
693: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.inventory_item;
694: l_record_identifier := l_record_identifier || ' - ';
695: IF ( p_nr_prof_est_rec.uom IS NOT NULL AND
696: p_nr_prof_est_rec.uom <> FND_API.G_MISS_CHAR ) THEN

Line 696: p_nr_prof_est_rec.uom <> FND_API.G_MISS_CHAR ) THEN

692: p_nr_prof_est_rec.inventory_item <> FND_API.G_MISS_CHAR ) THEN
693: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.inventory_item;
694: l_record_identifier := l_record_identifier || ' - ';
695: IF ( p_nr_prof_est_rec.uom IS NOT NULL AND
696: p_nr_prof_est_rec.uom <> FND_API.G_MISS_CHAR ) THEN
697: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.uom;
698: END IF;
699: l_record_identifier := l_record_identifier || ' - ';
700: END IF;

Line 703: p_nr_prof_est_rec.analysis_qty <> FND_API.G_MISS_NUM ) THEN

699: l_record_identifier := l_record_identifier || ' - ';
700: END IF;
701:
702: /*IF ( p_nr_prof_est_rec.analysis_qty IS NOT NULL AND
703: p_nr_prof_est_rec.analysis_qty <> FND_API.G_MISS_NUM ) THEN
704: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.analysis_qty;
705: END IF;
706:
707: l_record_identifier := l_record_identifier || ' - ';

Line 710: p_nr_prof_est_rec.required_qty <> FND_API.G_MISS_NUM ) THEN

706:
707: l_record_identifier := l_record_identifier || ' - ';
708:
709: IF ( p_nr_prof_est_rec.required_qty IS NOT NULL AND
710: p_nr_prof_est_rec.required_qty <> FND_API.G_MISS_NUM ) THEN
711: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.required_qty;
712: END IF;
713:
714: l_record_identifier := l_record_identifier || ' - ';*/

Line 717: p_nr_prof_est_rec.stage_type <> FND_API.G_MISS_CHAR ) THEN

713:
714: l_record_identifier := l_record_identifier || ' - ';*/
715:
716: IF ( p_nr_prof_est_rec.stage_type IS NOT NULL AND
717: p_nr_prof_est_rec.stage_type <> FND_API.G_MISS_CHAR ) THEN
718: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.stage_type;
719: END IF;
720:
721: l_record_identifier := l_record_identifier || ' - ';

Line 724: p_nr_prof_est_rec.demantra_updated_date <> FND_API.G_MISS_DATE ) THEN

720:
721: l_record_identifier := l_record_identifier || ' - ';
722:
723: IF ( p_nr_prof_est_rec.demantra_updated_date IS NOT NULL AND
724: p_nr_prof_est_rec.demantra_updated_date <> FND_API.G_MISS_DATE ) THEN
725: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.demantra_updated_date;
726: END IF;
727:
728: l_record_identifier := l_record_identifier || ' - ';

Line 731: p_nr_prof_est_rec.fleet_name <> FND_API.G_MISS_CHAR ) THEN

727:
728: l_record_identifier := l_record_identifier || ' - ';
729:
730: IF ( p_nr_prof_est_rec.fleet_name IS NOT NULL AND
731: p_nr_prof_est_rec.fleet_name <> FND_API.G_MISS_CHAR ) THEN
732: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.fleet_name;
733: END IF;
734:
735: l_record_identifier := l_record_identifier || ' - ';

Line 738: p_nr_prof_est_rec.operating_org_name <> FND_API.G_MISS_CHAR ) THEN

734:
735: l_record_identifier := l_record_identifier || ' - ';
736:
737: IF ( p_nr_prof_est_rec.operating_org_name IS NOT NULL AND
738: p_nr_prof_est_rec.operating_org_name <> FND_API.G_MISS_CHAR ) THEN
739: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.operating_org_name;
740: END IF;
741:
742: l_record_identifier := l_record_identifier || ' - ';

Line 745: p_nr_prof_est_rec.operations_type <> FND_API.G_MISS_CHAR ) THEN

741:
742: l_record_identifier := l_record_identifier || ' - ';
743:
744: IF ( p_nr_prof_est_rec.operations_type IS NOT NULL AND
745: p_nr_prof_est_rec.operations_type <> FND_API.G_MISS_CHAR ) THEN
746: l_record_identifier := l_record_identifier || p_nr_prof_est_rec.operations_type;
747: END IF;
748:
749: RETURN l_record_identifier;

Line 849: x_return_status := FND_API.G_RET_STS_SUCCESS;

845: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
846: END IF;
847:
848: -- Initialize API return status to success
849: x_return_status := FND_API.G_RET_STS_SUCCESS;
850:
851: -- Standard Start of API savepoint
852: SAVEPOINT Validate_prof_details_sp;
853:

Line 887: ELSIF (p_x_nr_prof_est_tbl(i).cmro_resource_id IS NOT NULL AND p_x_nr_prof_est_tbl(i).cmro_resource_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).cmro_resource_name IS NULL)

883: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
884: FND_MSG_PUB.add;
885: END IF;
886: CLOSE get_resource_id;
887: ELSIF (p_x_nr_prof_est_tbl(i).cmro_resource_id IS NOT NULL AND p_x_nr_prof_est_tbl(i).cmro_resource_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).cmro_resource_name IS NULL)
888: THEN
889: OPEN check_resource_id(p_x_nr_prof_est_tbl(i).cmro_resource_id);
890: FETCH check_resource_id into l_dummy;
891: IF(check_resource_id%NOTFOUND)

Line 898: ELSIF ( (p_x_nr_prof_est_tbl(i).cmro_resource_id IS NULL OR p_x_nr_prof_est_tbl(i).cmro_resource_id = FND_API.G_MISS_NUM)

894: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
895: FND_MSG_PUB.add;
896: END IF;
897: CLOSE check_resource_id;
898: ELSIF ( (p_x_nr_prof_est_tbl(i).cmro_resource_id IS NULL OR p_x_nr_prof_est_tbl(i).cmro_resource_id = FND_API.G_MISS_NUM)
899: AND (p_x_nr_prof_est_tbl(i).cmro_resource_name IS NULL OR p_x_nr_prof_est_tbl(i).cmro_resource_name = FND_API.G_MISS_CHAR)
900: AND p_x_nr_prof_est_tbl(i).profile_detail_type = G_RESOURCE)
901: THEN
902: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_RES_MAND' );

Line 899: AND (p_x_nr_prof_est_tbl(i).cmro_resource_name IS NULL OR p_x_nr_prof_est_tbl(i).cmro_resource_name = FND_API.G_MISS_CHAR)

895: FND_MSG_PUB.add;
896: END IF;
897: CLOSE check_resource_id;
898: ELSIF ( (p_x_nr_prof_est_tbl(i).cmro_resource_id IS NULL OR p_x_nr_prof_est_tbl(i).cmro_resource_id = FND_API.G_MISS_NUM)
899: AND (p_x_nr_prof_est_tbl(i).cmro_resource_name IS NULL OR p_x_nr_prof_est_tbl(i).cmro_resource_name = FND_API.G_MISS_CHAR)
900: AND p_x_nr_prof_est_tbl(i).profile_detail_type = G_RESOURCE)
901: THEN
902: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_RES_MAND' );
903: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );

Line 921: ELSIF ( p_x_nr_prof_est_tbl(i).inventory_item_id IS NOT NULL AND p_x_nr_prof_est_tbl(i).inventory_item_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).inventory_item IS NULL)

917: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
918: FND_MSG_PUB.add;
919: END IF;
920: CLOSE get_inventory_item_id;
921: ELSIF ( p_x_nr_prof_est_tbl(i).inventory_item_id IS NOT NULL AND p_x_nr_prof_est_tbl(i).inventory_item_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).inventory_item IS NULL)
922: THEN
923: OPEN check_inventory_item_id(p_x_nr_prof_est_tbl(i).inventory_item_id);
924: FETCH check_inventory_item_id into l_dummy;
925: IF(check_inventory_item_id%NOTFOUND)

Line 932: ELSIF ( (p_x_nr_prof_est_tbl(i).inventory_item_id IS NULL OR p_x_nr_prof_est_tbl(i).inventory_item_id = FND_API.G_MISS_NUM)

928: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
929: FND_MSG_PUB.add;
930: END IF;
931: CLOSE check_inventory_item_id;
932: ELSIF ( (p_x_nr_prof_est_tbl(i).inventory_item_id IS NULL OR p_x_nr_prof_est_tbl(i).inventory_item_id = FND_API.G_MISS_NUM)
933: AND (p_x_nr_prof_est_tbl(i).inventory_item IS NULL OR p_x_nr_prof_est_tbl(i).inventory_item = FND_API.G_MISS_CHAR)
934: AND p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
935: THEN
936: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_ITEM_MAND' );

Line 933: AND (p_x_nr_prof_est_tbl(i).inventory_item IS NULL OR p_x_nr_prof_est_tbl(i).inventory_item = FND_API.G_MISS_CHAR)

929: FND_MSG_PUB.add;
930: END IF;
931: CLOSE check_inventory_item_id;
932: ELSIF ( (p_x_nr_prof_est_tbl(i).inventory_item_id IS NULL OR p_x_nr_prof_est_tbl(i).inventory_item_id = FND_API.G_MISS_NUM)
933: AND (p_x_nr_prof_est_tbl(i).inventory_item IS NULL OR p_x_nr_prof_est_tbl(i).inventory_item = FND_API.G_MISS_CHAR)
934: AND p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
935: THEN
936: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_ITEM_MAND' );
937: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );

Line 956: ELSIF ( p_x_nr_prof_est_tbl(i).uom_code IS NOT NULL AND p_x_nr_prof_est_tbl(i).uom_code <> FND_API.G_MISS_CHAR AND p_x_nr_prof_est_tbl(i).uom IS NULL)

952: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
953: FND_MSG_PUB.add;
954: END IF;
955: CLOSE get_uom_code;
956: ELSIF ( p_x_nr_prof_est_tbl(i).uom_code IS NOT NULL AND p_x_nr_prof_est_tbl(i).uom_code <> FND_API.G_MISS_CHAR AND p_x_nr_prof_est_tbl(i).uom IS NULL)
957: THEN
958: OPEN check_uom_code(p_x_nr_prof_est_tbl(i).uom_code);
959: FETCH check_uom_code into l_dummy;
960: IF(check_uom_code%NOTFOUND)

Line 968: ELSIF ( (p_x_nr_prof_est_tbl(i).uom_code IS NULL OR p_x_nr_prof_est_tbl(i).uom_code = FND_API.G_MISS_CHAR)

964: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
965: FND_MSG_PUB.add;
966: END IF;
967: CLOSE check_uom_code;
968: ELSIF ( (p_x_nr_prof_est_tbl(i).uom_code IS NULL OR p_x_nr_prof_est_tbl(i).uom_code = FND_API.G_MISS_CHAR)
969: AND (p_x_nr_prof_est_tbl(i).uom IS NULL OR p_x_nr_prof_est_tbl(i).uom = FND_API.G_MISS_CHAR)
970: AND p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
971: THEN
972: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UOM_NULL' );

Line 969: AND (p_x_nr_prof_est_tbl(i).uom IS NULL OR p_x_nr_prof_est_tbl(i).uom = FND_API.G_MISS_CHAR)

965: FND_MSG_PUB.add;
966: END IF;
967: CLOSE check_uom_code;
968: ELSIF ( (p_x_nr_prof_est_tbl(i).uom_code IS NULL OR p_x_nr_prof_est_tbl(i).uom_code = FND_API.G_MISS_CHAR)
969: AND (p_x_nr_prof_est_tbl(i).uom IS NULL OR p_x_nr_prof_est_tbl(i).uom = FND_API.G_MISS_CHAR)
970: AND p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
971: THEN
972: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UOM_NULL' );
973: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );

Line 980: p_x_nr_prof_est_tbl(i).stage_type_code <> FND_API.G_MISS_CHAR ) OR

976:
977: -- Stage Type Validation
978: -- Get the Stage Type Code or Meaning and validate
979: IF ( ( p_x_nr_prof_est_tbl(i).stage_type_code IS NOT NULL AND
980: p_x_nr_prof_est_tbl(i).stage_type_code <> FND_API.G_MISS_CHAR ) OR
981: ( p_x_nr_prof_est_tbl(i).stage_type IS NOT NULL AND
982: p_x_nr_prof_est_tbl(i).stage_type <> FND_API.G_MISS_CHAR ) )
983: THEN
984: AHL_RM_ROUTE_UTIL.validate_lookup

Line 982: p_x_nr_prof_est_tbl(i).stage_type <> FND_API.G_MISS_CHAR ) )

978: -- Get the Stage Type Code or Meaning and validate
979: IF ( ( p_x_nr_prof_est_tbl(i).stage_type_code IS NOT NULL AND
980: p_x_nr_prof_est_tbl(i).stage_type_code <> FND_API.G_MISS_CHAR ) OR
981: ( p_x_nr_prof_est_tbl(i).stage_type IS NOT NULL AND
982: p_x_nr_prof_est_tbl(i).stage_type <> FND_API.G_MISS_CHAR ) )
983: THEN
984: AHL_RM_ROUTE_UTIL.validate_lookup
985: (
986: x_return_status => l_return_status,

Line 993: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

989: p_lookup_meaning => p_x_nr_prof_est_tbl(i).stage_type,
990: p_x_lookup_code => p_x_nr_prof_est_tbl(i).stage_type_code
991: );
992:
993: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
994: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
995: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_DEP_TYPE' );
996: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
997: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_TOO_MANY_STG_TYP' );

Line 1003: p_x_nr_prof_est_tbl(i).stage_type = FND_API.G_MISS_CHAR )

999: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1000: END IF;
1001:
1002: IF ( p_x_nr_prof_est_tbl(i).stage_type IS NULL OR
1003: p_x_nr_prof_est_tbl(i).stage_type = FND_API.G_MISS_CHAR )
1004: THEN
1005: p_x_nr_prof_est_tbl(i).stage_type := p_x_nr_prof_est_tbl(i).stage_type_code;
1006: FND_MESSAGE.set_token( 'FIELD', p_x_nr_prof_est_tbl(i).stage_type );
1007: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );

Line 1019: IF ( (p_x_nr_prof_est_tbl(i).fleet_header_id IS NULL) AND p_x_nr_prof_est_tbl(i).fleet_name IS NOT NULL AND p_x_nr_prof_est_tbl(i).fleet_name <> FND_API.G_MISS_CHAR )

1015:
1016: -- Fleet Id Validation
1017: -- Get the Fleet id for a given Fleet Name and
1018: -- Also validate the fleet id is exist or not if Fleet id id given
1019: IF ( (p_x_nr_prof_est_tbl(i).fleet_header_id IS NULL) AND p_x_nr_prof_est_tbl(i).fleet_name IS NOT NULL AND p_x_nr_prof_est_tbl(i).fleet_name <> FND_API.G_MISS_CHAR )
1020: THEN
1021: OPEN get_fleet_id(p_x_nr_prof_est_tbl(i).fleet_name);
1022: FETCH get_fleet_id into p_x_nr_prof_est_tbl(i).fleet_header_id;
1023: IF(get_fleet_id%NOTFOUND)

Line 1030: ELSIF ( (p_x_nr_prof_est_tbl(i).fleet_header_id IS NOT NULL) AND p_x_nr_prof_est_tbl(i).fleet_header_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).fleet_name IS NULL)

1026: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
1027: FND_MSG_PUB.add;
1028: END IF;
1029: CLOSE get_fleet_id;
1030: ELSIF ( (p_x_nr_prof_est_tbl(i).fleet_header_id IS NOT NULL) AND p_x_nr_prof_est_tbl(i).fleet_header_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).fleet_name IS NULL)
1031: THEN
1032: OPEN check_fleet_id(p_x_nr_prof_est_tbl(i).fleet_header_id);
1033: FETCH check_fleet_id into l_dummy;
1034: IF(check_fleet_id%NOTFOUND)

Line 1046: IF ( (p_x_nr_prof_est_tbl(i).operating_org_id IS NULL) AND p_x_nr_prof_est_tbl(i).operating_org_name IS NOT NULL AND p_x_nr_prof_est_tbl(i).operating_org_name <> FND_API.G_MISS_CHAR)

1042:
1043: -- Operating Organization Validation
1044: -- Get the Operating org id for a given Operating org name
1045: -- And also validate If Operating org id is given it exist or not
1046: IF ( (p_x_nr_prof_est_tbl(i).operating_org_id IS NULL) AND p_x_nr_prof_est_tbl(i).operating_org_name IS NOT NULL AND p_x_nr_prof_est_tbl(i).operating_org_name <> FND_API.G_MISS_CHAR)
1047: THEN
1048: OPEN get_operating_org_id(p_x_nr_prof_est_tbl(i).operating_org_name);
1049: FETCH get_operating_org_id into p_x_nr_prof_est_tbl(i).operating_org_id;
1050: IF(get_operating_org_id%NOTFOUND)

Line 1057: ELSIF ( (p_x_nr_prof_est_tbl(i).operating_org_id IS NOT NULL) AND p_x_nr_prof_est_tbl(i).operating_org_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).operating_org_name IS NULL)

1053: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
1054: FND_MSG_PUB.add;
1055: END IF;
1056: CLOSE get_operating_org_id;
1057: ELSIF ( (p_x_nr_prof_est_tbl(i).operating_org_id IS NOT NULL) AND p_x_nr_prof_est_tbl(i).operating_org_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).operating_org_name IS NULL)
1058: THEN
1059: OPEN check_operating_org_id(p_x_nr_prof_est_tbl(i).operating_org_id);
1060: FETCH check_operating_org_id into l_dummy;
1061: IF(check_operating_org_id%NOTFOUND)

Line 1073: p_x_nr_prof_est_tbl(i).operations_type_code <> FND_API.G_MISS_CHAR ) OR

1069:
1070: -- Operations Type Validation
1071: -- Get the operations Type Code or Meaning and validate
1072: IF ( ( p_x_nr_prof_est_tbl(i).operations_type_code IS NOT NULL AND
1073: p_x_nr_prof_est_tbl(i).operations_type_code <> FND_API.G_MISS_CHAR ) OR
1074: ( p_x_nr_prof_est_tbl(i).operations_type IS NOT NULL AND
1075: p_x_nr_prof_est_tbl(i).operations_type <> FND_API.G_MISS_CHAR ) )
1076: THEN
1077: AHL_RM_ROUTE_UTIL.validate_lookup

Line 1075: p_x_nr_prof_est_tbl(i).operations_type <> FND_API.G_MISS_CHAR ) )

1071: -- Get the operations Type Code or Meaning and validate
1072: IF ( ( p_x_nr_prof_est_tbl(i).operations_type_code IS NOT NULL AND
1073: p_x_nr_prof_est_tbl(i).operations_type_code <> FND_API.G_MISS_CHAR ) OR
1074: ( p_x_nr_prof_est_tbl(i).operations_type IS NOT NULL AND
1075: p_x_nr_prof_est_tbl(i).operations_type <> FND_API.G_MISS_CHAR ) )
1076: THEN
1077: AHL_RM_ROUTE_UTIL.validate_lookup
1078: (
1079: x_return_status => l_return_status,

Line 1086: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

1082: p_lookup_meaning => p_x_nr_prof_est_tbl(i).operations_type,
1083: p_x_lookup_code => p_x_nr_prof_est_tbl(i).operations_type_code
1084: );
1085:
1086: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1087: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
1088: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_DEP_TYPE' );
1089: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
1090: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_TOO_MANY_OPR_TYP' );

Line 1096: p_x_nr_prof_est_tbl(i).operations_type = FND_API.G_MISS_CHAR )

1092: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1093: END IF;
1094:
1095: IF ( p_x_nr_prof_est_tbl(i).operations_type IS NULL OR
1096: p_x_nr_prof_est_tbl(i).operations_type = FND_API.G_MISS_CHAR )
1097: THEN
1098: p_x_nr_prof_est_tbl(i).operations_type := p_x_nr_prof_est_tbl(i).operations_type_code;
1099: FND_MESSAGE.set_token( 'FIELD', p_x_nr_prof_est_tbl(i).operations_type);
1100: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );

Line 1126: IF ( p_x_nr_prof_est_tbl(i).required_qty IS NULL OR p_x_nr_prof_est_tbl(i).required_qty = FND_API.G_MISS_NUM )

1122: -- Validation for Required Quantity
1123: -- Required Quanity is mandatory, if record is updated or created
1124: IF( p_x_nr_prof_est_tbl(i).DML_OPERATION = 'C' OR p_x_nr_prof_est_tbl(i).DML_OPERATION = 'U')
1125: THEN
1126: IF ( p_x_nr_prof_est_tbl(i).required_qty IS NULL OR p_x_nr_prof_est_tbl(i).required_qty = FND_API.G_MISS_NUM )
1127: THEN
1128: IF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_RESOURCE)
1129: THEN
1130: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_REQ_HRS_MAND' );

Line 1189: RAISE FND_API.G_EXC_ERROR;

1185:
1186: l_msg_count := FND_MSG_PUB.count_msg;
1187: IF l_msg_count > 0 THEN
1188: x_msg_count := l_msg_count;
1189: RAISE FND_API.G_EXC_ERROR;
1190: END IF;
1191:
1192: -- End of API
1193: IF G_DEBUG = 'Y' THEN

Line 1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1194: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End of private API:' );
1195: END IF;
1196:
1197: EXCEPTION
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: ROLLBACK TO Validate_prof_details_sp;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1202: p_count => x_msg_count,

Line 1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1196:
1197: EXCEPTION
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: ROLLBACK TO Validate_prof_details_sp;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data);
1204:

Line 1201: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1197: EXCEPTION
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: ROLLBACK TO Validate_prof_details_sp;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data);
1204:
1205: WHEN FND_API.G_EXC_ERROR THEN

Line 1205: WHEN FND_API.G_EXC_ERROR THEN

1201: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data);
1204:
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: ROLLBACK TO Validate_prof_details_sp;
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1209: p_count => x_msg_count,

Line 1207: x_return_status := FND_API.G_RET_STS_ERROR;

1203: p_data => x_msg_data);
1204:
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: ROLLBACK TO Validate_prof_details_sp;
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1209: p_count => x_msg_count,
1210: p_data => X_msg_data);
1211: WHEN OTHERS THEN

Line 1208: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1204:
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: ROLLBACK TO Validate_prof_details_sp;
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1209: p_count => x_msg_count,
1210: p_data => X_msg_data);
1211: WHEN OTHERS THEN
1212: ROLLBACK TO Validate_prof_details_sp;

Line 1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1209: p_count => x_msg_count,
1210: p_data => X_msg_data);
1211: WHEN OTHERS THEN
1212: ROLLBACK TO Validate_prof_details_sp;
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214:
1215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1216: THEN
1217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

Line 1221: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
1218: p_procedure_name => 'VALIDATE_PROF_DETAILS',
1219: p_error_text => SUBSTR(SQLERRM,1,240));
1220: END IF;
1221: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1222: p_count => x_msg_count,
1223: p_data => X_msg_data);
1224:
1225: END Validate_prof_details;

Line 1232: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1228:
1229: PROCEDURE add_details_to_prof
1230: (
1231: p_api_version IN NUMBER,
1232: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1233: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1235: x_return_status OUT NOCOPY VARCHAR2,
1236: x_msg_count OUT NOCOPY NUMBER,

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

1229: PROCEDURE add_details_to_prof
1230: (
1231: p_api_version IN NUMBER,
1232: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1233: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1235: x_return_status OUT NOCOPY VARCHAR2,
1236: x_msg_count OUT NOCOPY NUMBER,
1237: x_msg_data OUT NOCOPY VARCHAR2,

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

1230: (
1231: p_api_version IN NUMBER,
1232: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1233: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1235: x_return_status OUT NOCOPY VARCHAR2,
1236: x_msg_count OUT NOCOPY NUMBER,
1237: x_msg_data OUT NOCOPY VARCHAR2,
1238: p_x_nr_prof_est_tbl IN OUT NOCOPY nr_prof_est_tbl_type

Line 1302: x_return_status := FND_API.G_RET_STS_SUCCESS;

1298: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
1299: END IF;
1300:
1301: -- Initialize API return status to success
1302: x_return_status := FND_API.G_RET_STS_SUCCESS;
1303:
1304: -- Standard Start of API savepoint
1305: SAVEPOINT add_details_to_prof_sp;
1306:

Line 1308: IF NOT FND_API.compatible_api_call

1304: -- Standard Start of API savepoint
1305: SAVEPOINT add_details_to_prof_sp;
1306:
1307: -- Standard call to check for call compatibility.
1308: IF NOT FND_API.compatible_api_call
1309: (
1310: l_api_version,
1311: p_api_version,
1312: l_api_name,

Line 1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1312: l_api_name,
1313: G_PKG_NAME
1314: )
1315: THEN
1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1317: END IF;
1318:
1319: -- Initialize message list if p_init_msg_list is set to TRUE.
1320: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 1320: IF FND_API.to_boolean( p_init_msg_list ) THEN

1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1317: END IF;
1318:
1319: -- Initialize message list if p_init_msg_list is set to TRUE.
1320: IF FND_API.to_boolean( p_init_msg_list ) THEN
1321: FND_MSG_PUB.initialize;
1322: END IF;
1323:
1324: /* Call the Validate _profile details procedure for all validations*/

Line 1333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1329: x_msg_data => l_msg_data ,
1330: p_x_nr_prof_est_tbl => p_x_nr_prof_est_tbl
1331: );
1332:
1333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;

Line 1334: RAISE FND_API.G_EXC_ERROR;

1330: p_x_nr_prof_est_tbl => p_x_nr_prof_est_tbl
1331: );
1332:
1333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338:

Line 1335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1331: );
1332:
1333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338:
1339: IF p_x_nr_prof_est_tbl.count > 0

Line 1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1332:
1333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338:
1339: IF p_x_nr_prof_est_tbl.count > 0
1340: THEN

Line 1703: RAISE FND_API.G_EXC_ERROR;

1699: -- Get all the error messages if any and raise the appropriate Exception
1700: l_msg_count := FND_MSG_PUB.count_msg;
1701: IF l_msg_count > 0 THEN
1702: x_msg_count := l_msg_count;
1703: RAISE FND_API.G_EXC_ERROR;
1704: END IF;
1705:
1706: END LOOP; -- Table Loop
1707:

Line 1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1712: END IF;
1713:
1714:
1715: EXCEPTION
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: ROLLBACK TO add_details_to_prof_sp;
1718: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1719: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1720: p_count => x_msg_count,

Line 1718: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1714:
1715: EXCEPTION
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: ROLLBACK TO add_details_to_prof_sp;
1718: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1719: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1720: p_count => x_msg_count,
1721: p_data => x_msg_data);
1722:

Line 1719: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1715: EXCEPTION
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: ROLLBACK TO add_details_to_prof_sp;
1718: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1719: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1720: p_count => x_msg_count,
1721: p_data => x_msg_data);
1722:
1723: WHEN FND_API.G_EXC_ERROR THEN

Line 1723: WHEN FND_API.G_EXC_ERROR THEN

1719: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1720: p_count => x_msg_count,
1721: p_data => x_msg_data);
1722:
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: ROLLBACK TO add_details_to_prof_sp;
1725: X_return_status := FND_API.G_RET_STS_ERROR;
1726: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1727: p_count => x_msg_count,

Line 1725: X_return_status := FND_API.G_RET_STS_ERROR;

1721: p_data => x_msg_data);
1722:
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: ROLLBACK TO add_details_to_prof_sp;
1725: X_return_status := FND_API.G_RET_STS_ERROR;
1726: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1727: p_count => x_msg_count,
1728: p_data => X_msg_data);
1729: WHEN OTHERS THEN

Line 1726: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1722:
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: ROLLBACK TO add_details_to_prof_sp;
1725: X_return_status := FND_API.G_RET_STS_ERROR;
1726: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1727: p_count => x_msg_count,
1728: p_data => X_msg_data);
1729: WHEN OTHERS THEN
1730: ROLLBACK TO add_details_to_prof_sp;

Line 1731: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1727: p_count => x_msg_count,
1728: p_data => X_msg_data);
1729: WHEN OTHERS THEN
1730: ROLLBACK TO add_details_to_prof_sp;
1731: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732:
1733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1734: THEN
1735: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

Line 1739: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1735: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
1736: p_procedure_name => 'ADD_DETAILS_TO_PROF',
1737: p_error_text => SUBSTR(SQLERRM,1,240));
1738: END IF;
1739: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1740: p_count => x_msg_count,
1741: p_data => X_msg_data);
1742:
1743: END add_details_to_prof;

Line 1751: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1747:
1748: PROCEDURE process_nr_profile
1749: (
1750: p_api_version IN NUMBER,
1751: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1752: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1753: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1754: x_return_status OUT NOCOPY VARCHAR2,
1755: x_msg_count OUT NOCOPY NUMBER,

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

1748: PROCEDURE process_nr_profile
1749: (
1750: p_api_version IN NUMBER,
1751: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1752: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1753: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1754: x_return_status OUT NOCOPY VARCHAR2,
1755: x_msg_count OUT NOCOPY NUMBER,
1756: x_msg_data OUT NOCOPY VARCHAR2,

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

1749: (
1750: p_api_version IN NUMBER,
1751: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1752: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1753: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1754: x_return_status OUT NOCOPY VARCHAR2,
1755: x_msg_count OUT NOCOPY NUMBER,
1756: x_msg_data OUT NOCOPY VARCHAR2,
1757: p_x_nr_profile_header_rec IN OUT NOCOPY nr_prof_header_rec_type

Line 1829: x_return_status := FND_API.G_RET_STS_SUCCESS;

1825: l_mr_version_number NUMBER;
1826:
1827: BEGIN
1828: -- Initialize API return status to success
1829: x_return_status := FND_API.G_RET_STS_SUCCESS;
1830:
1831: -- Standard Start of API savepoint
1832: SAVEPOINT process_nr_profile_sp;
1833:

Line 1835: IF NOT FND_API.compatible_api_call

1831: -- Standard Start of API savepoint
1832: SAVEPOINT process_nr_profile_sp;
1833:
1834: -- Standard call to check for call compatibility.
1835: IF NOT FND_API.compatible_api_call
1836: (
1837: l_api_version,
1838: p_api_version,
1839: l_api_name,

Line 1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1839: l_api_name,
1840: G_PKG_NAME
1841: )
1842: THEN
1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844: END IF;
1845:
1846: -- Initialize message list if p_init_msg_list is set to TRUE.
1847: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 1847: IF FND_API.to_boolean( p_init_msg_list ) THEN

1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844: END IF;
1845:
1846: -- Initialize message list if p_init_msg_list is set to TRUE.
1847: IF FND_API.to_boolean( p_init_msg_list ) THEN
1848: FND_MSG_PUB.initialize;
1849: END IF;
1850:
1851: IF G_DEBUG = 'Y' THEN

Line 1975: RAISE FND_API.G_EXC_ERROR;

1971: -- Get all the error messages if any and raise the appropriate Exception
1972: l_msg_count := FND_MSG_PUB.count_msg;
1973: IF l_msg_count > 0 THEN
1974: x_msg_count := l_msg_count;
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:
1978:
1979: IF (p_x_nr_profile_header_rec.dml_operation = 'C')

Line 2100: RAISE FND_API.G_EXC_ERROR;

2096: IF(get_nr_profile_title%NOTFOUND)
2097: THEN
2098: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_HDR_IS_INVLD');
2099: FND_MSG_PUB.ADD;
2100: RAISE FND_API.G_EXC_ERROR;
2101: END IF;
2102: CLOSE get_nr_profile_title;
2103: ELSIF(p_x_nr_profile_header_rec.MR_TITLE IS NULL )
2104: THEN

Line 2107: RAISE FND_API.G_EXC_ERROR;

2103: ELSIF(p_x_nr_profile_header_rec.MR_TITLE IS NULL )
2104: THEN
2105: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_MR_TITL_MAND');
2106: FND_MSG_PUB.ADD;
2107: RAISE FND_API.G_EXC_ERROR;
2108: ELSE
2109: l_mr_title := p_x_nr_profile_header_rec.MR_TITLE;
2110: -- Get the Profile header ID for Given MR TITLE
2111: OPEN get_nr_profile_id(l_mr_title);

Line 2117: RAISE FND_API.G_EXC_ERROR;

2113: IF(get_nr_profile_id%NOTFOUND)
2114: THEN
2115: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_MR_TITL_INVLD');
2116: FND_MSG_PUB.ADD;
2117: RAISE FND_API.G_EXC_ERROR;
2118: END IF;
2119: CLOSE get_nr_profile_id;
2120: END IF;
2121:

Line 2154: IF FND_API.TO_BOOLEAN(p_commit) THEN

2150: END IF;
2151: CLOSE get_delete_mr_title;
2152: END IF; -- End DML Operation
2153:
2154: IF FND_API.TO_BOOLEAN(p_commit) THEN
2155: COMMIT;
2156: END IF;
2157:
2158: IF G_DEBUG='Y' THEN

Line 2163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2159: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );
2160: END IF;
2161:
2162: EXCEPTION
2163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2164: ROLLBACK TO process_nr_profile_sp;
2165: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2166: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2167: p_count => x_msg_count,

Line 2165: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2161:
2162: EXCEPTION
2163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2164: ROLLBACK TO process_nr_profile_sp;
2165: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2166: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2167: p_count => x_msg_count,
2168: p_data => x_msg_data);
2169:

Line 2166: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2162: EXCEPTION
2163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2164: ROLLBACK TO process_nr_profile_sp;
2165: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2166: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2167: p_count => x_msg_count,
2168: p_data => x_msg_data);
2169:
2170: WHEN FND_API.G_EXC_ERROR THEN

Line 2170: WHEN FND_API.G_EXC_ERROR THEN

2166: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2167: p_count => x_msg_count,
2168: p_data => x_msg_data);
2169:
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO process_nr_profile_sp;
2172: X_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2174: p_count => x_msg_count,

Line 2172: X_return_status := FND_API.G_RET_STS_ERROR;

2168: p_data => x_msg_data);
2169:
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO process_nr_profile_sp;
2172: X_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2174: p_count => x_msg_count,
2175: p_data => X_msg_data);
2176: WHEN OTHERS THEN

Line 2173: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2169:
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO process_nr_profile_sp;
2172: X_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2174: p_count => x_msg_count,
2175: p_data => X_msg_data);
2176: WHEN OTHERS THEN
2177: ROLLBACK TO process_nr_profile_sp;

Line 2178: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2174: p_count => x_msg_count,
2175: p_data => X_msg_data);
2176: WHEN OTHERS THEN
2177: ROLLBACK TO process_nr_profile_sp;
2178: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2179:
2180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2181: THEN
2182: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

Line 2186: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2182: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
2183: p_procedure_name => 'PROCESS_NR_PROFILE',
2184: p_error_text => SUBSTR(SQLERRM,1,240));
2185: END IF;
2186: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2187: p_count => x_msg_count,
2188: p_data => X_msg_data);
2189:
2190: