DBA Data[Home] [Help]

APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on HR_MULTI_MESSAGE

Line 870: p_return_status := hr_multi_message.get_return_status_disable;

866: -- If Learning Path is not created, rollback and return
867: if (l_lp_rtn_status = 'E') then
868: ROLLBACK TO create_talent_mgmt_lpm;
869: p_object_version_number := NULL;
870: p_return_status := hr_multi_message.get_return_status_disable;
871: return;
872: end if;
873:
874: ota_lp_enrollment_swi.create_lp_enrollment

Line 898: p_return_status := hr_multi_message.get_return_status_disable;

894: -- If Learning Path enrollment is not created, rollback and return
895: if (l_lpe_rtn_status = 'E') then
896: ROLLBACK TO create_talent_mgmt_lpm;
897: p_object_version_number := NULL;
898: p_return_status := hr_multi_message.get_return_status_disable;
899: return;
900: end if;
901:
902: ota_lp_section_swi.create_lp_section

Line 924: p_return_status := hr_multi_message.get_return_status_disable;

920: -- If Learning Path section is not created, rollback and return
921: if (l_lpc_rtn_status = 'E') then
922: ROLLBACK TO create_talent_mgmt_lpm;
923: p_object_version_number := NULL;
924: p_return_status := hr_multi_message.get_return_status_disable;
925: return;
926: end if;
927: END IF;
928:

Line 952: p_return_status := hr_multi_message.get_return_status_disable;

948: -- If Learning Path member is not created, rollback and return
949: if (l_lpm_rtn_status = 'E') then
950: ROLLBACK TO create_talent_mgmt_lpm;
951: p_object_version_number := NULL;
952: p_return_status := hr_multi_message.get_return_status_disable;
953: return;
954: end if;
955:
956:

Line 976: p_return_status := hr_multi_message.get_return_status_disable;

972: -- Derive the API return status value based on whether
973: -- messages of any type exist in the Multiple Message List.
974: -- Also disable Multiple Message Detection.
975: --
976: p_return_status := hr_multi_message.get_return_status_disable;
977: hr_utility.set_location(' Leaving:' || l_proc,20);
978: --
979: EXCEPTION
980: WHEN hr_multi_message.error_message_exist THEN

Line 980: WHEN hr_multi_message.error_message_exist THEN

976: p_return_status := hr_multi_message.get_return_status_disable;
977: hr_utility.set_location(' Leaving:' || l_proc,20);
978: --
979: EXCEPTION
980: WHEN hr_multi_message.error_message_exist THEN
981: --
982: -- Catch the Multiple Message List exception which
983: -- indicates API processing has been aborted because
984: -- at least one message exists in the list.

Line 991: p_return_status := hr_multi_message.get_return_status_disable;

987: --
988: -- Reset IN OUT parameters and set OUT parameters
989: --
990: p_object_version_NUMBER := NULL;
991: p_return_status := hr_multi_message.get_return_status_disable;
992: hr_utility.set_location(' Leaving:' || l_proc, 30);
993:
994: WHEN others THEN
995: --

Line 1003: IF hr_multi_message.unexpected_error_add(l_proc) THEN

999: -- Multiple Message List. Otherwise re-raise the
1000: -- error.
1001: --
1002: ROLLBACK TO create_talent_mgmt_lpm;
1003: IF hr_multi_message.unexpected_error_add(l_proc) THEN
1004: hr_utility.set_location(' Leaving:' || l_proc,40);
1005: RAISE;
1006: END IF;
1007: --

Line 1011: p_return_status := hr_multi_message.get_return_status_disable;

1007: --
1008: -- Reset IN OUT and set OUT parameters
1009: --
1010: p_object_version_NUMBER := NULL;
1011: p_return_status := hr_multi_message.get_return_status_disable;
1012: hr_utility.set_location(' Leaving:' || l_proc,50);
1013: END create_talent_mgmt_lpm;
1014:
1015: -- ----------------------------------------------------------------------------

Line 1150: p_return_status := hr_multi_message.get_return_status_disable;

1146:
1147: -- If Learning Path is not updated, rollback and return
1148: if (l_lp_rtn_status = 'E') then
1149: ROLLBACK TO update_talent_mgmt_lp;
1150: p_return_status := hr_multi_message.get_return_status_disable;
1151: return;
1152: end if;
1153:
1154: ota_lp_enrollment_swi.update_lp_enrollment

Line 1165: p_return_status := hr_multi_message.get_return_status_disable;

1161:
1162: -- If Learning Path enrollment is not created, rollback and return
1163: if (l_lpe_rtn_status = 'E') then
1164: ROLLBACK TO update_talent_mgmt_lp;
1165: p_return_status := hr_multi_message.get_return_status_disable;
1166: return;
1167: end if;
1168:
1169: IF p_mode = 'APPROVED' THEN

Line 1190: p_return_status := hr_multi_message.get_return_status_disable;

1186: );
1187:
1188: if (l_lme_rtn_status = 'E') then
1189: ROLLBACK TO update_talent_mgmt_lp;
1190: p_return_status := hr_multi_message.get_return_status_disable;
1191: return;
1192: end if;
1193:
1194: END LOOP;

Line 1222: p_return_status := hr_multi_message.get_return_status_disable;

1218:
1219: -- If Learning Path enrollment is not created, rollback and return
1220: if (l_lpe_rtn_status = 'E') then
1221: ROLLBACK TO update_talent_mgmt_lp;
1222: p_return_status := hr_multi_message.get_return_status_disable;
1223: return;
1224: end if;
1225:
1226:

Line 1247: p_return_status := hr_multi_message.get_return_status_disable;

1243: );
1244:
1245: if (l_lme_rtn_status = 'E') then
1246: ROLLBACK TO update_talent_mgmt_lp;
1247: p_return_status := hr_multi_message.get_return_status_disable;
1248: return;
1249: end if;
1250:
1251: END LOOP;

Line 1258: p_return_status := hr_multi_message.get_return_status_disable;

1254: -- Derive the API return status value based on whether
1255: -- messages of any type exist in the Multiple Message List.
1256: -- Also disable Multiple Message Detection.
1257: --
1258: p_return_status := hr_multi_message.get_return_status_disable;
1259: hr_utility.set_location(' Leaving:' || l_proc,20);
1260: --
1261: EXCEPTION
1262: WHEN hr_multi_message.error_message_exist THEN

Line 1262: WHEN hr_multi_message.error_message_exist THEN

1258: p_return_status := hr_multi_message.get_return_status_disable;
1259: hr_utility.set_location(' Leaving:' || l_proc,20);
1260: --
1261: EXCEPTION
1262: WHEN hr_multi_message.error_message_exist THEN
1263: --
1264: -- Catch the Multiple Message List exception which
1265: -- indicates API processing has been aborted because
1266: -- at least one message exists in the list.

Line 1272: p_return_status := hr_multi_message.get_return_status_disable;

1268: ROLLBACK TO update_talent_mgmt_lp;
1269: --
1270: -- Reset IN OUT parameters and set OUT parameters
1271: --
1272: p_return_status := hr_multi_message.get_return_status_disable;
1273: hr_utility.set_location(' Leaving:' || l_proc, 30);
1274:
1275: WHEN others THEN
1276: --

Line 1284: IF hr_multi_message.unexpected_error_add(l_proc) THEN

1280: -- Multiple Message List. Otherwise re-raise the
1281: -- error.
1282: --
1283: ROLLBACK TO update_talent_mgmt_lp;
1284: IF hr_multi_message.unexpected_error_add(l_proc) THEN
1285: hr_utility.set_location(' Leaving:' || l_proc,40);
1286: RAISE;
1287: END IF;
1288: --

Line 1291: p_return_status := hr_multi_message.get_return_status_disable;

1287: END IF;
1288: --
1289: -- Reset IN OUT and set OUT parameters
1290: --
1291: p_return_status := hr_multi_message.get_return_status_disable;
1292: hr_utility.set_location(' Leaving:' || l_proc,50);
1293: END update_talent_mgmt_lp;
1294: -- ----------------------------------------------------------------------------
1295: -- |-------------------< chk_no_of_mandatory_courses >-------------------------|