APPS.BIS_OBJ_REFRESH_HISTORY_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 27: BIS_COLLECTION_UTILITIES.put_line('Following record already exist in BIS_OBJ_REFRESH_HISTORY ');

23:
24: BEGIN
25: --for bug 4174608
26: for c_check_rec in C_check loop
27: BIS_COLLECTION_UTILITIES.put_line('Following record already exist in BIS_OBJ_REFRESH_HISTORY ');
28: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id '||p_Prog_request_id ||' OBJECT_TYPE '|| p_Object_type||' OBJECT_NAME '||p_Object_name);
29: return;
30: end loop;
31: insert into BIS_OBJ_REFRESH_HISTORY

Line 28: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id '||p_Prog_request_id ||' OBJECT_TYPE '|| p_Object_type||' OBJECT_NAME '||p_Object_name);

24: BEGIN
25: --for bug 4174608
26: for c_check_rec in C_check loop
27: BIS_COLLECTION_UTILITIES.put_line('Following record already exist in BIS_OBJ_REFRESH_HISTORY ');
28: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id '||p_Prog_request_id ||' OBJECT_TYPE '|| p_Object_type||' OBJECT_NAME '||p_Object_name);
29: return;
30: end loop;
31: insert into BIS_OBJ_REFRESH_HISTORY
32: (Prog_request_id ,

Line 63: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id ' || p_Prog_request_id);

59:
60: commit;
61: EXCEPTION
62: when others then
63: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id ' || p_Prog_request_id);
64: BIS_COLLECTION_UTILITIES.put_line('Object_type '|| p_Object_type);
65: BIS_COLLECTION_UTILITIES.put_line('Object_name '||p_Object_name);
66: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row ' || sqlerrm);
67: raise;

Line 64: BIS_COLLECTION_UTILITIES.put_line('Object_type '|| p_Object_type);

60: commit;
61: EXCEPTION
62: when others then
63: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id ' || p_Prog_request_id);
64: BIS_COLLECTION_UTILITIES.put_line('Object_type '|| p_Object_type);
65: BIS_COLLECTION_UTILITIES.put_line('Object_name '||p_Object_name);
66: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row ' || sqlerrm);
67: raise;
68: END;

Line 65: BIS_COLLECTION_UTILITIES.put_line('Object_name '||p_Object_name);

61: EXCEPTION
62: when others then
63: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id ' || p_Prog_request_id);
64: BIS_COLLECTION_UTILITIES.put_line('Object_type '|| p_Object_type);
65: BIS_COLLECTION_UTILITIES.put_line('Object_name '||p_Object_name);
66: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row ' || sqlerrm);
67: raise;
68: END;
69:

Line 66: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row ' || sqlerrm);

62: when others then
63: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id ' || p_Prog_request_id);
64: BIS_COLLECTION_UTILITIES.put_line('Object_type '|| p_Object_type);
65: BIS_COLLECTION_UTILITIES.put_line('Object_name '||p_Object_name);
66: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row ' || sqlerrm);
67: raise;
68: END;
69:
70:

Line 145: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Update_Row ' || sqlerrm);

141: RETURN TRUE;
142:
143: EXCEPTION
144: when others then
145: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Update_Row ' || sqlerrm);
146: raise;
147:
148: END;
149:

Line 158: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Delete_Row ' || sqlerrm);

154: WHERE PROG_REQUEST_ID = p_prog_req_id;
155:
156: EXCEPTION
157: when others then
158: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Delete_Row ' || sqlerrm);
159: raise;
160: END;
161:
162: