APPS.POR_ITEM_ATTRIBUTES_PKG dependencies on PO_WF_DEBUG_PKG

Line 21: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

17: BEGIN
18:
19: IF (funcmode='RUN') THEN
20: l_progress := 'Create_Attach_Item_Attr: 001';
21: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
22:
23: -- Set the multi-org context
24:
25: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 41: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

37: aname => 'DOCUMENT_ID');
38:
39: l_progress := 'Create_Attach_Item_Attr: 002 - ' ||
40: to_char(l_req_header_id);
41: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
42:
43: add_attribute_attachment(l_req_header_id,
44: 'AD_HOC_LOCATION',
45: 33,

Line 50: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

46: itemtype,
47: itemkey);
48:
49: l_progress := 'Create_Attach_Item_Attr: 005 - add_attr_attachment';
50: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
51:
52: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
53: return;
54:

Line 57: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

53: return;
54:
55: END IF; -- run mode
56: l_progress := 'Create_Attach_Item_Attr: 999';
57: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
58:
59: EXCEPTION
60: WHEN OTHERS THEN
61: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 111: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

107:
108: BEGIN
109:
110: l_progress := 'add_attribute_attachment: 000';
111: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);
112:
113: select hrtl2.location_code into l_template_name
114: from hr_locations_all_tl hrtl1, hr_locations_all_tl hrtl2
115: where hrtl1.location_id = hrtl2.location_id

Line 135: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

131: l_progress := 'add_attribute_attachment: 001 - ' ||
132: ' req_header_id = ' || l_requisition_header_id ||
133: ' req_line_id = ' || l_requisition_line_id ||
134: ' created_by = ' || l_created_by;
135: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);
136:
137: WHILE c_req_id%FOUND LOOP
138: -- Get Max Sequence Number and add 10
139: l_seq_num := 0;

Line 151: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

147: l_seq_num := l_seq_num + 10;
148:
149: l_progress := 'add_attribute_attachment: 002 - ' ||
150: ' l_seq_num = ' || l_seq_num;
151: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);
152:
153: -- Run procedure to get concatenated text string
154: get_attach_text(p_requisition_line_id => l_requisition_line_id,
155: p_requisition_header_id => l_requisition_header_id,

Line 161: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

157: p_text => l_text);
158:
159: l_progress := 'add_attribute_attachment: 003 - ' ||
160: ' l_text = ' || l_text;
161: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);
162:
163: IF (l_text IS NOT NULL) THEN
164: -- Run add_attachment API to add the attachment to FND tables
165: -- datatype_id is 2 because fnd doesn't support short text in 10.7

Line 173: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

169: ' l_file_name = ' || l_file_name ||
170: ' line_id = ' || l_requisition_line_id ||
171: ' l_created_by = ' || l_created_by;
172:
173: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);
174:
175:
176: begin
177:

Line 247: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

243: l_progress := 'add_attribute_attachment: 004 - ' ||
244: ' req_header_id = ' || l_requisition_header_id ||
245: ' req_line_id = ' || l_requisition_line_id ||
246: ' created_by = ' || l_created_by;
247: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);
248:
249: END LOOP;
250: CLOSE c_req_id;
251:

Line 256: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

252: EXCEPTION
253: when others then
254: l_progress := 'add_attribute_attachment: 005 - ' ||
255: 'exception';
256: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);
257:
258: END add_attribute_attachment;
259:
260: