eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OID_USERS dependencies on FND_API

Line 25: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

21:
22: begin
23: l_module_source := G_MODULE_SOURCE || 'hz_create';
24:
25: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
26:
27: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
28: then
29: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

Line 47: if (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) then

43: fnd_oid_users.create_party(p_ldap_message => p_ldap_message,
44: x_return_status => x_return_status);
45: end if;
46:
47: if (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) then
48: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
49: then
50: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Party ' ||
51: p_ldap_message.givenName || ', ' || p_ldap_message.sn || ' created successfully');

Line 134: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

130: p_action_type => G_CREATE,
131: x_person_rec => x_person_rec,
132: x_return_status => x_return_status);
133:
134: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
135: then
136: raise l_tca_error;
137: end if;
138:

Line 139: hz_party_v2pub.create_person(p_init_msg_list => fnd_api.G_TRUE,

135: then
136: raise l_tca_error;
137: end if;
138:
139: hz_party_v2pub.create_person(p_init_msg_list => fnd_api.G_TRUE,
140: p_person_rec => x_person_rec,
141: x_party_id => x_party_id,
142: x_party_number => x_party_number,
143: x_profile_id => x_profile_id,

Line 148: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

144: x_return_status => x_return_status,
145: x_msg_count => x_msg_count,
146: x_msg_data => x_msg_data);
147:
148: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
149: then
150: raise l_tca_error;
151: end if;
152:

Line 161: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

157: p_owner_table_id => x_party_id,
158: p_status => G_ACTIVE,
159: x_return_status => x_return_status);
160:
161: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
162: then
163: raise l_tca_error;
164: end if;
165:

Line 199: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

195: for i in 1..x_msg_count
196: loop
197: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
198: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
199: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
200: end loop;
201: else
202: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
203: , 'x_return_status = ' || x_return_status);

Line 245: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

241: p_action_type => G_CREATE,
242: x_contact_point_rec => x_contact_point_rec,
243: x_return_status => x_return_status);
244:
245: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
246: then
247: raise l_tca_error;
248: end if;
249:

Line 261: p_init_msg_list => fnd_api.G_TRUE,

257: l_phone_rec.phone_number := p_ldap_message.homePhone;
258: end if;
259:
260: hz_contact_point_v2pub.create_phone_contact_point(
261: p_init_msg_list => fnd_api.G_TRUE,
262: p_contact_point_rec => x_contact_point_rec,
263: p_phone_rec => l_phone_rec,
264: x_contact_point_id => x_contact_point_id,
265: x_return_status => x_return_status,

Line 269: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

265: x_return_status => x_return_status,
266: x_msg_count => x_msg_count,
267: x_msg_data => x_msg_data);
268:
269: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
270: then
271: raise l_tca_error;
272: end if;
273:

Line 282: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

278: p_owner_table_id => x_contact_point_id,
279: p_status => G_ACTIVE,
280: x_return_status => x_return_status);
281:
282: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
283: then
284: raise l_tca_error;
285: end if;
286:

Line 302: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

298: for i in 1..x_msg_count
299: loop
300: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
301: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
302: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
303: end loop;
304: else
305: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
306: , 'x_return_status = ' || x_return_status);

Line 347: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

343: p_action_type => G_CREATE,
344: x_contact_point_rec => x_contact_point_rec,
345: x_return_status => x_return_status);
346:
347: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
348: then
349: raise l_tca_error;
350: end if;
351:

Line 355: p_init_msg_list => fnd_api.G_TRUE,

351:
352: p_email_rec.email_address := p_ldap_message.mail;
353:
354: hz_contact_point_v2pub.create_email_contact_point(
355: p_init_msg_list => fnd_api.G_TRUE,
356: p_contact_point_rec => x_contact_point_rec,
357: p_email_rec => p_email_rec,
358: x_contact_point_id => x_contact_point_id,
359: x_return_status => x_return_status,

Line 363: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

359: x_return_status => x_return_status,
360: x_msg_count => x_msg_count,
361: x_msg_data => x_msg_data);
362:
363: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
364: then
365: raise l_tca_error;
366: end if;
367:

Line 376: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

372: p_owner_table_id => x_contact_point_id,
373: p_status => G_ACTIVE,
374: x_return_status => x_return_status);
375:
376: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
377: then
378: raise l_tca_error;
379: end if;
380:

Line 396: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

392: for i in 1..x_msg_count
393: loop
394: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
395: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
396: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
397: end loop;
398: else
399: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
400: , 'x_return_status = ' || x_return_status);

Line 427: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

423:
424: begin
425: l_module_source := G_MODULE_SOURCE || 'create_location';
426:
427: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
428:
429: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
430: then
431: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

Line 442: hz_location_v2pub.create_location(p_init_msg_list => fnd_api.G_TRUE,

438: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
439: then
440: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Country is not null' || x_location_rec.country);
441: end if;
442: hz_location_v2pub.create_location(p_init_msg_list => fnd_api.G_TRUE,
443: p_location_rec => x_location_rec,
444: x_location_id => x_location_id,
445: x_return_status => x_return_status,
446: x_msg_count => x_msg_count,

Line 449: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

445: x_return_status => x_return_status,
446: x_msg_count => x_msg_count,
447: x_msg_data => x_msg_data);
448:
449: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
450: then
451: raise l_tca_error;
452: end if;
453:

Line 459: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

455: p_ldap_message => p_ldap_message,
456: p_location_id => x_location_id,
457: x_return_status => x_return_status);
458:
459: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
460: then
461: raise l_tca_error;
462: end if;
463: end if;

Line 480: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

476: for i in 1..x_msg_count
477: loop
478: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
479: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
480: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
481: end loop;
482: else
483: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
484: , 'x_return_status = ' || x_return_status);

Line 525: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

521: x_party_site_rec => x_party_site_rec,
522: x_return_status => x_return_status);
523: x_party_site_rec.location_id := p_location_id;
524:
525: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
526: then
527: raise l_tca_error;
528: end if;
529:

Line 531: p_init_msg_list => fnd_api.G_TRUE,

527: raise l_tca_error;
528: end if;
529:
530: hz_party_site_v2pub.create_party_site(
531: p_init_msg_list => fnd_api.G_TRUE,
532: P_party_site_rec => x_party_site_rec,
533: x_party_site_id => x_party_site_id,
534: x_party_site_number => x_party_site_number,
535: x_return_status => x_return_status,

Line 539: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

535: x_return_status => x_return_status,
536: x_msg_count => x_msg_count,
537: x_msg_data => x_msg_data);
538:
539: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
540: then
541: raise l_tca_error;
542: end if;
543:

Line 552: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

548: p_owner_table_id => x_party_site_id,
549: p_status => G_ACTIVE,
550: x_return_status => x_return_status);
551:
552: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
553: then
554: raise l_tca_error;
555: end if;
556:

Line 572: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

568: for i in 1..x_msg_count
569: loop
570: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
571: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
572: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
573: end loop;
574: else
575: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
576: , 'x_return_status = ' || x_return_status);

Line 695: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

691: p_action_type => G_UPDATE,
692: x_person_rec => x_person_rec,
693: x_return_status => x_return_status);
694:
695: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
696: then
697: raise l_tca_error;
698: end if;
699:

Line 705: p_init_msg_list => fnd_api.G_TRUE

701: into l_object_version_number
702: from hz_parties where party_id = x_person_rec.party_rec.party_id;
703:
704: hz_party_v2pub.update_person(
705: p_init_msg_list => fnd_api.G_TRUE
706: , p_person_rec => x_person_rec
707: , p_party_object_version_number => l_object_version_number
708: , x_profile_id => x_profile_id
709: , x_return_status => x_return_status

Line 713: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

709: , x_return_status => x_return_status
710: , x_msg_count => x_msg_count
711: , x_msg_data => x_msg_data);
712:
713: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
714: then
715: raise l_tca_error;
716: end if;
717:

Line 733: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

729: for i in 1..x_msg_count
730: loop
731: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
732: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
733: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
734: end loop;
735: else
736: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
737: , 'x_return_status = ' || x_return_status);

Line 780: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

776: x_contact_point_rec => x_contact_point_rec,
777: x_return_status => x_return_status);
778: /*
779: commented this code because anytime a phone record does not exist the return status is E
780: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
781: then
782: raise l_tca_error;
783: end if;
784: */

Line 804: p_init_msg_list => fnd_api.G_TRUE,

800: end if;
801:
802:
803: hz_contact_point_v2pub.update_phone_contact_point(
804: p_init_msg_list => fnd_api.G_TRUE,
805: p_contact_point_rec => x_contact_point_rec,
806: p_phone_rec => l_phone_rec,
807: p_object_version_number =>l_object_version_number,
808: x_return_status => x_return_status,

Line 812: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

808: x_return_status => x_return_status,
809: x_msg_count => x_msg_count,
810: x_msg_data => x_msg_data);
811:
812: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
813: then
814: raise l_tca_error;
815: end if;
816:

Line 825: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

821: p_contact_point_purpose => p_contact_point_purpose,
822: x_return_status => x_return_status);
823: end if;
824:
825: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
826: then
827: raise l_tca_error;
828: end if;
829:

Line 845: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

841: for i in 1..x_msg_count
842: loop
843: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
844: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
845: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
846: end loop;
847: else
848: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
849: , 'x_return_status = ' || x_return_status);

Line 891: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

887: x_contact_point_rec => x_contact_point_rec,
888: x_return_status => x_return_status);
889: /*
890: commented this out because an E is returned if the email does not exist
891: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
892: then
893: raise l_tca_error;
894: end if;
895: */

Line 907: p_init_msg_list => fnd_api.G_TRUE,

903:
904: p_email_rec.email_address := p_ldap_message.mail;
905:
906: hz_contact_point_v2pub.update_email_contact_point(
907: p_init_msg_list => fnd_api.G_TRUE,
908: p_contact_point_rec => x_contact_point_rec,
909: p_email_rec => p_email_rec,
910: p_object_version_number =>l_object_version_number,
911: x_return_status => x_return_status,

Line 921: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

917: fnd_oid_users.create_email_contact_point(p_ldap_message => p_ldap_message,
918: x_return_status => x_return_status);
919: end if;
920:
921: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
922: then
923: raise l_tca_error;
924: end if;
925:

Line 941: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

937: for i in 1..x_msg_count
938: loop
939: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
940: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
941: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
942: end loop;
943: else
944: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
945: , 'x_return_status = ' || x_return_status);

Line 987: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

983: x_party_site_rec => x_party_site_rec,
984: x_return_status => x_return_status);
985:
986: /* commenting this out as TCA returns Error if the party site is not found
987: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
988: then
989: raise l_tca_error;
990: end if;
991: */

Line 1019: p_init_msg_list => fnd_api.G_TRUE,

1015:
1016: x_location_rec.location_id := l_location_id;
1017:
1018: hz_location_v2pub.update_location (
1019: p_init_msg_list => fnd_api.G_TRUE,
1020: p_location_rec => x_location_rec,
1021: p_object_version_number =>p_object_version_number,
1022: x_return_status => x_return_status,
1023: x_msg_count => x_msg_count,

Line 1029: p_init_msg_list => fnd_api.G_TRUE,

1025:
1026:
1027:
1028: hz_party_site_v2pub.update_party_site(
1029: p_init_msg_list => fnd_api.G_TRUE,
1030: p_party_site_rec => x_party_site_rec,
1031: p_object_version_number =>l_object_version_number,
1032: x_return_status => x_return_status,
1033: x_msg_count => x_msg_count,

Line 1036: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

1032: x_return_status => x_return_status,
1033: x_msg_count => x_msg_count,
1034: x_msg_data => x_msg_data);
1035:
1036: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
1037: then
1038: raise l_tca_error;
1039: end if;
1040: else -- no location id

Line 1041: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

1037: then
1038: raise l_tca_error;
1039: end if;
1040: else -- no location id
1041: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
1042: then
1043: raise l_tca_error;
1044: end if;
1045: end if;

Line 1052: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

1048: fnd_oid_users.create_location(p_ldap_message => p_ldap_message,
1049: x_return_status => x_return_status);
1050:
1051: end if;
1052: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
1053: then
1054: raise l_tca_error;
1055: end if;
1056:

Line 1072: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

1068: for i in 1..x_msg_count
1069: loop
1070: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
1071: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1072: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1073: end loop;
1074: else
1075: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1076: , 'x_return_status = ' || x_return_status);

Line 1142: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

1138: , p_owner_table_name => G_HZ_PARTIES
1139: , x_owner_table_id => l_owner_table_id
1140: , x_return_status => x_return_status);
1141:
1142: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
1143: then
1144: raise l_tca_error;
1145: end if;
1146:

Line 1162: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1158: then
1159: x_person_rec.person_first_name := p_ldap_message.givenName;
1160: end if;
1161:
1162: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1163:
1164: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1165: then
1166: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

Line 1254: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

1250: p_owner_table_name => G_HZ_CONTACT_POINTS,
1251: x_owner_table_id => l_owner_table_id,
1252: x_return_status => x_return_status);
1253:
1254: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
1255: then
1256: raise l_tca_error;
1257: end if;
1258:

Line 1437: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

1433: , p_owner_table_name => G_HZ_PARTY_SITES
1434: , x_owner_table_id => l_owner_table_id
1435: , x_return_status => x_return_status);
1436:
1437: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
1438: then
1439: raise l_tca_error;
1440: end if;
1441:

Line 1452: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1448: end if;
1449:
1450: x_party_site_rec.created_by_module := G_FND_OID_SYNCH;
1451:
1452: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1453:
1454: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1455: then
1456: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

Line 1566: if (x_return_status = fnd_api.G_RET_STS_UNEXP_ERROR)

1562: p_owner_table_name => p_owner_table_name,
1563: x_owner_table_id => l_owner_table_id,
1564: x_return_status => x_return_status);
1565:
1566: if (x_return_status = fnd_api.G_RET_STS_UNEXP_ERROR)
1567: then
1568: raise l_tca_error;
1569: end if;
1570:

Line 1582: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

1578: p_owner_table_id => p_owner_table_id,
1579: p_status => G_ACTIVE,
1580: x_return_status => x_return_status);
1581:
1582: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
1583: then
1584: raise l_tca_error;
1585: end if;
1586:

Line 1590: p_init_msg_list => fnd_api.G_TRUE,

1586:
1587: else
1588:
1589: hz_orig_system_ref_pub.create_orig_system_reference(
1590: p_init_msg_list => fnd_api.G_TRUE,
1591: p_orig_sys_reference_rec => l_orig_sys_rec,
1592: x_return_status => x_return_status,
1593: x_msg_count => x_msg_count,
1594: x_msg_data => x_msg_data);

Line 1596: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

1592: x_return_status => x_return_status,
1593: x_msg_count => x_msg_count,
1594: x_msg_data => x_msg_data);
1595:
1596: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
1597: then
1598: raise l_tca_error;
1599: end if;
1600:

Line 1618: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

1614: for i in 1..x_msg_count
1615: loop
1616: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
1617: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1618: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1619: end loop;
1620: else
1621: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1622: , 'x_return_status = ' || x_return_status);

Line 1681: p_init_msg_list => fnd_api.G_TRUE,

1677: l_orig_sys_rec.owner_table_name := p_owner_table_name;
1678: l_orig_sys_rec.owner_table_id := p_owner_table_id;
1679:
1680: hz_orig_system_ref_pub.update_orig_system_reference(
1681: p_init_msg_list => fnd_api.G_TRUE,
1682: p_orig_sys_reference_rec => l_orig_sys_rec,
1683: p_object_version_number => l_object_version_number,
1684: x_return_status => x_return_status,
1685: x_msg_count => x_msg_count,

Line 1688: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

1684: x_return_status => x_return_status,
1685: x_msg_count => x_msg_count,
1686: x_msg_data => x_msg_data);
1687:
1688: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)
1689: then
1690: raise l_tca_error;
1691: end if;
1692:

Line 1708: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));

1704: for i in 1..x_msg_count
1705: loop
1706: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
1707: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1708: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1709: end loop;
1710: else
1711: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1712: , 'x_return_status = ' || x_return_status);