71: x_default_loc NUMBER;
72: x_bill_sequence_id NUMBER;
73: x_wdj_supply_type NUMBER;
74: x_org_id NUMBER;
75: x_user_id NUMBER := FND_GLOBAL.USER_ID;
76: x_login_id NUMBER := FND_GLOBAL.login_id;
77: x_operation_seq_num NUMBER;
78: x_max_resc_seq_num NUMBER;
79:
72: x_bill_sequence_id NUMBER;
73: x_wdj_supply_type NUMBER;
74: x_org_id NUMBER;
75: x_user_id NUMBER := FND_GLOBAL.USER_ID;
76: x_login_id NUMBER := FND_GLOBAL.login_id;
77: x_operation_seq_num NUMBER;
78: x_max_resc_seq_num NUMBER;
79:
80: l_error_msg VARCHAR2(2000);
1079:
1080: exception
1081: when no_data_found then
1082: x_last_update_date := SYSDATE;
1083: x_last_updated_by := FND_GLOBAL.USER_ID ;
1084: x_creation_date := SYSDATE;
1085: x_created_by := FND_GLOBAL.USER_ID;
1086: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1087: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1081: when no_data_found then
1082: x_last_update_date := SYSDATE;
1083: x_last_updated_by := FND_GLOBAL.USER_ID ;
1084: x_creation_date := SYSDATE;
1085: x_created_by := FND_GLOBAL.USER_ID;
1086: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1087: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1088: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1089: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1082: x_last_update_date := SYSDATE;
1083: x_last_updated_by := FND_GLOBAL.USER_ID ;
1084: x_creation_date := SYSDATE;
1085: x_created_by := FND_GLOBAL.USER_ID;
1086: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1087: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1088: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1089: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1090: x_program_update_date := SYSDATE;
1083: x_last_updated_by := FND_GLOBAL.USER_ID ;
1084: x_creation_date := SYSDATE;
1085: x_created_by := FND_GLOBAL.USER_ID;
1086: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1087: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1088: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1089: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1090: x_program_update_date := SYSDATE;
1091:
1084: x_creation_date := SYSDATE;
1085: x_created_by := FND_GLOBAL.USER_ID;
1086: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1087: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1088: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1089: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1090: x_program_update_date := SYSDATE;
1091:
1092: end;
1085: x_created_by := FND_GLOBAL.USER_ID;
1086: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1087: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1088: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1089: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1090: x_program_update_date := SYSDATE;
1091:
1092: end;
1093: