APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on FND_LOG

Line 50: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

46:
47: WHEN OTHERS THEN
48: x_return_status :='E';
49: x_msg_data := 'Cannot lock the rows';
50: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
51: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_address_req' , ' Cannot lock the rows ');
52: END IF;
53: raise_application_error(-20049, x_msg_data, true);
54: END;

Line 51: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_address_req' , ' Cannot lock the rows ');

47: WHEN OTHERS THEN
48: x_return_status :='E';
49: x_msg_data := 'Cannot lock the rows';
50: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
51: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_address_req' , ' Cannot lock the rows ');
52: END IF;
53: raise_application_error(-20049, x_msg_data, true);
54: END;
55:

Line 132: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

128:
129: EXCEPTION
130: WHEN OTHERS THEN
131: x_return_status :='E';
132: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
133: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_address_req' , x_msg_data);
134: END IF;
135: rollback to approve_new_address_req;
136: raise_application_error(-20050, x_msg_data, true);

Line 133: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_address_req' , x_msg_data);

129: EXCEPTION
130: WHEN OTHERS THEN
131: x_return_status :='E';
132: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
133: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_address_req' , x_msg_data);
134: END IF;
135: rollback to approve_new_address_req;
136: raise_application_error(-20050, x_msg_data, true);
137:

Line 183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

179:
180: WHEN OTHERS THEN
181: x_return_status :='E';
182: x_msg_data := 'Cannot lock the rows';
183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
184: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_address_req' , ' Cannot lock the rows ');
185: END IF;
186: raise_application_error(-20051, x_msg_data, true);
187: END;

Line 184: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_address_req' , ' Cannot lock the rows ');

180: WHEN OTHERS THEN
181: x_return_status :='E';
182: x_msg_data := 'Cannot lock the rows';
183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
184: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_address_req' , ' Cannot lock the rows ');
185: END IF;
186: raise_application_error(-20051, x_msg_data, true);
187: END;
188:

Line 252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: x_return_status :='E';
252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
253: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_address_req' , x_msg_data);
254: END IF;
255: rollback to approve_update_address_req;
256: raise_application_error(-20052, x_msg_data, true);

Line 253: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_address_req' , x_msg_data);

249: EXCEPTION
250: WHEN OTHERS THEN
251: x_return_status :='E';
252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
253: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_address_req' , x_msg_data);
254: END IF;
255: rollback to approve_update_address_req;
256: raise_application_error(-20052, x_msg_data, true);
257: END approve_update_address_req;

Line 353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

349: EXCEPTION
350:
351: WHEN OTHERS THEN
352: x_return_status :='E';
353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
354: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_cont_addr_requests' , x_msg_data);
355: END IF;
356: rollback to approve_cont_addr_requests;
357: raise_application_error(-20053, x_msg_data, true);

Line 354: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_cont_addr_requests' , x_msg_data);

350:
351: WHEN OTHERS THEN
352: x_return_status :='E';
353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
354: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_cont_addr_requests' , x_msg_data);
355: END IF;
356: rollback to approve_cont_addr_requests;
357: raise_application_error(-20053, x_msg_data, true);
358:

Line 401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

397:
398: WHEN OTHERS THEN
399: x_return_status :='E';
400: x_msg_data := 'Cannot lock the rows';
401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
402: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_contact_req' , ' Cannot lock the rows ');
403: END IF;
404: raise_application_error(-20049, x_msg_data, true);
405: END;

Line 402: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_contact_req' , ' Cannot lock the rows ');

398: WHEN OTHERS THEN
399: x_return_status :='E';
400: x_msg_data := 'Cannot lock the rows';
401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
402: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_contact_req' , ' Cannot lock the rows ');
403: END IF;
404: raise_application_error(-20049, x_msg_data, true);
405: END;
406:

Line 440: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

436: IF p_request_rec.create_user_account IS NOT NULL
437: AND p_request_rec.create_user_account = 'Y' THEN
438: -- create fnd user account
439: l_step := 'call create_fnd_user';
440: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
441: fnd_log.string
442: ( fnd_log.level_statement
443: , g_module || '.' || l_method
444: , l_step

Line 441: fnd_log.string

437: AND p_request_rec.create_user_account = 'Y' THEN
438: -- create fnd user account
439: l_step := 'call create_fnd_user';
440: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
441: fnd_log.string
442: ( fnd_log.level_statement
443: , g_module || '.' || l_method
444: , l_step
445: || ' username ' || p_request_rec.email_address

Line 442: ( fnd_log.level_statement

438: -- create fnd user account
439: l_step := 'call create_fnd_user';
440: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
441: fnd_log.string
442: ( fnd_log.level_statement
443: , g_module || '.' || l_method
444: , l_step
445: || ' username ' || p_request_rec.email_address
446: || ' user_email ' || p_request_rec.email_address

Line 477: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

473: );
474: END IF;
475:
476: l_step := 'update pos_contact_request with ids';
477: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
478: fnd_log.string
479: ( fnd_log.level_statement
480: , g_module || '.' || l_method
481: , l_step

Line 478: fnd_log.string

474: END IF;
475:
476: l_step := 'update pos_contact_request with ids';
477: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
478: fnd_log.string
479: ( fnd_log.level_statement
480: , g_module || '.' || l_method
481: , l_step
482: );

Line 479: ( fnd_log.level_statement

475:
476: l_step := 'update pos_contact_request with ids';
477: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
478: fnd_log.string
479: ( fnd_log.level_statement
480: , g_module || '.' || l_method
481: , l_step
482: );
483: END IF;

Line 549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

545:
546: WHEN OTHERS THEN
547: x_return_status :='E';
548: x_msg_data := 'Cannot lock the rows';
549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
550: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_contact_req' , ' Cannot lock the rows ');
551: END IF;
552: raise_application_error(-20049, x_msg_data, true);
553: END;

Line 550: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_contact_req' , ' Cannot lock the rows ');

546: WHEN OTHERS THEN
547: x_return_status :='E';
548: x_msg_data := 'Cannot lock the rows';
549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
550: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_contact_req' , ' Cannot lock the rows ');
551: END IF;
552: raise_application_error(-20049, x_msg_data, true);
553: END;
554:

Line 669: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

665:
666: WHEN OTHERS THEN
667: x_return_status :='E';
668: x_msg_data := 'Cannot lock the rows';
669: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
670: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , ' Cannot lock the rows ');
671: END IF;
672: raise_application_error(-20049, x_msg_data, true);
673: END;

Line 670: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , ' Cannot lock the rows ');

666: WHEN OTHERS THEN
667: x_return_status :='E';
668: x_msg_data := 'Cannot lock the rows';
669: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
670: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , ' Cannot lock the rows ');
671: END IF;
672: raise_application_error(-20049, x_msg_data, true);
673: END;
674:

Line 729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

725:
726: EXCEPTION
727: WHEN OTHERS THEN
728: x_return_status :='E';
729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
730: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , x_msg_data);
731: END IF;
732: rollback to approve_new_bus_class_req;
733: raise_application_error(-20097, x_msg_data, true);

Line 730: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , x_msg_data);

726: EXCEPTION
727: WHEN OTHERS THEN
728: x_return_status :='E';
729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
730: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , x_msg_data);
731: END IF;
732: rollback to approve_new_bus_class_req;
733: raise_application_error(-20097, x_msg_data, true);
734:

Line 765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

761:
762: WHEN OTHERS THEN
763: x_return_status :='E';
764: x_msg_data := 'Cannot lock the rows';
765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
766: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , ' Cannot lock the rows ');
767: END IF;
768: raise_application_error(-20049, x_msg_data, true);
769: END;

Line 766: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , ' Cannot lock the rows ');

762: WHEN OTHERS THEN
763: x_return_status :='E';
764: x_msg_data := 'Cannot lock the rows';
765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
766: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , ' Cannot lock the rows ');
767: END IF;
768: raise_application_error(-20049, x_msg_data, true);
769: END;
770:

Line 792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

788: x_return_status := fnd_api.g_ret_sts_success;
789: EXCEPTION
790: WHEN OTHERS THEN
791: x_return_status :='E';
792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
793: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , x_msg_data);
794: END IF;
795: rollback to approve_update_bus_class_req;
796: raise_application_error(-20096, x_msg_data, true);

Line 793: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , x_msg_data);

789: EXCEPTION
790: WHEN OTHERS THEN
791: x_return_status :='E';
792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
793: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , x_msg_data);
794: END IF;
795: rollback to approve_update_bus_class_req;
796: raise_application_error(-20096, x_msg_data, true);
797:

Line 899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

895:
896: EXCEPTION
897: WHEN OTHERS THEN
898: x_return_status :='E';
899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
900: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_address_req' , x_msg_data);
901: END IF;
902: rollback to approve_address_req;
903: raise_application_error(-20092, x_msg_data, true);

Line 900: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_address_req' , x_msg_data);

896: EXCEPTION
897: WHEN OTHERS THEN
898: x_return_status :='E';
899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
900: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_address_req' , x_msg_data);
901: END IF;
902: rollback to approve_address_req;
903: raise_application_error(-20092, x_msg_data, true);
904:

Line 929: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

925:
926: EXCEPTION
927: WHEN OTHERS THEN
928: x_return_status :='E';
929: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
930: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);
931: END IF;
932: rollback to approve_contact_req;
933: raise_application_error(-20093, x_msg_data, true);

Line 930: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);

926: EXCEPTION
927: WHEN OTHERS THEN
928: x_return_status :='E';
929: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
930: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);
931: END IF;
932: rollback to approve_contact_req;
933: raise_application_error(-20093, x_msg_data, true);
934:

Line 974: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

970: savepoint approve_contact_req;
971:
972: l_method := 'approve_contact_req';
973: x_password := NULL;
974: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
975: fnd_log.string
976: ( fnd_log.level_procedure
977: , g_module || '.' || l_method
978: , 'start with p_request_id ' || p_request_id

Line 975: fnd_log.string

971:
972: l_method := 'approve_contact_req';
973: x_password := NULL;
974: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
975: fnd_log.string
976: ( fnd_log.level_procedure
977: , g_module || '.' || l_method
978: , 'start with p_request_id ' || p_request_id
979: );

Line 976: ( fnd_log.level_procedure

972: l_method := 'approve_contact_req';
973: x_password := NULL;
974: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
975: fnd_log.string
976: ( fnd_log.level_procedure
977: , g_module || '.' || l_method
978: , 'start with p_request_id ' || p_request_id
979: );
980: END IF;

Line 1058: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1054:
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: x_return_status :='E';
1058: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1059: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);
1060: END IF;
1061: rollback to approve_contact_req;
1062: raise_application_error(-20090, x_msg_data, true);

Line 1059: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);

1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: x_return_status :='E';
1058: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1059: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);
1060: END IF;
1061: rollback to approve_contact_req;
1062: raise_application_error(-20090, x_msg_data, true);
1063:

Line 1165: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1161:
1162: EXCEPTION
1163: WHEN OTHERS THEN
1164: x_return_status :='E';
1165: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1166: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_bus_class_req' , x_msg_data);
1167: END IF;
1168: rollback to approve_bus_class_req;
1169: raise_application_error(-20090, x_msg_data, true);

Line 1166: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_bus_class_req' , x_msg_data);

1162: EXCEPTION
1163: WHEN OTHERS THEN
1164: x_return_status :='E';
1165: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1166: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_bus_class_req' , x_msg_data);
1167: END IF;
1168: rollback to approve_bus_class_req;
1169: raise_application_error(-20090, x_msg_data, true);
1170:

Line 1324: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1320:
1321: EXCEPTION
1322: WHEN OTHERS THEN
1323: x_return_status :='E';
1324: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1325: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_ps_req' , x_msg_data);
1326: END IF;
1327: rollback to approve_ps_req;
1328: raise_application_error(-20088, x_msg_data, true);

Line 1325: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_ps_req' , x_msg_data);

1321: EXCEPTION
1322: WHEN OTHERS THEN
1323: x_return_status :='E';
1324: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1325: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_ps_req' , x_msg_data);
1326: END IF;
1327: rollback to approve_ps_req;
1328: raise_application_error(-20088, x_msg_data, true);
1329:

Line 1361: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1357:
1358: WHEN OTHERS THEN
1359: x_return_status :='E';
1360: x_msg_data := 'Cannot lock the rows';
1361: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1362: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_address_req' , ' Cannot lock the rows ');
1363: END IF;
1364: raise_application_error(-20086, x_msg_data, true);
1365: END;

Line 1362: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_address_req' , ' Cannot lock the rows ');

1358: WHEN OTHERS THEN
1359: x_return_status :='E';
1360: x_msg_data := 'Cannot lock the rows';
1361: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1362: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_address_req' , ' Cannot lock the rows ');
1363: END IF;
1364: raise_application_error(-20086, x_msg_data, true);
1365: END;
1366:

Line 1386: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1382:
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: x_return_status :='E';
1386: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1387: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_address_req' , x_msg_data);
1388: END IF;
1389: rollback to reject_address_req;
1390: raise_application_error(-20085, x_msg_data, true);

Line 1387: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_address_req' , x_msg_data);

1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: x_return_status :='E';
1386: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1387: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_address_req' , x_msg_data);
1388: END IF;
1389: rollback to reject_address_req;
1390: raise_application_error(-20085, x_msg_data, true);
1391:

Line 1416: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1412:
1413: WHEN OTHERS THEN
1414: x_return_status :='E';
1415: x_msg_data := 'Cannot lock the rows';
1416: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1417: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_contact_req' , ' Cannot lock the rows ');
1418: END IF;
1419: raise_application_error(-20084, x_msg_data, true);
1420: END;

Line 1417: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_contact_req' , ' Cannot lock the rows ');

1413: WHEN OTHERS THEN
1414: x_return_status :='E';
1415: x_msg_data := 'Cannot lock the rows';
1416: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1417: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_contact_req' , ' Cannot lock the rows ');
1418: END IF;
1419: raise_application_error(-20084, x_msg_data, true);
1420: END;
1421:

Line 1441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1437: x_return_status := fnd_api.g_ret_sts_success;
1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: x_return_status :='E';
1441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1442: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_contact_req' , x_msg_data);
1443: END IF;
1444: rollback to reject_contact_req;
1445: raise_application_error(-20083, x_msg_data, true);

Line 1442: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_contact_req' , x_msg_data);

1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: x_return_status :='E';
1441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1442: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_contact_req' , x_msg_data);
1443: END IF;
1444: rollback to reject_contact_req;
1445: raise_application_error(-20083, x_msg_data, true);
1446:

Line 1472: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1468:
1469: WHEN OTHERS THEN
1470: x_return_status :='E';
1471: x_msg_data := 'Cannot lock the rows';
1472: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1473: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , ' Cannot lock the rows ');
1474: END IF;
1475: raise_application_error(-20082, x_msg_data, true);
1476: END;

Line 1473: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , ' Cannot lock the rows ');

1469: WHEN OTHERS THEN
1470: x_return_status :='E';
1471: x_msg_data := 'Cannot lock the rows';
1472: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1473: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , ' Cannot lock the rows ');
1474: END IF;
1475: raise_application_error(-20082, x_msg_data, true);
1476: END;
1477:

Line 1489: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1485: x_return_status := fnd_api.g_ret_sts_success;
1486: EXCEPTION
1487: WHEN OTHERS THEN
1488: x_return_status :='E';
1489: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1490: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , x_msg_data);
1491: END IF;
1492: rollback to reject_bus_class_req;
1493: raise_application_error(-20081, x_msg_data, true);

Line 1490: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , x_msg_data);

1486: EXCEPTION
1487: WHEN OTHERS THEN
1488: x_return_status :='E';
1489: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1490: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , x_msg_data);
1491: END IF;
1492: rollback to reject_bus_class_req;
1493: raise_application_error(-20081, x_msg_data, true);
1494:

Line 1518: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1514:
1515: WHEN OTHERS THEN
1516: x_return_status :='E';
1517: x_msg_data := 'Cannot lock the rows';
1518: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1519: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_ps_req' , ' Cannot lock the rows ');
1520: END IF;
1521: raise_application_error(-20080, x_msg_data, true);
1522: END;

Line 1519: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_ps_req' , ' Cannot lock the rows ');

1515: WHEN OTHERS THEN
1516: x_return_status :='E';
1517: x_msg_data := 'Cannot lock the rows';
1518: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1519: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_ps_req' , ' Cannot lock the rows ');
1520: END IF;
1521: raise_application_error(-20080, x_msg_data, true);
1522: END;
1523:

Line 1536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1532:
1533: EXCEPTION
1534: WHEN OTHERS THEN
1535: x_return_status :='E';
1536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1537: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_ps_req' , x_msg_data);
1538: END IF;
1539: rollback to reject_ps_req;
1540: raise_application_error(-20079, x_msg_data, true);

Line 1537: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_ps_req' , x_msg_data);

1533: EXCEPTION
1534: WHEN OTHERS THEN
1535: x_return_status :='E';
1536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1537: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_ps_req' , x_msg_data);
1538: END IF;
1539: rollback to reject_ps_req;
1540: raise_application_error(-20079, x_msg_data, true);
1541:

Line 1570: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1566:
1567: WHEN OTHERS THEN
1568: x_return_status :='E';
1569: x_msg_data := 'Cannot lock the rows';
1570: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1571: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');
1572: END IF;
1573: raise_application_error(-20078, x_msg_data, true);
1574: END;

Line 1571: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');

1567: WHEN OTHERS THEN
1568: x_return_status :='E';
1569: x_msg_data := 'Cannot lock the rows';
1570: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1571: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');
1572: END IF;
1573: raise_application_error(-20078, x_msg_data, true);
1574: END;
1575:

Line 1594: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1590: x_return_status := FND_API.G_RET_STS_SUCCESS;
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: x_return_status :='E';
1594: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1595: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_address_reqs' , x_msg_data);
1596: END IF;
1597: rollback to reject_mult_address_reqs;
1598: raise_application_error(-20077, x_msg_data, true);

Line 1595: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_address_reqs' , x_msg_data);

1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: x_return_status :='E';
1594: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1595: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_address_reqs' , x_msg_data);
1596: END IF;
1597: rollback to reject_mult_address_reqs;
1598: raise_application_error(-20077, x_msg_data, true);
1599:

Line 1628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1624:
1625: WHEN OTHERS THEN
1626: x_return_status :='E';
1627: x_msg_data := 'Cannot lock the rows';
1628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1629: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , ' Cannot lock the rows ');
1630: END IF;
1631: raise_application_error(-20076, x_msg_data, true);
1632: END;

Line 1629: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , ' Cannot lock the rows ');

1625: WHEN OTHERS THEN
1626: x_return_status :='E';
1627: x_msg_data := 'Cannot lock the rows';
1628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1629: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , ' Cannot lock the rows ');
1630: END IF;
1631: raise_application_error(-20076, x_msg_data, true);
1632: END;
1633:

Line 1653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1649:
1650: EXCEPTION
1651: WHEN OTHERS THEN
1652: x_return_status :='E';
1653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1654: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , x_msg_data);
1655: END IF;
1656: rollback to reject_mult_contact_reqs;
1657: raise_application_error(-20075, x_msg_data, true);

Line 1654: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , x_msg_data);

1650: EXCEPTION
1651: WHEN OTHERS THEN
1652: x_return_status :='E';
1653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1654: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , x_msg_data);
1655: END IF;
1656: rollback to reject_mult_contact_reqs;
1657: raise_application_error(-20075, x_msg_data, true);
1658:

Line 1688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1684:
1685: WHEN OTHERS THEN
1686: x_return_status :='E';
1687: x_msg_data := 'Cannot lock the rows';
1688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1689: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , ' Cannot lock the rows ');
1690: END IF;
1691: raise_application_error(-20074, x_msg_data, true);
1692: END;

Line 1689: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , ' Cannot lock the rows ');

1685: WHEN OTHERS THEN
1686: x_return_status :='E';
1687: x_msg_data := 'Cannot lock the rows';
1688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1689: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , ' Cannot lock the rows ');
1690: END IF;
1691: raise_application_error(-20074, x_msg_data, true);
1692: END;
1693:

Line 1714: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1710:
1711: EXCEPTION
1712: WHEN OTHERS THEN
1713: x_return_status :='E';
1714: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1715: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , x_msg_data);
1716: END IF;
1717: rollback to reject_mult_bus_class_reqs;
1718: raise_application_error(-20073, x_msg_data, true);

Line 1715: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , x_msg_data);

1711: EXCEPTION
1712: WHEN OTHERS THEN
1713: x_return_status :='E';
1714: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1715: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , x_msg_data);
1716: END IF;
1717: rollback to reject_mult_bus_class_reqs;
1718: raise_application_error(-20073, x_msg_data, true);
1719:

Line 1749: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1745:
1746: WHEN OTHERS THEN
1747: x_return_status :='E';
1748: x_msg_data := 'Cannot lock the rows';
1749: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1750: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , ' Cannot lock the rows ');
1751: END IF;
1752: raise_application_error(-20071, x_msg_data, true);
1753: END;

Line 1750: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , ' Cannot lock the rows ');

1746: WHEN OTHERS THEN
1747: x_return_status :='E';
1748: x_msg_data := 'Cannot lock the rows';
1749: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1750: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , ' Cannot lock the rows ');
1751: END IF;
1752: raise_application_error(-20071, x_msg_data, true);
1753: END;
1754:

Line 1773: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1769: x_return_status := FND_API.G_RET_STS_SUCCESS;
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: x_return_status :='E';
1773: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1774: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , x_msg_data);
1775: END IF;
1776: rollback to reject_mult_ps_reqs;
1777: raise_application_error(-20072, x_msg_data, true);

Line 1774: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , x_msg_data);

1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: x_return_status :='E';
1773: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1774: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , x_msg_data);
1775: END IF;
1776: rollback to reject_mult_ps_reqs;
1777: raise_application_error(-20072, x_msg_data, true);
1778:

Line 1807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1803:
1804: WHEN OTHERS THEN
1805: x_return_status :='E';
1806: x_msg_data := 'Cannot lock the rows';
1807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1808: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');
1809: END IF;
1810: raise_application_error(-20070, x_msg_data, true);
1811: END;

Line 1808: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');

1804: WHEN OTHERS THEN
1805: x_return_status :='E';
1806: x_msg_data := 'Cannot lock the rows';
1807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1808: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');
1809: END IF;
1810: raise_application_error(-20070, x_msg_data, true);
1811: END;
1812:

Line 1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1828:
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: x_return_status :='E';
1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1833: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , x_msg_data);
1834: END IF;
1835: rollback to approve_mult_address_reqs;
1836: raise_application_error(-20069, x_msg_data, true);

Line 1833: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , x_msg_data);

1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: x_return_status :='E';
1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1833: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , x_msg_data);
1834: END IF;
1835: rollback to approve_mult_address_reqs;
1836: raise_application_error(-20069, x_msg_data, true);
1837:

Line 1880: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1876:
1877: WHEN OTHERS THEN
1878: x_return_status :='E';
1879: x_msg_data := 'Cannot lock the rows';
1880: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1881: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , ' Cannot lock the rows ');
1882: END IF;
1883: raise_application_error(-20068, x_msg_data, true);
1884: END;

Line 1881: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , ' Cannot lock the rows ');

1877: WHEN OTHERS THEN
1878: x_return_status :='E';
1879: x_msg_data := 'Cannot lock the rows';
1880: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1881: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , ' Cannot lock the rows ');
1882: END IF;
1883: raise_application_error(-20068, x_msg_data, true);
1884: END;
1885:

Line 1997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1993:
1994: EXCEPTION
1995: WHEN OTHERS THEN
1996: x_return_status :='E';
1997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1998: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , x_msg_data);
1999: END IF;
2000: rollback to approve_mult_contact_reqs;
2001: raise_application_error(-20067, x_msg_data, true);

Line 1998: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , x_msg_data);

1994: EXCEPTION
1995: WHEN OTHERS THEN
1996: x_return_status :='E';
1997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1998: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , x_msg_data);
1999: END IF;
2000: rollback to approve_mult_contact_reqs;
2001: raise_application_error(-20067, x_msg_data, true);
2002:

Line 2030: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2026:
2027: WHEN OTHERS THEN
2028: x_return_status :='E';
2029: x_msg_data := 'Cannot lock the rows';
2030: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2031: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , ' Cannot lock the rows ');
2032: END IF;
2033: raise_application_error(-20049, x_msg_data, true);
2034: END;

Line 2031: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , ' Cannot lock the rows ');

2027: WHEN OTHERS THEN
2028: x_return_status :='E';
2029: x_msg_data := 'Cannot lock the rows';
2030: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2031: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , ' Cannot lock the rows ');
2032: END IF;
2033: raise_application_error(-20049, x_msg_data, true);
2034: END;
2035:

Line 2055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2051:
2052: EXCEPTION
2053: WHEN OTHERS THEN
2054: x_return_status :='E';
2055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2056: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , x_msg_data);
2057: END IF;
2058: rollback to approve_mult_bus_class_reqs;
2059: raise_application_error(-20065, x_msg_data, true);

Line 2056: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , x_msg_data);

2052: EXCEPTION
2053: WHEN OTHERS THEN
2054: x_return_status :='E';
2055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2056: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , x_msg_data);
2057: END IF;
2058: rollback to approve_mult_bus_class_reqs;
2059: raise_application_error(-20065, x_msg_data, true);
2060:

Line 2090: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2086:
2087: WHEN OTHERS THEN
2088: x_return_status :='E';
2089: x_msg_data := 'Cannot lock the rows';
2090: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2091: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , ' Cannot lock the rows ');
2092: END IF;
2093: raise_application_error(-20066, x_msg_data, true);
2094: END;

Line 2091: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , ' Cannot lock the rows ');

2087: WHEN OTHERS THEN
2088: x_return_status :='E';
2089: x_msg_data := 'Cannot lock the rows';
2090: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2091: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , ' Cannot lock the rows ');
2092: END IF;
2093: raise_application_error(-20066, x_msg_data, true);
2094: END;
2095:

Line 2115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2111:
2112: EXCEPTION
2113: WHEN OTHERS THEN
2114: x_return_status :='E';
2115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2116: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , x_msg_data);
2117: END IF;
2118: rollback to approve_mult_ps_reqs;
2119: raise_application_error(-20065, x_msg_data, true);

Line 2116: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , x_msg_data);

2112: EXCEPTION
2113: WHEN OTHERS THEN
2114: x_return_status :='E';
2115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2116: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , x_msg_data);
2117: END IF;
2118: rollback to approve_mult_ps_reqs;
2119: raise_application_error(-20065, x_msg_data, true);
2120:

Line 2152: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2148:
2149: WHEN OTHERS THEN
2150: x_return_status :='E';
2151: x_msg_data := 'Cannot lock the rows';
2152: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2153: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , ' Cannot lock the rows ');
2154: END IF;
2155: raise_application_error(-20064, x_msg_data, true);
2156: END;

Line 2153: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , ' Cannot lock the rows ');

2149: WHEN OTHERS THEN
2150: x_return_status :='E';
2151: x_msg_data := 'Cannot lock the rows';
2152: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2153: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , ' Cannot lock the rows ');
2154: END IF;
2155: raise_application_error(-20064, x_msg_data, true);
2156: END;
2157:

Line 2183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2179:
2180: EXCEPTION
2181: WHEN OTHERS THEN
2182: x_return_status :='E';
2183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2184: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , x_msg_data);
2185: END IF;
2186: rollback to approve_update_mult_bc_reqs;
2187: raise_application_error(-20063, x_msg_data, true);

Line 2184: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , x_msg_data);

2180: EXCEPTION
2181: WHEN OTHERS THEN
2182: x_return_status :='E';
2183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2184: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , x_msg_data);
2185: END IF;
2186: rollback to approve_update_mult_bc_reqs;
2187: raise_application_error(-20063, x_msg_data, true);
2188:

Line 2236: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2232:
2233: WHEN OTHERS THEN
2234: x_return_status :='E';
2235: x_msg_data := 'Cannot lock the rows';
2236: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2237: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , ' Cannot lock the rows ');
2238: END IF;
2239: raise_application_error(-20061, x_msg_data, true);
2240: END;

Line 2237: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , ' Cannot lock the rows ');

2233: WHEN OTHERS THEN
2234: x_return_status :='E';
2235: x_msg_data := 'Cannot lock the rows';
2236: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2237: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , ' Cannot lock the rows ');
2238: END IF;
2239: raise_application_error(-20061, x_msg_data, true);
2240: END;
2241:

Line 2309: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2305: EXCEPTION
2306: WHEN OTHERS THEN
2307: X_RETURN_STATUS :='E';
2308: x_msg_data := x_msg_data || ' Failure at step ' || l_step;
2309: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2310: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , x_msg_data);
2311: END IF;
2312: rollback to chg_address_req_approval;
2313: raise_application_error(-20015, x_msg_data, true);

Line 2310: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , x_msg_data);

2306: WHEN OTHERS THEN
2307: X_RETURN_STATUS :='E';
2308: x_msg_data := x_msg_data || ' Failure at step ' || l_step;
2309: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2310: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , x_msg_data);
2311: END IF;
2312: rollback to chg_address_req_approval;
2313: raise_application_error(-20015, x_msg_data, true);
2314:

Line 2401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2397:
2398: WHEN OTHERS THEN
2399: x_return_status :='E';
2400: x_msg_data := 'Cannot lock the rows';
2401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2402: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_contact_req_approval' , ' Cannot lock the rows ');
2403: END IF;
2404: raise_application_error(-20061, x_msg_data, true);
2405: END;

Line 2402: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_contact_req_approval' , ' Cannot lock the rows ');

2398: WHEN OTHERS THEN
2399: x_return_status :='E';
2400: x_msg_data := 'Cannot lock the rows';
2401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2402: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_contact_req_approval' , ' Cannot lock the rows ');
2403: END IF;
2404: raise_application_error(-20061, x_msg_data, true);
2405: END;
2406:

Line 2438: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2434:
2435: EXCEPTION
2436: WHEN OTHERS THEN
2437: x_return_status :='E';
2438: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2439: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_contact_req_approval' , x_msg_data);
2440: END IF;
2441: rollback to chg_contact_req_approval;
2442: raise_application_error(-20060, x_msg_data, true);

Line 2439: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_contact_req_approval' , x_msg_data);

2435: EXCEPTION
2436: WHEN OTHERS THEN
2437: x_return_status :='E';
2438: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2439: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_contact_req_approval' , x_msg_data);
2440: END IF;
2441: rollback to chg_contact_req_approval;
2442: raise_application_error(-20060, x_msg_data, true);
2443:

Line 2478: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2474:
2475: WHEN OTHERS THEN
2476: x_return_status :='E';
2477: x_msg_data := 'Cannot lock the rows';
2478: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2479: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_cont_addr_reqs' , ' Cannot lock the rows ');
2480: END IF;
2481: raise_application_error(-20059, x_msg_data, true);
2482: END;

Line 2479: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_cont_addr_reqs' , ' Cannot lock the rows ');

2475: WHEN OTHERS THEN
2476: x_return_status :='E';
2477: x_msg_data := 'Cannot lock the rows';
2478: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2479: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_cont_addr_reqs' , ' Cannot lock the rows ');
2480: END IF;
2481: raise_application_error(-20059, x_msg_data, true);
2482: END;
2483:

Line 2499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2495:
2496: EXCEPTION
2497: WHEN OTHERS THEN
2498: x_return_status :='E';
2499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2500: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_cont_addr_reqs' , x_msg_data);
2501: END IF;
2502: rollback to reject_mult_cont_addr_reqs;
2503: raise_application_error(-20058, x_msg_data, true);

Line 2500: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_cont_addr_reqs' , x_msg_data);

2496: EXCEPTION
2497: WHEN OTHERS THEN
2498: x_return_status :='E';
2499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2500: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_cont_addr_reqs' , x_msg_data);
2501: END IF;
2502: rollback to reject_mult_cont_addr_reqs;
2503: raise_application_error(-20058, x_msg_data, true);
2504:

Line 2545: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2541:
2542: WHEN OTHERS THEN
2543: x_return_status :='E';
2544: x_msg_data := 'Cannot lock the rows';
2545: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2546: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , ' Cannot lock the rows ');
2547: END IF;
2548: raise_application_error(-20058, x_msg_data, true);
2549: END;

Line 2546: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , ' Cannot lock the rows ');

2542: WHEN OTHERS THEN
2543: x_return_status :='E';
2544: x_msg_data := 'Cannot lock the rows';
2545: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2546: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , ' Cannot lock the rows ');
2547: END IF;
2548: raise_application_error(-20058, x_msg_data, true);
2549: END;
2550:

Line 2603: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2599:
2600: EXCEPTION
2601: WHEN OTHERS THEN
2602: x_return_status :='E';
2603: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2604: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , x_msg_data);
2605: END IF;
2606: rollback to new_contact_req_approval;
2607: raise_application_error(-20057, x_msg_data, true);

Line 2604: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , x_msg_data);

2600: EXCEPTION
2601: WHEN OTHERS THEN
2602: x_return_status :='E';
2603: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2604: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , x_msg_data);
2605: END IF;
2606: rollback to new_contact_req_approval;
2607: raise_application_error(-20057, x_msg_data, true);
2608:

Line 2695: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2691:
2692: WHEN OTHERS THEN
2693: x_return_status :='E';
2694: x_msg_data := 'Cannot lock the rows';
2695: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2696: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , ' Cannot lock the rows ');
2697: END IF;
2698: raise_application_error(-20056, x_msg_data, true);
2699: END;

Line 2696: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , ' Cannot lock the rows ');

2692: WHEN OTHERS THEN
2693: x_return_status :='E';
2694: x_msg_data := 'Cannot lock the rows';
2695: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2696: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , ' Cannot lock the rows ');
2697: END IF;
2698: raise_application_error(-20056, x_msg_data, true);
2699: END;
2700:

Line 2733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2729:
2730: EXCEPTION
2731: WHEN OTHERS THEN
2732: x_return_status :='E';
2733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2734: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , x_msg_data);
2735: END IF;
2736: rollback to update_addr_req_status;
2737: raise_application_error(-20055, x_msg_data, true);

Line 2734: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , x_msg_data);

2730: EXCEPTION
2731: WHEN OTHERS THEN
2732: x_return_status :='E';
2733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2734: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , x_msg_data);
2735: END IF;
2736: rollback to update_addr_req_status;
2737: raise_application_error(-20055, x_msg_data, true);
2738:

Line 2815: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2811:
2812: WHEN OTHERS THEN
2813: x_return_status :='E';
2814: x_msg_data := 'Cannot lock the rows';
2815: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2816: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'Manage Address' , ' Cannot lock the rows ');
2817: END IF;
2818: raise_application_error(-20086, x_msg_data, true);
2819:

Line 2816: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'Manage Address' , ' Cannot lock the rows ');

2812: WHEN OTHERS THEN
2813: x_return_status :='E';
2814: x_msg_data := 'Cannot lock the rows';
2815: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2816: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'Manage Address' , ' Cannot lock the rows ');
2817: END IF;
2818: raise_application_error(-20086, x_msg_data, true);
2819:
2820: END upd_address_to_contact_rel;