844: -- If Learning Path is not created, rollback and return
845: if (l_lp_rtn_status = 'E') then
846: ROLLBACK TO create_talent_mgmt_lpm;
847: p_object_version_number := NULL;
848: p_return_status := hr_multi_message.get_return_status_disable;
849: return;
850: end if;
851:
852: ota_lp_enrollment_swi.create_lp_enrollment
872: -- If Learning Path enrollment is not created, rollback and return
873: if (l_lpe_rtn_status = 'E') then
874: ROLLBACK TO create_talent_mgmt_lpm;
875: p_object_version_number := NULL;
876: p_return_status := hr_multi_message.get_return_status_disable;
877: return;
878: end if;
879:
880: ota_lp_section_swi.create_lp_section
898: -- If Learning Path section is not created, rollback and return
899: if (l_lpc_rtn_status = 'E') then
900: ROLLBACK TO create_talent_mgmt_lpm;
901: p_object_version_number := NULL;
902: p_return_status := hr_multi_message.get_return_status_disable;
903: return;
904: end if;
905: END IF;
906:
926: -- If Learning Path member is not created, rollback and return
927: if (l_lpm_rtn_status = 'E') then
928: ROLLBACK TO create_talent_mgmt_lpm;
929: p_object_version_number := NULL;
930: p_return_status := hr_multi_message.get_return_status_disable;
931: return;
932: end if;
933:
934:
950: -- Derive the API return status value based on whether
951: -- messages of any type exist in the Multiple Message List.
952: -- Also disable Multiple Message Detection.
953: --
954: p_return_status := hr_multi_message.get_return_status_disable;
955: hr_utility.set_location(' Leaving:' || l_proc,20);
956: --
957: EXCEPTION
958: WHEN hr_multi_message.error_message_exist THEN
954: p_return_status := hr_multi_message.get_return_status_disable;
955: hr_utility.set_location(' Leaving:' || l_proc,20);
956: --
957: EXCEPTION
958: WHEN hr_multi_message.error_message_exist THEN
959: --
960: -- Catch the Multiple Message List exception which
961: -- indicates API processing has been aborted because
962: -- at least one message exists in the list.
965: --
966: -- Reset IN OUT parameters and set OUT parameters
967: --
968: p_object_version_NUMBER := NULL;
969: p_return_status := hr_multi_message.get_return_status_disable;
970: hr_utility.set_location(' Leaving:' || l_proc, 30);
971:
972: WHEN others THEN
973: --
977: -- Multiple Message List. Otherwise re-raise the
978: -- error.
979: --
980: ROLLBACK TO create_talent_mgmt_lpm;
981: IF hr_multi_message.unexpected_error_add(l_proc) THEN
982: hr_utility.set_location(' Leaving:' || l_proc,40);
983: RAISE;
984: END IF;
985: --
985: --
986: -- Reset IN OUT and set OUT parameters
987: --
988: p_object_version_NUMBER := NULL;
989: p_return_status := hr_multi_message.get_return_status_disable;
990: hr_utility.set_location(' Leaving:' || l_proc,50);
991: END create_talent_mgmt_lpm;
992:
993: -- ----------------------------------------------------------------------------
1124:
1125: -- If Learning Path is not updated, rollback and return
1126: if (l_lp_rtn_status = 'E') then
1127: ROLLBACK TO update_talent_mgmt_lp;
1128: p_return_status := hr_multi_message.get_return_status_disable;
1129: return;
1130: end if;
1131:
1132: ota_lp_enrollment_swi.update_lp_enrollment
1139:
1140: -- If Learning Path enrollment is not created, rollback and return
1141: if (l_lpe_rtn_status = 'E') then
1142: ROLLBACK TO update_talent_mgmt_lp;
1143: p_return_status := hr_multi_message.get_return_status_disable;
1144: return;
1145: end if;
1146:
1147: IF p_mode = 'APPROVED' THEN
1164: );
1165:
1166: if (l_lme_rtn_status = 'E') then
1167: ROLLBACK TO update_talent_mgmt_lp;
1168: p_return_status := hr_multi_message.get_return_status_disable;
1169: return;
1170: end if;
1171:
1172: END LOOP;
1196:
1197: -- If Learning Path enrollment is not created, rollback and return
1198: if (l_lpe_rtn_status = 'E') then
1199: ROLLBACK TO update_talent_mgmt_lp;
1200: p_return_status := hr_multi_message.get_return_status_disable;
1201: return;
1202: end if;
1203:
1204:
1221: );
1222:
1223: if (l_lme_rtn_status = 'E') then
1224: ROLLBACK TO update_talent_mgmt_lp;
1225: p_return_status := hr_multi_message.get_return_status_disable;
1226: return;
1227: end if;
1228:
1229: END LOOP;
1232: -- Derive the API return status value based on whether
1233: -- messages of any type exist in the Multiple Message List.
1234: -- Also disable Multiple Message Detection.
1235: --
1236: p_return_status := hr_multi_message.get_return_status_disable;
1237: hr_utility.set_location(' Leaving:' || l_proc,20);
1238: --
1239: EXCEPTION
1240: WHEN hr_multi_message.error_message_exist THEN
1236: p_return_status := hr_multi_message.get_return_status_disable;
1237: hr_utility.set_location(' Leaving:' || l_proc,20);
1238: --
1239: EXCEPTION
1240: WHEN hr_multi_message.error_message_exist THEN
1241: --
1242: -- Catch the Multiple Message List exception which
1243: -- indicates API processing has been aborted because
1244: -- at least one message exists in the list.
1246: ROLLBACK TO update_talent_mgmt_lp;
1247: --
1248: -- Reset IN OUT parameters and set OUT parameters
1249: --
1250: p_return_status := hr_multi_message.get_return_status_disable;
1251: hr_utility.set_location(' Leaving:' || l_proc, 30);
1252:
1253: WHEN others THEN
1254: --
1258: -- Multiple Message List. Otherwise re-raise the
1259: -- error.
1260: --
1261: ROLLBACK TO update_talent_mgmt_lp;
1262: IF hr_multi_message.unexpected_error_add(l_proc) THEN
1263: hr_utility.set_location(' Leaving:' || l_proc,40);
1264: RAISE;
1265: END IF;
1266: --
1265: END IF;
1266: --
1267: -- Reset IN OUT and set OUT parameters
1268: --
1269: p_return_status := hr_multi_message.get_return_status_disable;
1270: hr_utility.set_location(' Leaving:' || l_proc,50);
1271: END update_talent_mgmt_lp;
1272: -- ----------------------------------------------------------------------------
1273: -- |-------------------< chk_no_of_mandatory_courses >-------------------------|