DBA Data[Home] [Help]

APPS.HR_ATTACHMENTS_LOADER dependencies on HR_UTILITY

Line 73: hr_utility.set_location('Added attachmnent for '||p_function_name,10);

69: 1,
70: l_application_id,
71: '',
72: 'Y');
73: hr_utility.set_location('Added attachmnent for '||p_function_name,10);
74: else
75: close att_func_exists;
76: hr_utility.set_location('Attachmnent exists for '||p_function_name,20);
77: end if;

Line 76: hr_utility.set_location('Attachmnent exists for '||p_function_name,20);

72: 'Y');
73: hr_utility.set_location('Added attachmnent for '||p_function_name,10);
74: else
75: close att_func_exists;
76: hr_utility.set_location('Attachmnent exists for '||p_function_name,20);
77: end if;
78: p_attachment_function_id:=l_attachment_function_id;
79: p_application_id:=l_application_id;
80: else

Line 82: hr_utility.set_location('Couldnt find function '||p_function_name,30);

78: p_attachment_function_id:=l_attachment_function_id;
79: p_application_id:=l_application_id;
80: else
81: close function_id;
82: hr_utility.set_location('Couldnt find function '||p_function_name,30);
83: p_attachment_function_id:=null;
84: p_application_id:=null;
85: end if;
86: end cre_or_sel_att_form_function;

Line 153: hr_utility.set_location('Attached category '||P_category_name,10);

149: 1,
150: sysdate,
151: 1,
152: 1);
153: hr_utility.set_location('Attached category '||P_category_name,10);
154: else
155: close category_exists;
156: hr_utility.set_location('Had category '||P_category_name,20);
157: end if;

Line 156: hr_utility.set_location('Had category '||P_category_name,20);

152: 1);
153: hr_utility.set_location('Attached category '||P_category_name,10);
154: else
155: close category_exists;
156: hr_utility.set_location('Had category '||P_category_name,20);
157: end if;
158: else
159: close categories;
160: hr_utility.set_location('Couldnt find category '||P_category_name,30);

Line 160: hr_utility.set_location('Couldnt find category '||P_category_name,30);

156: hr_utility.set_location('Had category '||P_category_name,20);
157: end if;
158: else
159: close categories;
160: hr_utility.set_location('Couldnt find category '||P_category_name,30);
161: end if;
162: else
163: close att_func_exists;
164: hr_utility.set_location('Couldnt find function ',40);

Line 164: hr_utility.set_location('Couldnt find function ',40);

160: hr_utility.set_location('Couldnt find category '||P_category_name,30);
161: end if;
162: else
163: close att_func_exists;
164: hr_utility.set_location('Couldnt find function ',40);
165: end if;
166: end associate_category;
167:
168: procedure create_or_update_block

Line 246: hr_utility.set_location('Added block '||p_block_name,10);

242: p_context1_field,
243: p_context2_field,
244: p_context3_field);
245: p_attachment_blk_id:=l_attachment_blk_id;
246: hr_utility.set_location('Added block '||p_block_name,10);
247: else
248: close block_exists;
249: -- if it does exist then update it
250: update fnd_attachment_blocks

Line 267: hr_utility.set_location('Updated block '||p_block_name,20);

263: context2_field=p_context2_field,
264: context3_field=p_context3_field
265: where attachment_blk_id=l_attachment_blk_id;
266: p_attachment_blk_id:=l_attachment_blk_id;
267: hr_utility.set_location('Updated block '||p_block_name,20);
268: end if;
269: else
270: close att_func_exists;
271: hr_utility.set_location('Couldnt find function ',30);

Line 271: hr_utility.set_location('Couldnt find function ',30);

267: hr_utility.set_location('Updated block '||p_block_name,20);
268: end if;
269: else
270: close att_func_exists;
271: hr_utility.set_location('Couldnt find function ',30);
272: p_attachment_blk_id:=null;
273: end if;
274: --
275: end create_or_update_block;

Line 365: hr_utility.set_location('Added entity '||p_data_object_code,10);

361: sysdate,
362: 1,
363: 1,
364: p_language_code);
365: hr_utility.set_location('Added entity '||p_data_object_code,10);
366: p_document_entity_id:=l_document_entity_id;
367: else
368: close entity_exists;
369: hr_utility.set_location('Found entity '||p_data_object_code,20);

Line 369: hr_utility.set_location('Found entity '||p_data_object_code,20);

365: hr_utility.set_location('Added entity '||p_data_object_code,10);
366: p_document_entity_id:=l_document_entity_id;
367: else
368: close entity_exists;
369: hr_utility.set_location('Found entity '||p_data_object_code,20);
370: p_document_entity_id:=l_document_entity_id;
371: end if;
372: end create_or_select_entity;
373: --

Line 477: hr_utility.set_location('Added block entity '||p_data_object_code,10);

473: p_condition_field,
474: p_condition_operator,
475: p_condition_value1,
476: p_condition_value2);
477: hr_utility.set_location('Added block entity '||p_data_object_code,10);
478: p_attachment_blk_entity_id:=l_attachment_blk_entity_id;
479: else
480: close block_entity_exists;
481: -- if already exists then update it

Line 507: hr_utility.set_location('Updated block entity '||p_data_object_code,20);

503: condition_operator=p_condition_operator,
504: condition_value1=p_condition_value1,
505: condition_value2=p_condition_value2
506: where attachment_blk_entity_id=l_attachment_blk_entity_id;
507: hr_utility.set_location('Updated block entity '||p_data_object_code,20);
508: p_attachment_blk_entity_id:=l_attachment_blk_entity_id;
509: end if;
510: else
511: close block_exists;

Line 512: hr_utility.set_location('Couldnt find block ',30);

508: p_attachment_blk_entity_id:=l_attachment_blk_entity_id;
509: end if;
510: else
511: close block_exists;
512: hr_utility.set_location('Couldnt find block ',30);
513: end if;
514: end attach_entity;
515: --
516: end HR_ATTACHMENTS_LOADER;