29: BEGIN
30:
31: l_method := 'assign_address_type';
32: -- log_values p_party_site_id p_address_type
33: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
34: fnd_log.string( fnd_log.level_statement
35: , g_module || '.' || l_method
36: , ' p_party_site_id = ' || p_party_site_id
37: || ' p_address_type = ' || p_address_type
30:
31: l_method := 'assign_address_type';
32: -- log_values p_party_site_id p_address_type
33: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
34: fnd_log.string( fnd_log.level_statement
35: , g_module || '.' || l_method
36: , ' p_party_site_id = ' || p_party_site_id
37: || ' p_address_type = ' || p_address_type
38: );
38: );
39: END IF;
40:
41: l_step := 'check existing address type';
42: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
43: fnd_log.string
44: (fnd_log.level_statement
45: , g_module || '.' || l_method
46: , l_step
39: END IF;
40:
41: l_step := 'check existing address type';
42: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
43: fnd_log.string
44: (fnd_log.level_statement
45: , g_module || '.' || l_method
46: , l_step
47: );
40:
41: l_step := 'check existing address type';
42: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
43: fnd_log.string
44: (fnd_log.level_statement
45: , g_module || '.' || l_method
46: , l_step
47: );
48: END IF;
52: l_found := l_cur%found;
53: CLOSE l_cur;
54:
55: IF l_found THEN
56: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
57: fnd_log.string
58: (fnd_log.level_statement
59: , g_module || '.' || l_method
60: , l_step || ' found an existing record'
53: CLOSE l_cur;
54:
55: IF l_found THEN
56: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
57: fnd_log.string
58: (fnd_log.level_statement
59: , g_module || '.' || l_method
60: , l_step || ' found an existing record'
61: );
54:
55: IF l_found THEN
56: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
57: fnd_log.string
58: (fnd_log.level_statement
59: , g_module || '.' || l_method
60: , l_step || ' found an existing record'
61: );
62: END IF;
82: );
83:
84: -- log_callresult x_party_site_use_id
85: IF x_return_status = FND_API.g_ret_sts_success THEN
86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
87: fnd_log.string( fnd_log.level_statement
88: , g_module || '.' || l_method
89: , l_step || ' x_party_site_use_id = ' || x_party_site_use_id
90: );
83:
84: -- log_callresult x_party_site_use_id
85: IF x_return_status = FND_API.g_ret_sts_success THEN
86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
87: fnd_log.string( fnd_log.level_statement
88: , g_module || '.' || l_method
89: , l_step || ' x_party_site_use_id = ' || x_party_site_use_id
90: );
91: END IF;
89: , l_step || ' x_party_site_use_id = ' || x_party_site_use_id
90: );
91: END IF;
92: ELSE
93: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
94: fnd_log.string( fnd_log.level_error
95: , g_module || '.' || l_method
96: , l_step || ': x_return_status = ' || x_return_status
97: || ' x_msg_count = ' || x_msg_count
90: );
91: END IF;
92: ELSE
93: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
94: fnd_log.string( fnd_log.level_error
95: , g_module || '.' || l_method
96: , l_step || ': x_return_status = ' || x_return_status
97: || ' x_msg_count = ' || x_msg_count
98: || ', x_msg_data = ' || x_msg_data
127: BEGIN
128:
129: l_method := 'remove_address_type';
130: -- log_values p_party_site_id p_address_type
131: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
132: fnd_log.string( fnd_log.level_statement
133: , g_module || '.' || l_method
134: , ' p_party_site_id = ' || p_party_site_id
135: || ' p_address_type = ' || p_address_type
128:
129: l_method := 'remove_address_type';
130: -- log_values p_party_site_id p_address_type
131: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
132: fnd_log.string( fnd_log.level_statement
133: , g_module || '.' || l_method
134: , ' p_party_site_id = ' || p_party_site_id
135: || ' p_address_type = ' || p_address_type
136: );
136: );
137: END IF;
138:
139: l_step := 'check existing address type';
140: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
141: fnd_log.string
142: (fnd_log.level_statement
143: , g_module || '.' || l_method
144: , l_step
137: END IF;
138:
139: l_step := 'check existing address type';
140: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
141: fnd_log.string
142: (fnd_log.level_statement
143: , g_module || '.' || l_method
144: , l_step
145: );
138:
139: l_step := 'check existing address type';
140: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
141: fnd_log.string
142: (fnd_log.level_statement
143: , g_module || '.' || l_method
144: , l_step
145: );
146: END IF;
150: l_found := l_cur%found;
151: CLOSE l_cur;
152:
153: IF NOT l_found THEN
154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
155: fnd_log.string
156: (fnd_log.level_statement
157: , g_module || '.' || l_method
158: , l_step || ' existing record not found so no record to end-date.'
151: CLOSE l_cur;
152:
153: IF NOT l_found THEN
154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
155: fnd_log.string
156: (fnd_log.level_statement
157: , g_module || '.' || l_method
158: , l_step || ' existing record not found so no record to end-date.'
159: );
152:
153: IF NOT l_found THEN
154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
155: fnd_log.string
156: (fnd_log.level_statement
157: , g_module || '.' || l_method
158: , l_step || ' existing record not found so no record to end-date.'
159: );
160: END IF;
175: x_msg_data => x_msg_data
176: );
177:
178: IF x_return_status = FND_API.g_ret_sts_success THEN
179: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
180: fnd_log.string( fnd_log.level_statement
181: , g_module || '.' || l_method
182: , l_step || ' succeeded'
183: );
176: );
177:
178: IF x_return_status = FND_API.g_ret_sts_success THEN
179: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
180: fnd_log.string( fnd_log.level_statement
181: , g_module || '.' || l_method
182: , l_step || ' succeeded'
183: );
184: END IF;
182: , l_step || ' succeeded'
183: );
184: END IF;
185: ELSE
186: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
187: fnd_log.string( fnd_log.level_error
188: , g_module || '.' || l_method
189: , l_step || ': x_return_status = ' || x_return_status
190: || ' x_msg_count = ' || x_msg_count
183: );
184: END IF;
185: ELSE
186: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
187: fnd_log.string( fnd_log.level_error
188: , g_module || '.' || l_method
189: , l_step || ': x_return_status = ' || x_return_status
190: || ' x_msg_count = ' || x_msg_count
191: || ', x_msg_data = ' || x_msg_data
214: ELSE
215: l_step := 'call remove_address_type ';
216: END IF;
217:
218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
219: fnd_log.string
220: (fnd_log.level_statement
221: , g_module || '.' || l_method
222: , l_step || ' p_address_type = ' || p_address_type
215: l_step := 'call remove_address_type ';
216: END IF;
217:
218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
219: fnd_log.string
220: (fnd_log.level_statement
221: , g_module || '.' || l_method
222: , l_step || ' p_address_type = ' || p_address_type
223: || ' p_party_site_id = ' || p_party_site_id
216: END IF;
217:
218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
219: fnd_log.string
220: (fnd_log.level_statement
221: , g_module || '.' || l_method
222: , l_step || ' p_address_type = ' || p_address_type
223: || ' p_party_site_id = ' || p_party_site_id
224: );
879: l_vendor_contact_rec.vendor_contact_id := l_rec.vendor_contact_id;
880: l_vendor_contact_rec.org_contact_id := l_rec.org_contact_id;
881: l_vendor_contact_rec.party_site_id := l_rec.party_site_id;
882:
883: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
884: FND_LOG.string(fnd_log.level_statement, g_module,
885: ' Before Calling pos_vendor_pub_pkg.update_vendor_contact');
886: FND_LOG.string(fnd_log.level_statement, g_module,
887: ' per_party_id ' || p_contact_party_id);
880: l_vendor_contact_rec.org_contact_id := l_rec.org_contact_id;
881: l_vendor_contact_rec.party_site_id := l_rec.party_site_id;
882:
883: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
884: FND_LOG.string(fnd_log.level_statement, g_module,
885: ' Before Calling pos_vendor_pub_pkg.update_vendor_contact');
886: FND_LOG.string(fnd_log.level_statement, g_module,
887: ' per_party_id ' || p_contact_party_id);
888: FND_LOG.string(fnd_log.level_statement, g_module,
882:
883: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
884: FND_LOG.string(fnd_log.level_statement, g_module,
885: ' Before Calling pos_vendor_pub_pkg.update_vendor_contact');
886: FND_LOG.string(fnd_log.level_statement, g_module,
887: ' per_party_id ' || p_contact_party_id);
888: FND_LOG.string(fnd_log.level_statement, g_module,
889: ' org_party_site_id ' || p_org_party_site_id);
890: FND_LOG.string(fnd_log.level_statement, g_module,
884: FND_LOG.string(fnd_log.level_statement, g_module,
885: ' Before Calling pos_vendor_pub_pkg.update_vendor_contact');
886: FND_LOG.string(fnd_log.level_statement, g_module,
887: ' per_party_id ' || p_contact_party_id);
888: FND_LOG.string(fnd_log.level_statement, g_module,
889: ' org_party_site_id ' || p_org_party_site_id);
890: FND_LOG.string(fnd_log.level_statement, g_module,
891: ' rel_party_id ' || l_rec.rel_party_id);
892: FND_LOG.string(fnd_log.level_statement, g_module,
886: FND_LOG.string(fnd_log.level_statement, g_module,
887: ' per_party_id ' || p_contact_party_id);
888: FND_LOG.string(fnd_log.level_statement, g_module,
889: ' org_party_site_id ' || p_org_party_site_id);
890: FND_LOG.string(fnd_log.level_statement, g_module,
891: ' rel_party_id ' || l_rec.rel_party_id);
892: FND_LOG.string(fnd_log.level_statement, g_module,
893: ' relationship_id ' || l_rec.relationship_id);
894: FND_LOG.string(fnd_log.level_statement, g_module,
888: FND_LOG.string(fnd_log.level_statement, g_module,
889: ' org_party_site_id ' || p_org_party_site_id);
890: FND_LOG.string(fnd_log.level_statement, g_module,
891: ' rel_party_id ' || l_rec.rel_party_id);
892: FND_LOG.string(fnd_log.level_statement, g_module,
893: ' relationship_id ' || l_rec.relationship_id);
894: FND_LOG.string(fnd_log.level_statement, g_module,
895: ' vendor_site_id ' || l_rec.vendor_site_id);
896: FND_LOG.string(fnd_log.level_statement, g_module,
890: FND_LOG.string(fnd_log.level_statement, g_module,
891: ' rel_party_id ' || l_rec.rel_party_id);
892: FND_LOG.string(fnd_log.level_statement, g_module,
893: ' relationship_id ' || l_rec.relationship_id);
894: FND_LOG.string(fnd_log.level_statement, g_module,
895: ' vendor_site_id ' || l_rec.vendor_site_id);
896: FND_LOG.string(fnd_log.level_statement, g_module,
897: ' org_contact_id ' || l_rec.org_contact_id);
898:
892: FND_LOG.string(fnd_log.level_statement, g_module,
893: ' relationship_id ' || l_rec.relationship_id);
894: FND_LOG.string(fnd_log.level_statement, g_module,
895: ' vendor_site_id ' || l_rec.vendor_site_id);
896: FND_LOG.string(fnd_log.level_statement, g_module,
897: ' org_contact_id ' || l_rec.org_contact_id);
898:
899: END IF;
900:
909: x_msg_count => x_msg_count,
910: x_msg_data => x_msg_data
911: );
912:
913: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
914: FND_LOG.string(fnd_log.level_statement, g_module,
915: ' After Calling pos_vendor_pub_pkg.update_vendor_contact');
916: FND_LOG.string(fnd_log.level_statement, g_module,
917: ' x_return_status ' || x_return_status);
910: x_msg_data => x_msg_data
911: );
912:
913: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
914: FND_LOG.string(fnd_log.level_statement, g_module,
915: ' After Calling pos_vendor_pub_pkg.update_vendor_contact');
916: FND_LOG.string(fnd_log.level_statement, g_module,
917: ' x_return_status ' || x_return_status);
918: FND_LOG.string(fnd_log.level_statement, g_module,
912:
913: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
914: FND_LOG.string(fnd_log.level_statement, g_module,
915: ' After Calling pos_vendor_pub_pkg.update_vendor_contact');
916: FND_LOG.string(fnd_log.level_statement, g_module,
917: ' x_return_status ' || x_return_status);
918: FND_LOG.string(fnd_log.level_statement, g_module,
919: ' x_msg_count ' || x_msg_count);
920: FND_LOG.string(fnd_log.level_statement, g_module,
914: FND_LOG.string(fnd_log.level_statement, g_module,
915: ' After Calling pos_vendor_pub_pkg.update_vendor_contact');
916: FND_LOG.string(fnd_log.level_statement, g_module,
917: ' x_return_status ' || x_return_status);
918: FND_LOG.string(fnd_log.level_statement, g_module,
919: ' x_msg_count ' || x_msg_count);
920: FND_LOG.string(fnd_log.level_statement, g_module,
921: ' x_msg_data ' || x_msg_data);
922: END IF;
916: FND_LOG.string(fnd_log.level_statement, g_module,
917: ' x_return_status ' || x_return_status);
918: FND_LOG.string(fnd_log.level_statement, g_module,
919: ' x_msg_count ' || x_msg_count);
920: FND_LOG.string(fnd_log.level_statement, g_module,
921: ' x_msg_data ' || x_msg_data);
922: END IF;
923:
924: end loop;
970: l_vendor_contact_rec.vendor_contact_id := l_rec.vendor_contact_id;
971: l_vendor_contact_rec.org_contact_id := l_rec.org_contact_id;
972: l_vendor_contact_rec.party_site_id := l_rec.party_site_id;
973:
974: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
975: FND_LOG.string(fnd_log.level_statement, g_module,
976: ' Before Calling pos_vendor_pub_pkg.update_vendor_contact from update_address_to_contact');
977: FND_LOG.string(fnd_log.level_statement, g_module,
978: ' per_party_id ' || p_contact_party_id);
971: l_vendor_contact_rec.org_contact_id := l_rec.org_contact_id;
972: l_vendor_contact_rec.party_site_id := l_rec.party_site_id;
973:
974: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
975: FND_LOG.string(fnd_log.level_statement, g_module,
976: ' Before Calling pos_vendor_pub_pkg.update_vendor_contact from update_address_to_contact');
977: FND_LOG.string(fnd_log.level_statement, g_module,
978: ' per_party_id ' || p_contact_party_id);
979: FND_LOG.string(fnd_log.level_statement, g_module,
973:
974: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
975: FND_LOG.string(fnd_log.level_statement, g_module,
976: ' Before Calling pos_vendor_pub_pkg.update_vendor_contact from update_address_to_contact');
977: FND_LOG.string(fnd_log.level_statement, g_module,
978: ' per_party_id ' || p_contact_party_id);
979: FND_LOG.string(fnd_log.level_statement, g_module,
980: ' org_party_site_id ' || p_org_party_site_id);
981: FND_LOG.string(fnd_log.level_statement, g_module,
975: FND_LOG.string(fnd_log.level_statement, g_module,
976: ' Before Calling pos_vendor_pub_pkg.update_vendor_contact from update_address_to_contact');
977: FND_LOG.string(fnd_log.level_statement, g_module,
978: ' per_party_id ' || p_contact_party_id);
979: FND_LOG.string(fnd_log.level_statement, g_module,
980: ' org_party_site_id ' || p_org_party_site_id);
981: FND_LOG.string(fnd_log.level_statement, g_module,
982: ' rel_party_id ' || l_rec.rel_party_id);
983: FND_LOG.string(fnd_log.level_statement, g_module,
977: FND_LOG.string(fnd_log.level_statement, g_module,
978: ' per_party_id ' || p_contact_party_id);
979: FND_LOG.string(fnd_log.level_statement, g_module,
980: ' org_party_site_id ' || p_org_party_site_id);
981: FND_LOG.string(fnd_log.level_statement, g_module,
982: ' rel_party_id ' || l_rec.rel_party_id);
983: FND_LOG.string(fnd_log.level_statement, g_module,
984: ' relationship_id ' || l_rec.relationship_id);
985: FND_LOG.string(fnd_log.level_statement, g_module,
979: FND_LOG.string(fnd_log.level_statement, g_module,
980: ' org_party_site_id ' || p_org_party_site_id);
981: FND_LOG.string(fnd_log.level_statement, g_module,
982: ' rel_party_id ' || l_rec.rel_party_id);
983: FND_LOG.string(fnd_log.level_statement, g_module,
984: ' relationship_id ' || l_rec.relationship_id);
985: FND_LOG.string(fnd_log.level_statement, g_module,
986: ' vendor_site_id ' || l_rec.vendor_site_id);
987: FND_LOG.string(fnd_log.level_statement, g_module,
981: FND_LOG.string(fnd_log.level_statement, g_module,
982: ' rel_party_id ' || l_rec.rel_party_id);
983: FND_LOG.string(fnd_log.level_statement, g_module,
984: ' relationship_id ' || l_rec.relationship_id);
985: FND_LOG.string(fnd_log.level_statement, g_module,
986: ' vendor_site_id ' || l_rec.vendor_site_id);
987: FND_LOG.string(fnd_log.level_statement, g_module,
988: ' org_contact_id ' || l_rec.org_contact_id);
989:
983: FND_LOG.string(fnd_log.level_statement, g_module,
984: ' relationship_id ' || l_rec.relationship_id);
985: FND_LOG.string(fnd_log.level_statement, g_module,
986: ' vendor_site_id ' || l_rec.vendor_site_id);
987: FND_LOG.string(fnd_log.level_statement, g_module,
988: ' org_contact_id ' || l_rec.org_contact_id);
989:
990: END IF;
991:
1000: x_msg_count => x_msg_count,
1001: x_msg_data => x_msg_data
1002: );
1003:
1004: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1005: FND_LOG.string(fnd_log.level_statement, g_module,
1006: ' After Calling pos_vendor_pub_pkg.update_vendor_contact from update_address_to_contact');
1007: FND_LOG.string(fnd_log.level_statement, g_module,
1008: ' x_return_status ' || x_return_status);
1001: x_msg_data => x_msg_data
1002: );
1003:
1004: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1005: FND_LOG.string(fnd_log.level_statement, g_module,
1006: ' After Calling pos_vendor_pub_pkg.update_vendor_contact from update_address_to_contact');
1007: FND_LOG.string(fnd_log.level_statement, g_module,
1008: ' x_return_status ' || x_return_status);
1009: FND_LOG.string(fnd_log.level_statement, g_module,
1003:
1004: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1005: FND_LOG.string(fnd_log.level_statement, g_module,
1006: ' After Calling pos_vendor_pub_pkg.update_vendor_contact from update_address_to_contact');
1007: FND_LOG.string(fnd_log.level_statement, g_module,
1008: ' x_return_status ' || x_return_status);
1009: FND_LOG.string(fnd_log.level_statement, g_module,
1010: ' x_msg_count ' || x_msg_count);
1011: FND_LOG.string(fnd_log.level_statement, g_module,
1005: FND_LOG.string(fnd_log.level_statement, g_module,
1006: ' After Calling pos_vendor_pub_pkg.update_vendor_contact from update_address_to_contact');
1007: FND_LOG.string(fnd_log.level_statement, g_module,
1008: ' x_return_status ' || x_return_status);
1009: FND_LOG.string(fnd_log.level_statement, g_module,
1010: ' x_msg_count ' || x_msg_count);
1011: FND_LOG.string(fnd_log.level_statement, g_module,
1012: ' x_msg_data ' || x_msg_data);
1013: END IF;
1007: FND_LOG.string(fnd_log.level_statement, g_module,
1008: ' x_return_status ' || x_return_status);
1009: FND_LOG.string(fnd_log.level_statement, g_module,
1010: ' x_msg_count ' || x_msg_count);
1011: FND_LOG.string(fnd_log.level_statement, g_module,
1012: ' x_msg_data ' || x_msg_data);
1013: END IF;
1014:
1015: end loop;
1129:
1130: /* Bug 12983048 - Start */
1131: l_vendor_contact_rec.vendor_id := p_vendor_id;
1132:
1133: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1134: FND_LOG.string(fnd_log.level_statement, g_module,
1135: 'Before Call to pos_vendor_pub_pkg.create_vendor_contact, vendor_id is : ' || l_vendor_contact_rec.vendor_id);
1136: END IF;
1137: /* Bug 12983048 - End */
1130: /* Bug 12983048 - Start */
1131: l_vendor_contact_rec.vendor_id := p_vendor_id;
1132:
1133: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1134: FND_LOG.string(fnd_log.level_statement, g_module,
1135: 'Before Call to pos_vendor_pub_pkg.create_vendor_contact, vendor_id is : ' || l_vendor_contact_rec.vendor_id);
1136: END IF;
1137: /* Bug 12983048 - End */
1138:
1158: /* Bug 6599374 End */
1159:
1160: l_step := 3;
1161:
1162: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1163: FND_LOG.string(fnd_log.level_statement, g_module,
1164: ' Before Calling pos_vendor_pub_pkg.create_vendor_contact');
1165: FND_LOG.string(fnd_log.level_statement, g_module,
1166: ' per_party_id ' || p_contact_party_id);
1159:
1160: l_step := 3;
1161:
1162: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1163: FND_LOG.string(fnd_log.level_statement, g_module,
1164: ' Before Calling pos_vendor_pub_pkg.create_vendor_contact');
1165: FND_LOG.string(fnd_log.level_statement, g_module,
1166: ' per_party_id ' || p_contact_party_id);
1167: FND_LOG.string(fnd_log.level_statement, g_module,
1161:
1162: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1163: FND_LOG.string(fnd_log.level_statement, g_module,
1164: ' Before Calling pos_vendor_pub_pkg.create_vendor_contact');
1165: FND_LOG.string(fnd_log.level_statement, g_module,
1166: ' per_party_id ' || p_contact_party_id);
1167: FND_LOG.string(fnd_log.level_statement, g_module,
1168: ' org_party_site_id ' || p_org_party_site_id);
1169: FND_LOG.string(fnd_log.level_statement, g_module,
1163: FND_LOG.string(fnd_log.level_statement, g_module,
1164: ' Before Calling pos_vendor_pub_pkg.create_vendor_contact');
1165: FND_LOG.string(fnd_log.level_statement, g_module,
1166: ' per_party_id ' || p_contact_party_id);
1167: FND_LOG.string(fnd_log.level_statement, g_module,
1168: ' org_party_site_id ' || p_org_party_site_id);
1169: FND_LOG.string(fnd_log.level_statement, g_module,
1170: ' rel_party_id ' || l_rec3.rel_party_id);
1171: FND_LOG.string(fnd_log.level_statement, g_module,
1165: FND_LOG.string(fnd_log.level_statement, g_module,
1166: ' per_party_id ' || p_contact_party_id);
1167: FND_LOG.string(fnd_log.level_statement, g_module,
1168: ' org_party_site_id ' || p_org_party_site_id);
1169: FND_LOG.string(fnd_log.level_statement, g_module,
1170: ' rel_party_id ' || l_rec3.rel_party_id);
1171: FND_LOG.string(fnd_log.level_statement, g_module,
1172: ' relationship_id ' || l_rec3.relationship_id);
1173: END IF;
1167: FND_LOG.string(fnd_log.level_statement, g_module,
1168: ' org_party_site_id ' || p_org_party_site_id);
1169: FND_LOG.string(fnd_log.level_statement, g_module,
1170: ' rel_party_id ' || l_rec3.rel_party_id);
1171: FND_LOG.string(fnd_log.level_statement, g_module,
1172: ' relationship_id ' || l_rec3.relationship_id);
1173: END IF;
1174:
1175: pos_vendor_pub_pkg.create_vendor_contact
1186: );
1187:
1188: l_step := 4;
1189:
1190: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1191: FND_LOG.string(fnd_log.level_statement, g_module,
1192: ' After Calling pos_vendor_pub_pkg.create_vendor_contact');
1193: FND_LOG.string(fnd_log.level_statement, g_module,
1194: ' x_return_status ' || x_return_status);
1187:
1188: l_step := 4;
1189:
1190: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1191: FND_LOG.string(fnd_log.level_statement, g_module,
1192: ' After Calling pos_vendor_pub_pkg.create_vendor_contact');
1193: FND_LOG.string(fnd_log.level_statement, g_module,
1194: ' x_return_status ' || x_return_status);
1195: FND_LOG.string(fnd_log.level_statement, g_module,
1189:
1190: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1191: FND_LOG.string(fnd_log.level_statement, g_module,
1192: ' After Calling pos_vendor_pub_pkg.create_vendor_contact');
1193: FND_LOG.string(fnd_log.level_statement, g_module,
1194: ' x_return_status ' || x_return_status);
1195: FND_LOG.string(fnd_log.level_statement, g_module,
1196: ' x_msg_count ' || x_msg_count);
1197: FND_LOG.string(fnd_log.level_statement, g_module,
1191: FND_LOG.string(fnd_log.level_statement, g_module,
1192: ' After Calling pos_vendor_pub_pkg.create_vendor_contact');
1193: FND_LOG.string(fnd_log.level_statement, g_module,
1194: ' x_return_status ' || x_return_status);
1195: FND_LOG.string(fnd_log.level_statement, g_module,
1196: ' x_msg_count ' || x_msg_count);
1197: FND_LOG.string(fnd_log.level_statement, g_module,
1198: ' x_msg_data ' || x_msg_data);
1199: END IF;
1193: FND_LOG.string(fnd_log.level_statement, g_module,
1194: ' x_return_status ' || x_return_status);
1195: FND_LOG.string(fnd_log.level_statement, g_module,
1196: ' x_msg_count ' || x_msg_count);
1197: FND_LOG.string(fnd_log.level_statement, g_module,
1198: ' x_msg_data ' || x_msg_data);
1199: END IF;
1200:
1201: EXCEPTION
1260: x_msg_count => x_msg_count,
1261: x_msg_data => x_msg_data
1262: );
1263:
1264: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1265: FND_LOG.string(fnd_log.level_statement, g_module,
1266: ' After Calling AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF ');
1267: FND_LOG.string(fnd_log.level_statement, g_module,
1268: ' x_return_status ' || x_return_status);
1261: x_msg_data => x_msg_data
1262: );
1263:
1264: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1265: FND_LOG.string(fnd_log.level_statement, g_module,
1266: ' After Calling AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF ');
1267: FND_LOG.string(fnd_log.level_statement, g_module,
1268: ' x_return_status ' || x_return_status);
1269: FND_LOG.string(fnd_log.level_statement, g_module,
1263:
1264: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1265: FND_LOG.string(fnd_log.level_statement, g_module,
1266: ' After Calling AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF ');
1267: FND_LOG.string(fnd_log.level_statement, g_module,
1268: ' x_return_status ' || x_return_status);
1269: FND_LOG.string(fnd_log.level_statement, g_module,
1270: ' x_msg_count ' || x_msg_count);
1271: FND_LOG.string(fnd_log.level_statement, g_module,
1265: FND_LOG.string(fnd_log.level_statement, g_module,
1266: ' After Calling AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF ');
1267: FND_LOG.string(fnd_log.level_statement, g_module,
1268: ' x_return_status ' || x_return_status);
1269: FND_LOG.string(fnd_log.level_statement, g_module,
1270: ' x_msg_count ' || x_msg_count);
1271: FND_LOG.string(fnd_log.level_statement, g_module,
1272: ' x_msg_data ' || x_msg_data);
1273: END IF;
1267: FND_LOG.string(fnd_log.level_statement, g_module,
1268: ' x_return_status ' || x_return_status);
1269: FND_LOG.string(fnd_log.level_statement, g_module,
1270: ' x_msg_count ' || x_msg_count);
1271: FND_LOG.string(fnd_log.level_statement, g_module,
1272: ' x_msg_data ' || x_msg_data);
1273: END IF;
1274:
1275: EXCEPTION