APPS.PA_PCO_PKG dependencies on PA_DEBUG

Line 55: pa_debug.debug('100: Inside create_fnd_attachment');

51:
52:
53: begin
54:
55: pa_debug.debug('100: Inside create_fnd_attachment');
56:
57: /* sosharma The doc_category_name parameters are redundant now as we would be storing the attachments with category_id = 1 */
58: -- l_doc_category_name :=p_doc_category_name;
59: l_entity_name := p_entity_name;

Line 75: pa_debug.debug('200: Calling get_attachment_file_id ');

71:
72:
73: l_category_id := 1;
74:
75: pa_debug.debug('200: Calling get_attachment_file_id ');
76:
77: get_attachment_file_id
78: (p_entity_name,
79: p_CR_id,

Line 112: pa_debug.debug('300: x_media_id:' || x_media_id || ', l_file_name:' || l_file_name);

108:
109: end if;
110:
111:
112: pa_debug.debug('300: x_media_id:' || x_media_id || ', l_file_name:' || l_file_name);
113:
114: INSERT INTO fnd_lobs (
115: file_id
116: , File_name

Line 139: pa_debug.debug('400: After Insertion into fnd_lobs ');

135: , null
136: , null
137: , 'binary');
138:
139: pa_debug.debug('400: After Insertion into fnd_lobs ');
140:
141: select fnd_attached_documents_s.nextval
142: into l_attached_document_id
143: from dual;

Line 150: pa_debug.debug('500: Calling fnd_attached_documents_pkg.Insert_Row');

146: /* l_call_Insert_Row would be true only if its the first call for this version of the change request to create an attachment.
147: Only in that case, there is a need to insert records into fnd_documents and fnd_attached_documents
148: */
149: if (l_call_Insert_Row) then
150: pa_debug.debug('500: Calling fnd_attached_documents_pkg.Insert_Row');
151:
152: fnd_attached_documents_pkg.Insert_Row(
153: X_Rowid => X_Rowid
154: , X_attached_document_id => l_attached_document_id

Line 196: pa_debug.debug('600: After call to fnd_attached_documents_pkg.Insert_Row ');

192: , X_doc_attribute14 => NULL
193: , X_doc_attribute15 => NULL
194: );
195:
196: pa_debug.debug('600: After call to fnd_attached_documents_pkg.Insert_Row ');
197:
198: else
199: pa_debug.debug('700: Attachment records exist already, so not creating fresh records ');
200: end if;

Line 199: pa_debug.debug('700: Attachment records exist already, so not creating fresh records ');

195:
196: pa_debug.debug('600: After call to fnd_attached_documents_pkg.Insert_Row ');
197:
198: else
199: pa_debug.debug('700: Attachment records exist already, so not creating fresh records ');
200: end if;
201:
202: p_file_id := x_media_id;
203:

Line 207: pa_debug.debug('700: In exception block...');

203:
204: exception
205: when others then
206: p_file_id := null;
207: pa_debug.debug('700: In exception block...');
208: pa_debug.debug('SQLERRM:' || SQLERRM || ', SQLCODE:' || SQLCODE);
209: end create_fnd_attachment;
210:
211:

Line 208: pa_debug.debug('SQLERRM:' || SQLERRM || ', SQLCODE:' || SQLCODE);

204: exception
205: when others then
206: p_file_id := null;
207: pa_debug.debug('700: In exception block...');
208: pa_debug.debug('SQLERRM:' || SQLERRM || ', SQLCODE:' || SQLCODE);
209: end create_fnd_attachment;
210:
211:
212:

Line 243: pa_debug.debug('Inside get_attachment_file_id...');

239: l_file_id number;
240:
241: begin
242:
243: pa_debug.debug('Inside get_attachment_file_id...');
244:
245: select media_id
246: into l_file_id
247: from fnd_documents doc,

Line 257: pa_debug.debug('10: l_file_id = ' || l_file_id);

253: and nvl(ad.pk3_value,'-99') = nvl(p_pk3_value,nvl(ad.pk3_value,'-99'))
254: and nvl(ad.pk4_value,'-99') = nvl(p_pk4_value,nvl(ad.pk4_value,'-99'))
255: and nvl(ad.pk5_value,'-99') = NVL(p_pk5_value,nvl(ad.pk5_value,'-99'));
256:
257: pa_debug.debug('10: l_file_id = ' || l_file_id);
258: p_file_id := l_file_id;
259:
260: exception
261: when no_data_found then

Line 263: pa_debug.debug('20: returning null l_file_id');

259:
260: exception
261: when no_data_found then
262: p_file_id := null;
263: pa_debug.debug('20: returning null l_file_id');
264:
265: end get_attachment_file_id;
266:
267: end PA_PCO_PKG;