62: x_return_status := fnd_api.g_ret_sts_error;
63: x_msg_count := 0;
64: x_msg_data := NULL;
65:
66: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
67: fnd_log.string
68: (fnd_log.level_statement
69: , g_module || '.' || l_method
70: , l_step);
63: x_msg_count := 0;
64: x_msg_data := NULL;
65:
66: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
67: fnd_log.string
68: (fnd_log.level_statement
69: , g_module || '.' || l_method
70: , l_step);
71: END IF;
64: x_msg_data := NULL;
65:
66: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
67: fnd_log.string
68: (fnd_log.level_statement
69: , g_module || '.' || l_method
70: , l_step);
71: END IF;
72:
124:
125: l_step := 'After Calling hz_party_search.find_parties';
126:
127: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
128: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
129: fnd_log.string
130: (fnd_log.level_error
131: , g_module || '.' || l_method
132: , 'Error in hz_party_search.find_parties ' || x_msg_data);
125: l_step := 'After Calling hz_party_search.find_parties';
126:
127: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
128: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
129: fnd_log.string
130: (fnd_log.level_error
131: , g_module || '.' || l_method
132: , 'Error in hz_party_search.find_parties ' || x_msg_data);
133: END IF;
126:
127: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
128: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
129: fnd_log.string
130: (fnd_log.level_error
131: , g_module || '.' || l_method
132: , 'Error in hz_party_search.find_parties ' || x_msg_data);
133: END IF;
134: RETURN;
228: l_step := 'After Calling hz_party_v2pub.create_organization';
229:
230: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN
231:
232: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
233: fnd_log.string
234: (fnd_log.level_error
235: , g_module || '.' || l_method||'.'||l_step
236: , 'Error in hz_party_v2pub.create_organization ' || x_msg_data);
229:
230: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN
231:
232: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
233: fnd_log.string
234: (fnd_log.level_error
235: , g_module || '.' || l_method||'.'||l_step
236: , 'Error in hz_party_v2pub.create_organization ' || x_msg_data);
237: END IF;
230: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN
231:
232: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
233: fnd_log.string
234: (fnd_log.level_error
235: , g_module || '.' || l_method||'.'||l_step
236: , 'Error in hz_party_v2pub.create_organization ' || x_msg_data);
237: END IF;
238: RETURN;
265: x_contact_point_id => l_url_contact_point_id);
266:
267: IF l_url_return_status <> fnd_api.g_ret_sts_success THEN
268:
269: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
270: fnd_log.string(fnd_log.level_error,
271: g_module || '.' || l_method || '.' || l_step,
272: 'hz_contact_point_v2pub.create_web_contact_point ' ||
273: l_url_msg_data);
266:
267: IF l_url_return_status <> fnd_api.g_ret_sts_success THEN
268:
269: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
270: fnd_log.string(fnd_log.level_error,
271: g_module || '.' || l_method || '.' || l_step,
272: 'hz_contact_point_v2pub.create_web_contact_point ' ||
273: l_url_msg_data);
274: END IF;
297: l_method := 'update_supp_party_id';
298: l_step := 'update pos_supplier_registrations with partyid';
299:
300:
301: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
302: fnd_log.string
303: (fnd_log.level_statement
304: , g_module || '.' || l_method
305: , l_step);
298: l_step := 'update pos_supplier_registrations with partyid';
299:
300:
301: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
302: fnd_log.string
303: (fnd_log.level_statement
304: , g_module || '.' || l_method
305: , l_step);
306: END IF;
299:
300:
301: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
302: fnd_log.string
303: (fnd_log.level_statement
304: , g_module || '.' || l_method
305: , l_step);
306: END IF;
307:
315:
316: x_return_status := fnd_api.g_ret_sts_success;
317: Exception
318: When no_data_found then
319: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
320: fnd_log.string
321: (fnd_log.level_error
322: , g_module || '.' || l_method||'.'||l_step
323: , 'Error updating party id ');
316: x_return_status := fnd_api.g_ret_sts_success;
317: Exception
318: When no_data_found then
319: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
320: fnd_log.string
321: (fnd_log.level_error
322: , g_module || '.' || l_method||'.'||l_step
323: , 'Error updating party id ');
324: END IF;
317: Exception
318: When no_data_found then
319: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
320: fnd_log.string
321: (fnd_log.level_error
322: , g_module || '.' || l_method||'.'||l_step
323: , 'Error updating party id ');
324: END IF;
325: x_return_status := fnd_api.g_ret_sts_error;
404: l_step := 'After Calling hz_party_v2pub.update_Organization';
405:
406: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN
407:
408: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
409: fnd_log.string
410: (fnd_log.level_error
411: , g_module || '.' || l_method||'.'||l_step
412: , 'Error in hz_party_v2pub.update_organization ' || x_msg_data);
405:
406: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN
407:
408: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
409: fnd_log.string
410: (fnd_log.level_error
411: , g_module || '.' || l_method||'.'||l_step
412: , 'Error in hz_party_v2pub.update_organization ' || x_msg_data);
413: END IF;
406: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN
407:
408: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
409: fnd_log.string
410: (fnd_log.level_error
411: , g_module || '.' || l_method||'.'||l_step
412: , 'Error in hz_party_v2pub.update_organization ' || x_msg_data);
413: END IF;
414: RETURN;
454: x_return_status := fnd_api.g_ret_sts_error;
455: x_msg_count := 0;
456: x_msg_data := NULL;
457:
458: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
459: fnd_log.string(fnd_log.level_statement,
460: g_module || '.' || l_method,
461: l_step);
462: END IF;
455: x_msg_count := 0;
456: x_msg_data := NULL;
457:
458: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
459: fnd_log.string(fnd_log.level_statement,
460: g_module || '.' || l_method,
461: l_step);
462: END IF;
463:
492:
493: l_step := 'After Calling hz_party_search.search_duplicate_parties';
494:
495: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
496: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
497: fnd_log.string(fnd_log.level_error,
498: g_module || '.' || l_method,
499: 'Error in hz_party_search.search_duplicate_parties ' ||
500: x_msg_data);
493: l_step := 'After Calling hz_party_search.search_duplicate_parties';
494:
495: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
496: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
497: fnd_log.string(fnd_log.level_error,
498: g_module || '.' || l_method,
499: 'Error in hz_party_search.search_duplicate_parties ' ||
500: x_msg_data);
501: END IF;
537: x_return_status := fnd_api.g_ret_sts_error;
538: x_msg_count := 0;
539: x_msg_data := NULL;
540:
541: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
542: fnd_log.string(fnd_log.level_statement,
543: g_module || '.' || l_method,
544: l_step);
545: END IF;
538: x_msg_count := 0;
539: x_msg_data := NULL;
540:
541: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
542: fnd_log.string(fnd_log.level_statement,
543: g_module || '.' || l_method,
544: l_step);
545: END IF;
546:
558: l_vendor_rec.start_date_active := Sysdate;
559:
560: l_step := 'call pos_vendor_pub_pkg.create_vendor';
561:
562: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
563: fnd_log.string
564: (fnd_log.level_statement
565: , g_module || '.' || l_method
566: , l_step);
559:
560: l_step := 'call pos_vendor_pub_pkg.create_vendor';
561:
562: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
563: fnd_log.string
564: (fnd_log.level_statement
565: , g_module || '.' || l_method
566: , l_step);
567: END IF;
560: l_step := 'call pos_vendor_pub_pkg.create_vendor';
561:
562: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
563: fnd_log.string
564: (fnd_log.level_statement
565: , g_module || '.' || l_method
566: , l_step);
567: END IF;
568:
573: x_msg_data,
574: l_vendor_id,
575: l_party_id);
576:
577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
578: fnd_log.string
579: (fnd_log.level_statement
580: , g_module || '.' || l_method
581: , 'create_vendor call result: x_return_status ' || x_return_status
574: l_vendor_id,
575: l_party_id);
576:
577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
578: fnd_log.string
579: (fnd_log.level_statement
580: , g_module || '.' || l_method
581: , 'create_vendor call result: x_return_status ' || x_return_status
582: || ' x_msg_count ' || x_msg_count
575: l_party_id);
576:
577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
578: fnd_log.string
579: (fnd_log.level_statement
580: , g_module || '.' || l_method
581: , 'create_vendor call result: x_return_status ' || x_return_status
582: || ' x_msg_count ' || x_msg_count
583: || ' x_msg_data ' || x_msg_data
585: END IF;
586: l_step := 'After Calling pos_vendor_pub_pkg.create_vendor';
587:
588: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
589: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
590: fnd_log.string(fnd_log.level_error,
591: g_module || '.' || l_method,
592: 'Error in pos_vendor_pub_pkg.create_vendor' ||
593: x_msg_data);
586: l_step := 'After Calling pos_vendor_pub_pkg.create_vendor';
587:
588: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
589: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
590: fnd_log.string(fnd_log.level_error,
591: g_module || '.' || l_method,
592: 'Error in pos_vendor_pub_pkg.create_vendor' ||
593: x_msg_data);
594: END IF;
616: x_return_status := fnd_api.g_ret_sts_error;
617: x_msg_count := 0;
618: x_msg_data := NULL;
619:
620: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
621: fnd_log.string
622: (fnd_log.level_statement
623: , g_module || '.' || l_method
624: , l_step);
617: x_msg_count := 0;
618: x_msg_data := NULL;
619:
620: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
621: fnd_log.string
622: (fnd_log.level_statement
623: , g_module || '.' || l_method
624: , l_step);
625: END IF;
618: x_msg_data := NULL;
619:
620: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
621: fnd_log.string
622: (fnd_log.level_statement
623: , g_module || '.' || l_method
624: , l_step);
625: END IF;
626:
637: x_msg_data => x_msg_data);
638:
639: l_step := 'After Calling HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage';
640: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
641: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
642: fnd_log.string(fnd_log.level_error,
643: g_module || '.' || l_method,
644: 'Error in HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage' ||
645: x_msg_data);
638:
639: l_step := 'After Calling HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage';
640: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
641: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
642: fnd_log.string(fnd_log.level_error,
643: g_module || '.' || l_method,
644: 'Error in HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage' ||
645: x_msg_data);
646: END IF;
651:
652: EXCEPTION
653: WHEN OTHERS THEN
654: x_return_status :='E';
655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
656: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'Error while assigning usage ' , x_msg_data);
657: END IF;
658:
659: END assign_party_usage;
652: EXCEPTION
653: WHEN OTHERS THEN
654: x_return_status :='E';
655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
656: fnd_log.string(fnd_log.level_statement, g_module || '.' || 'Error while assigning usage ' , x_msg_data);
657: END IF;
658:
659: END assign_party_usage;
660: