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 445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

441: IF p_request_rec.create_user_account IS NOT NULL
442: AND p_request_rec.create_user_account = 'Y' THEN
443: -- create fnd user account
444: l_step := 'call create_fnd_user';
445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
446: fnd_log.string
447: ( fnd_log.level_statement
448: , g_module || '.' || l_method
449: , l_step

Line 446: fnd_log.string

442: AND p_request_rec.create_user_account = 'Y' THEN
443: -- create fnd user account
444: l_step := 'call create_fnd_user';
445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
446: fnd_log.string
447: ( fnd_log.level_statement
448: , g_module || '.' || l_method
449: , l_step
450: || ' username ' || p_request_rec.email_address

Line 447: ( fnd_log.level_statement

443: -- create fnd user account
444: l_step := 'call create_fnd_user';
445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
446: fnd_log.string
447: ( fnd_log.level_statement
448: , g_module || '.' || l_method
449: , l_step
450: || ' username ' || p_request_rec.email_address
451: || ' user_email ' || p_request_rec.email_address

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

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

Line 483: fnd_log.string

479: END IF;
480:
481: l_step := 'update pos_contact_request with ids';
482: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
483: fnd_log.string
484: ( fnd_log.level_statement
485: , g_module || '.' || l_method
486: , l_step
487: );

Line 484: ( fnd_log.level_statement

480:
481: l_step := 'update pos_contact_request with ids';
482: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
483: fnd_log.string
484: ( fnd_log.level_statement
485: , g_module || '.' || l_method
486: , l_step
487: );
488: END IF;

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

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

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

551: WHEN OTHERS THEN
552: x_return_status :='E';
553: x_msg_data := 'Cannot lock the rows';
554: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
555: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_contact_req' , ' Cannot lock the rows ');
556: END IF;
557: raise_application_error(-20049, x_msg_data, true);
558: END;
559:

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

675:
676: WHEN OTHERS THEN
677: x_return_status :='E';
678: x_msg_data := 'Cannot lock the rows';
679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
680: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , ' Cannot lock the rows ');
681: END IF;
682: raise_application_error(-20049, x_msg_data, true);
683: END;

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

676: WHEN OTHERS THEN
677: x_return_status :='E';
678: x_msg_data := 'Cannot lock the rows';
679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
680: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , ' Cannot lock the rows ');
681: END IF;
682: raise_application_error(-20049, x_msg_data, true);
683: END;
684:

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

735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: x_return_status :='E';
739: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
740: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , x_msg_data);
741: END IF;
742: rollback to approve_new_bus_class_req;
743: raise_application_error(-20097, x_msg_data, true);

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

736: EXCEPTION
737: WHEN OTHERS THEN
738: x_return_status :='E';
739: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
740: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_new_bus_class_req' , x_msg_data);
741: END IF;
742: rollback to approve_new_bus_class_req;
743: raise_application_error(-20097, x_msg_data, true);
744:

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

771:
772: WHEN OTHERS THEN
773: x_return_status :='E';
774: x_msg_data := 'Cannot lock the rows';
775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
776: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , ' Cannot lock the rows ');
777: END IF;
778: raise_application_error(-20049, x_msg_data, true);
779: END;

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

772: WHEN OTHERS THEN
773: x_return_status :='E';
774: x_msg_data := 'Cannot lock the rows';
775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
776: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , ' Cannot lock the rows ');
777: END IF;
778: raise_application_error(-20049, x_msg_data, true);
779: END;
780:

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

798: x_return_status := fnd_api.g_ret_sts_success;
799: EXCEPTION
800: WHEN OTHERS THEN
801: x_return_status :='E';
802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
803: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , x_msg_data);
804: END IF;
805: rollback to approve_update_bus_class_req;
806: raise_application_error(-20096, x_msg_data, true);

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

799: EXCEPTION
800: WHEN OTHERS THEN
801: x_return_status :='E';
802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
803: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_bus_class_req' , x_msg_data);
804: END IF;
805: rollback to approve_update_bus_class_req;
806: raise_application_error(-20096, x_msg_data, true);
807:

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

905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: x_return_status :='E';
909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
910: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_address_req' , x_msg_data);
911: END IF;
912: rollback to approve_address_req;
913: raise_application_error(-20092, x_msg_data, true);

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

906: EXCEPTION
907: WHEN OTHERS THEN
908: x_return_status :='E';
909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
910: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_address_req' , x_msg_data);
911: END IF;
912: rollback to approve_address_req;
913: raise_application_error(-20092, x_msg_data, true);
914:

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

935:
936: EXCEPTION
937: WHEN OTHERS THEN
938: x_return_status :='E';
939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
940: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);
941: END IF;
942: rollback to approve_contact_req;
943: raise_application_error(-20093, x_msg_data, true);

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

936: EXCEPTION
937: WHEN OTHERS THEN
938: x_return_status :='E';
939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
940: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);
941: END IF;
942: rollback to approve_contact_req;
943: raise_application_error(-20093, x_msg_data, true);
944:

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

990: savepoint approve_contact_req;
991:
992: l_method := 'approve_contact_req';
993: x_password := NULL;
994: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
995: fnd_log.string
996: ( fnd_log.level_procedure
997: , g_module || '.' || l_method
998: , 'start with p_request_id ' || p_request_id

Line 995: fnd_log.string

991:
992: l_method := 'approve_contact_req';
993: x_password := NULL;
994: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
995: fnd_log.string
996: ( fnd_log.level_procedure
997: , g_module || '.' || l_method
998: , 'start with p_request_id ' || p_request_id
999: );

Line 996: ( fnd_log.level_procedure

992: l_method := 'approve_contact_req';
993: x_password := NULL;
994: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
995: fnd_log.string
996: ( fnd_log.level_procedure
997: , g_module || '.' || l_method
998: , 'start with p_request_id ' || p_request_id
999: );
1000: END IF;

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

1108:
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_return_status :='E';
1112: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1113: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);
1114: END IF;
1115: rollback to approve_contact_req;
1116: raise_application_error(-20090, x_msg_data, true);

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

1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_return_status :='E';
1112: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1113: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_contact_req' , x_msg_data);
1114: END IF;
1115: rollback to approve_contact_req;
1116: raise_application_error(-20090, x_msg_data, true);
1117:

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

1215:
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: x_return_status :='E';
1219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1220: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_bus_class_req' , x_msg_data);
1221: END IF;
1222: rollback to approve_bus_class_req;
1223: raise_application_error(-20090, x_msg_data, true);

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

1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: x_return_status :='E';
1219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1220: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_bus_class_req' , x_msg_data);
1221: END IF;
1222: rollback to approve_bus_class_req;
1223: raise_application_error(-20090, x_msg_data, true);
1224:

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

1374:
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: x_return_status :='E';
1378: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1379: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_ps_req' , x_msg_data);
1380: END IF;
1381: rollback to approve_ps_req;
1382: raise_application_error(-20088, x_msg_data, true);

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

1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: x_return_status :='E';
1378: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1379: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_ps_req' , x_msg_data);
1380: END IF;
1381: rollback to approve_ps_req;
1382: raise_application_error(-20088, x_msg_data, true);
1383:

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

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

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

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

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

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

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

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

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

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

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

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

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

1491: x_return_status := fnd_api.g_ret_sts_success;
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: x_return_status :='E';
1495: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1496: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_contact_req' , x_msg_data);
1497: END IF;
1498: rollback to reject_contact_req;
1499: raise_application_error(-20083, x_msg_data, true);

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

1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: x_return_status :='E';
1495: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1496: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_contact_req' , x_msg_data);
1497: END IF;
1498: rollback to reject_contact_req;
1499: raise_application_error(-20083, x_msg_data, true);
1500:

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

1522:
1523: WHEN OTHERS THEN
1524: x_return_status :='E';
1525: x_msg_data := 'Cannot lock the rows';
1526: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1527: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , ' Cannot lock the rows ');
1528: END IF;
1529: raise_application_error(-20082, x_msg_data, true);
1530: END;

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

1523: WHEN OTHERS THEN
1524: x_return_status :='E';
1525: x_msg_data := 'Cannot lock the rows';
1526: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1527: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , ' Cannot lock the rows ');
1528: END IF;
1529: raise_application_error(-20082, x_msg_data, true);
1530: END;
1531:

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

1539: x_return_status := fnd_api.g_ret_sts_success;
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: x_return_status :='E';
1543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1544: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , x_msg_data);
1545: END IF;
1546: rollback to reject_bus_class_req;
1547: raise_application_error(-20081, x_msg_data, true);

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

1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: x_return_status :='E';
1543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1544: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_bus_class_req' , x_msg_data);
1545: END IF;
1546: rollback to reject_bus_class_req;
1547: raise_application_error(-20081, x_msg_data, true);
1548:

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

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

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

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

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

1586:
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: x_return_status :='E';
1590: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1591: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_ps_req' , x_msg_data);
1592: END IF;
1593: rollback to reject_ps_req;
1594: raise_application_error(-20079, x_msg_data, true);

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

1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: x_return_status :='E';
1590: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1591: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_ps_req' , x_msg_data);
1592: END IF;
1593: rollback to reject_ps_req;
1594: raise_application_error(-20079, x_msg_data, true);
1595:

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

1620:
1621: WHEN OTHERS THEN
1622: x_return_status :='E';
1623: x_msg_data := 'Cannot lock the rows';
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1625: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');
1626: END IF;
1627: raise_application_error(-20078, x_msg_data, true);
1628: END;

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

1621: WHEN OTHERS THEN
1622: x_return_status :='E';
1623: x_msg_data := 'Cannot lock the rows';
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1625: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');
1626: END IF;
1627: raise_application_error(-20078, x_msg_data, true);
1628: END;
1629:

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

1644: x_return_status := FND_API.G_RET_STS_SUCCESS;
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: x_return_status :='E';
1648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1649: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_address_reqs' , x_msg_data);
1650: END IF;
1651: rollback to reject_mult_address_reqs;
1652: raise_application_error(-20077, x_msg_data, true);

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

1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: x_return_status :='E';
1648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1649: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_address_reqs' , x_msg_data);
1650: END IF;
1651: rollback to reject_mult_address_reqs;
1652: raise_application_error(-20077, x_msg_data, true);
1653:

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

1678:
1679: WHEN OTHERS THEN
1680: x_return_status :='E';
1681: x_msg_data := 'Cannot lock the rows';
1682: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1683: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , ' Cannot lock the rows ');
1684: END IF;
1685: raise_application_error(-20076, x_msg_data, true);
1686: END;

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

1679: WHEN OTHERS THEN
1680: x_return_status :='E';
1681: x_msg_data := 'Cannot lock the rows';
1682: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1683: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , ' Cannot lock the rows ');
1684: END IF;
1685: raise_application_error(-20076, x_msg_data, true);
1686: END;
1687:

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

1703:
1704: EXCEPTION
1705: WHEN OTHERS THEN
1706: x_return_status :='E';
1707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1708: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , x_msg_data);
1709: END IF;
1710: rollback to reject_mult_contact_reqs;
1711: raise_application_error(-20075, x_msg_data, true);

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

1704: EXCEPTION
1705: WHEN OTHERS THEN
1706: x_return_status :='E';
1707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1708: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_contact_reqs' , x_msg_data);
1709: END IF;
1710: rollback to reject_mult_contact_reqs;
1711: raise_application_error(-20075, x_msg_data, true);
1712:

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

1738:
1739: WHEN OTHERS THEN
1740: x_return_status :='E';
1741: x_msg_data := 'Cannot lock the rows';
1742: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1743: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , ' Cannot lock the rows ');
1744: END IF;
1745: raise_application_error(-20074, x_msg_data, true);
1746: END;

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

1739: WHEN OTHERS THEN
1740: x_return_status :='E';
1741: x_msg_data := 'Cannot lock the rows';
1742: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1743: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , ' Cannot lock the rows ');
1744: END IF;
1745: raise_application_error(-20074, x_msg_data, true);
1746: END;
1747:

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

1764:
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: x_return_status :='E';
1768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1769: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , x_msg_data);
1770: END IF;
1771: rollback to reject_mult_bus_class_reqs;
1772: raise_application_error(-20073, x_msg_data, true);

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

1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: x_return_status :='E';
1768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1769: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_bus_class_reqs' , x_msg_data);
1770: END IF;
1771: rollback to reject_mult_bus_class_reqs;
1772: raise_application_error(-20073, x_msg_data, true);
1773:

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

1799:
1800: WHEN OTHERS THEN
1801: x_return_status :='E';
1802: x_msg_data := 'Cannot lock the rows';
1803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1804: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , ' Cannot lock the rows ');
1805: END IF;
1806: raise_application_error(-20071, x_msg_data, true);
1807: END;

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

1800: WHEN OTHERS THEN
1801: x_return_status :='E';
1802: x_msg_data := 'Cannot lock the rows';
1803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1804: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , ' Cannot lock the rows ');
1805: END IF;
1806: raise_application_error(-20071, x_msg_data, true);
1807: END;
1808:

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

1823: x_return_status := FND_API.G_RET_STS_SUCCESS;
1824: EXCEPTION
1825: WHEN OTHERS THEN
1826: x_return_status :='E';
1827: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1828: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , x_msg_data);
1829: END IF;
1830: rollback to reject_mult_ps_reqs;
1831: raise_application_error(-20072, x_msg_data, true);

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

1824: EXCEPTION
1825: WHEN OTHERS THEN
1826: x_return_status :='E';
1827: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1828: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_ps_reqs' , x_msg_data);
1829: END IF;
1830: rollback to reject_mult_ps_reqs;
1831: raise_application_error(-20072, x_msg_data, true);
1832:

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

1857:
1858: WHEN OTHERS THEN
1859: x_return_status :='E';
1860: x_msg_data := 'Cannot lock the rows';
1861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1862: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');
1863: END IF;
1864: raise_application_error(-20070, x_msg_data, true);
1865: END;

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

1858: WHEN OTHERS THEN
1859: x_return_status :='E';
1860: x_msg_data := 'Cannot lock the rows';
1861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1862: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , ' Cannot lock the rows ');
1863: END IF;
1864: raise_application_error(-20070, x_msg_data, true);
1865: END;
1866:

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

1882:
1883: EXCEPTION
1884: WHEN OTHERS THEN
1885: x_return_status :='E';
1886: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1887: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , x_msg_data);
1888: END IF;
1889: rollback to approve_mult_address_reqs;
1890: raise_application_error(-20069, x_msg_data, true);

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

1883: EXCEPTION
1884: WHEN OTHERS THEN
1885: x_return_status :='E';
1886: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1887: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_address_reqs' , x_msg_data);
1888: END IF;
1889: rollback to approve_mult_address_reqs;
1890: raise_application_error(-20069, x_msg_data, true);
1891:

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

1930:
1931: WHEN OTHERS THEN
1932: x_return_status :='E';
1933: x_msg_data := 'Cannot lock the rows';
1934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1935: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , ' Cannot lock the rows ');
1936: END IF;
1937: raise_application_error(-20068, x_msg_data, true);
1938: END;

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

1931: WHEN OTHERS THEN
1932: x_return_status :='E';
1933: x_msg_data := 'Cannot lock the rows';
1934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1935: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , ' Cannot lock the rows ');
1936: END IF;
1937: raise_application_error(-20068, x_msg_data, true);
1938: END;
1939:

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

2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: x_return_status :='E';
2051: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2052: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , x_msg_data);
2053: END IF;
2054: rollback to approve_mult_contact_reqs;
2055: raise_application_error(-20067, x_msg_data, true);

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

2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: x_return_status :='E';
2051: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2052: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_contact_reqs' , x_msg_data);
2053: END IF;
2054: rollback to approve_mult_contact_reqs;
2055: raise_application_error(-20067, x_msg_data, true);
2056:

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

2080:
2081: WHEN OTHERS THEN
2082: x_return_status :='E';
2083: x_msg_data := 'Cannot lock the rows';
2084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2085: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , ' Cannot lock the rows ');
2086: END IF;
2087: raise_application_error(-20049, x_msg_data, true);
2088: END;

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

2081: WHEN OTHERS THEN
2082: x_return_status :='E';
2083: x_msg_data := 'Cannot lock the rows';
2084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2085: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , ' Cannot lock the rows ');
2086: END IF;
2087: raise_application_error(-20049, x_msg_data, true);
2088: END;
2089:

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

2105:
2106: EXCEPTION
2107: WHEN OTHERS THEN
2108: x_return_status :='E';
2109: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2110: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , x_msg_data);
2111: END IF;
2112: rollback to approve_mult_bus_class_reqs;
2113: raise_application_error(-20065, x_msg_data, true);

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

2106: EXCEPTION
2107: WHEN OTHERS THEN
2108: x_return_status :='E';
2109: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2110: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_bus_class_reqs' , x_msg_data);
2111: END IF;
2112: rollback to approve_mult_bus_class_reqs;
2113: raise_application_error(-20065, x_msg_data, true);
2114:

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

2140:
2141: WHEN OTHERS THEN
2142: x_return_status :='E';
2143: x_msg_data := 'Cannot lock the rows';
2144: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2145: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , ' Cannot lock the rows ');
2146: END IF;
2147: raise_application_error(-20066, x_msg_data, true);
2148: END;

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

2141: WHEN OTHERS THEN
2142: x_return_status :='E';
2143: x_msg_data := 'Cannot lock the rows';
2144: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2145: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , ' Cannot lock the rows ');
2146: END IF;
2147: raise_application_error(-20066, x_msg_data, true);
2148: END;
2149:

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

2165:
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: x_return_status :='E';
2169: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2170: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , x_msg_data);
2171: END IF;
2172: rollback to approve_mult_ps_reqs;
2173: raise_application_error(-20065, x_msg_data, true);

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

2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: x_return_status :='E';
2169: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2170: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_mult_ps_reqs' , x_msg_data);
2171: END IF;
2172: rollback to approve_mult_ps_reqs;
2173: raise_application_error(-20065, x_msg_data, true);
2174:

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

2202:
2203: WHEN OTHERS THEN
2204: x_return_status :='E';
2205: x_msg_data := 'Cannot lock the rows';
2206: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2207: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , ' Cannot lock the rows ');
2208: END IF;
2209: raise_application_error(-20064, x_msg_data, true);
2210: END;

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

2203: WHEN OTHERS THEN
2204: x_return_status :='E';
2205: x_msg_data := 'Cannot lock the rows';
2206: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2207: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , ' Cannot lock the rows ');
2208: END IF;
2209: raise_application_error(-20064, x_msg_data, true);
2210: END;
2211:

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

2233:
2234: EXCEPTION
2235: WHEN OTHERS THEN
2236: x_return_status :='E';
2237: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2238: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , x_msg_data);
2239: END IF;
2240: rollback to approve_update_mult_bc_reqs;
2241: raise_application_error(-20063, x_msg_data, true);

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

2234: EXCEPTION
2235: WHEN OTHERS THEN
2236: x_return_status :='E';
2237: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2238: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'approve_update_mult_bc_reqs' , x_msg_data);
2239: END IF;
2240: rollback to approve_update_mult_bc_reqs;
2241: raise_application_error(-20063, x_msg_data, true);
2242:

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

2286:
2287: WHEN OTHERS THEN
2288: x_return_status :='E';
2289: x_msg_data := 'Cannot lock the rows';
2290: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2291: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , ' Cannot lock the rows ');
2292: END IF;
2293: raise_application_error(-20061, x_msg_data, true);
2294: END;

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

2287: WHEN OTHERS THEN
2288: x_return_status :='E';
2289: x_msg_data := 'Cannot lock the rows';
2290: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2291: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , ' Cannot lock the rows ');
2292: END IF;
2293: raise_application_error(-20061, x_msg_data, true);
2294: END;
2295:

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

2359: EXCEPTION
2360: WHEN OTHERS THEN
2361: X_RETURN_STATUS :='E';
2362: x_msg_data := x_msg_data || ' Failure at step ' || l_step;
2363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2364: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , x_msg_data);
2365: END IF;
2366: rollback to chg_address_req_approval;
2367: raise_application_error(-20015, x_msg_data, true);

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

2360: WHEN OTHERS THEN
2361: X_RETURN_STATUS :='E';
2362: x_msg_data := x_msg_data || ' Failure at step ' || l_step;
2363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2364: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_address_req_approval' , x_msg_data);
2365: END IF;
2366: rollback to chg_address_req_approval;
2367: raise_application_error(-20015, x_msg_data, true);
2368:

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

2456:
2457: WHEN OTHERS THEN
2458: x_return_status :='E';
2459: x_msg_data := 'Cannot lock the rows';
2460: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2461: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_contact_req_approval' , ' Cannot lock the rows ');
2462: END IF;
2463: raise_application_error(-20061, x_msg_data, true);
2464: END;

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

2457: WHEN OTHERS THEN
2458: x_return_status :='E';
2459: x_msg_data := 'Cannot lock the rows';
2460: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2461: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_contact_req_approval' , ' Cannot lock the rows ');
2462: END IF;
2463: raise_application_error(-20061, x_msg_data, true);
2464: END;
2465:

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

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

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

2499: EXCEPTION
2500: WHEN OTHERS THEN
2501: x_return_status :='E';
2502: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2503: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'chg_contact_req_approval' , x_msg_data);
2504: END IF;
2505: rollback to chg_contact_req_approval;
2506: raise_application_error(-20060, x_msg_data, true);
2507:

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

2538:
2539: WHEN OTHERS THEN
2540: x_return_status :='E';
2541: x_msg_data := 'Cannot lock the rows';
2542: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2543: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_cont_addr_reqs' , ' Cannot lock the rows ');
2544: END IF;
2545: raise_application_error(-20059, x_msg_data, true);
2546: END;

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

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

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

2559:
2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: x_return_status :='E';
2563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2564: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_cont_addr_reqs' , x_msg_data);
2565: END IF;
2566: rollback to reject_mult_cont_addr_reqs;
2567: raise_application_error(-20058, x_msg_data, true);

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

2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: x_return_status :='E';
2563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2564: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'reject_mult_cont_addr_reqs' , x_msg_data);
2565: END IF;
2566: rollback to reject_mult_cont_addr_reqs;
2567: raise_application_error(-20058, x_msg_data, true);
2568:

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

2610:
2611: WHEN OTHERS THEN
2612: x_return_status :='E';
2613: x_msg_data := 'Cannot lock the rows';
2614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2615: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , ' Cannot lock the rows ');
2616: END IF;
2617: raise_application_error(-20058, x_msg_data, true);
2618: END;

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

2611: WHEN OTHERS THEN
2612: x_return_status :='E';
2613: x_msg_data := 'Cannot lock the rows';
2614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2615: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , ' Cannot lock the rows ');
2616: END IF;
2617: raise_application_error(-20058, x_msg_data, true);
2618: END;
2619:

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

2673:
2674: EXCEPTION
2675: WHEN OTHERS THEN
2676: x_return_status :='E';
2677: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2678: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , x_msg_data);
2679: END IF;
2680: rollback to new_contact_req_approval;
2681: raise_application_error(-20057, x_msg_data, true);

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

2674: EXCEPTION
2675: WHEN OTHERS THEN
2676: x_return_status :='E';
2677: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2678: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'new_contact_req_approval' , x_msg_data);
2679: END IF;
2680: rollback to new_contact_req_approval;
2681: raise_application_error(-20057, x_msg_data, true);
2682:

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

2765:
2766: WHEN OTHERS THEN
2767: x_return_status :='E';
2768: x_msg_data := 'Cannot lock the rows';
2769: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2770: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , ' Cannot lock the rows ');
2771: END IF;
2772: raise_application_error(-20056, x_msg_data, true);
2773: END;

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

2766: WHEN OTHERS THEN
2767: x_return_status :='E';
2768: x_msg_data := 'Cannot lock the rows';
2769: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2770: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , ' Cannot lock the rows ');
2771: END IF;
2772: raise_application_error(-20056, x_msg_data, true);
2773: END;
2774:

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

2803:
2804: EXCEPTION
2805: WHEN OTHERS THEN
2806: x_return_status :='E';
2807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2808: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , x_msg_data);
2809: END IF;
2810: rollback to update_addr_req_status;
2811: raise_application_error(-20055, x_msg_data, true);

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

2804: EXCEPTION
2805: WHEN OTHERS THEN
2806: x_return_status :='E';
2807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2808: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'update_addr_req_status' , x_msg_data);
2809: END IF;
2810: rollback to update_addr_req_status;
2811: raise_application_error(-20055, x_msg_data, true);
2812:

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

2885:
2886: WHEN OTHERS THEN
2887: x_return_status :='E';
2888: x_msg_data := 'Cannot lock the rows';
2889: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2890: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'Manage Address' , ' Cannot lock the rows ');
2891: END IF;
2892: raise_application_error(-20086, x_msg_data, true);
2893:

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

2886: WHEN OTHERS THEN
2887: x_return_status :='E';
2888: x_msg_data := 'Cannot lock the rows';
2889: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2890: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'Manage Address' , ' Cannot lock the rows ');
2891: END IF;
2892: raise_application_error(-20086, x_msg_data, true);
2893:
2894: END upd_address_to_contact_rel;