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.HZ_DYN_VALIDATION dependencies on FND_LOG

Line 89: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

85: l_party_id NUMBER(15);
86: l_debug_prefix VARCHAR2(30) := '';
87: BEGIN
88: -- Debug info.
89: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
90: hz_utility_v2pub.debug(p_message=>'create party',
91: p_prefix =>l_debug_prefix,
92: p_msg_level=>fnd_log.level_statement);
93: END IF;

Line 92: p_msg_level=>fnd_log.level_statement);

88: -- Debug info.
89: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
90: hz_utility_v2pub.debug(p_message=>'create party',
91: p_prefix =>l_debug_prefix,
92: p_msg_level=>fnd_log.level_statement);
93: END IF;
94:
95:
96: -- Get the party ID.

Line 178: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

174: x_party.attribute23,
175: x_party.attribute24);
176:
177: -- Debug info.
178: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
179: hz_utility_v2pub.debug(p_message=>' returning party ID='||l_party_id,
180: p_prefix =>l_debug_prefix,
181: p_msg_level=>fnd_log.level_statement);
182: END IF;

Line 181: p_msg_level=>fnd_log.level_statement);

177: -- Debug info.
178: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
179: hz_utility_v2pub.debug(p_message=>' returning party ID='||l_party_id,
180: p_prefix =>l_debug_prefix,
181: p_msg_level=>fnd_log.level_statement);
182: END IF;
183:
184: RETURN l_party_id;
185: END create_party_gt;

Line 215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

211: l_party_id NUMBER(15);
212: l_debug_prefix VARCHAR2(30) := '';
213: BEGIN
214: -- Debug info.
215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'create relationship',
217: p_prefix =>l_debug_prefix,
218: p_msg_level=>fnd_log.level_statement);
219: END IF;

Line 218: p_msg_level=>fnd_log.level_statement);

214: -- Debug info.
215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'create relationship',
217: p_prefix =>l_debug_prefix,
218: p_msg_level=>fnd_log.level_statement);
219: END IF;
220:
221: -- Create the party record
222: l_party_id := create_party_gt(x_relationship.party_rec);

Line 347: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

343: -- Added for Bug 2776412
344: l_return_status VARCHAR2(1);
345: BEGIN
346: -- Debug info.
347: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
348: hz_utility_v2pub.debug(p_message=>'exec_procedure (' || x_profile_name|| ',' || x_temp_id || ')',
349: p_prefix =>l_debug_prefix,
350: p_msg_level=>fnd_log.level_statement);
351: END IF;

Line 350: p_msg_level=>fnd_log.level_statement);

346: -- Debug info.
347: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
348: hz_utility_v2pub.debug(p_message=>'exec_procedure (' || x_profile_name|| ',' || x_temp_id || ')',
349: p_prefix =>l_debug_prefix,
350: p_msg_level=>fnd_log.level_statement);
351: END IF;
352:
353: -- initialize API return status to success
354: l_return_status := fnd_api.g_ret_sts_success;

Line 368: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

364: RAISE hz_dyn_validation.null_profile_value;
365: END IF;
366:
367: -- Debug info.
368: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(p_message=>' l_procedure_name=' || l_procedure_name,
370: p_prefix =>l_debug_prefix,
371: p_msg_level=>fnd_log.level_statement);
372: END IF;

Line 371: p_msg_level=>fnd_log.level_statement);

367: -- Debug info.
368: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(p_message=>' l_procedure_name=' || l_procedure_name,
370: p_prefix =>l_debug_prefix,
371: p_msg_level=>fnd_log.level_statement);
372: END IF;
373:
374: -- Create the execution string.
375:

Line 379: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

375:
376: l_exec_string := 'BEGIN ' || l_procedure_name ||
377: '(' ||x_temp_id|| ',:l_return_status); END;'; -- Bug 2776412
378:
379: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
380: hz_utility_v2pub.debug(p_message=>' Executing: ' || l_exec_string,
381: p_prefix =>l_debug_prefix,
382: p_msg_level=>fnd_log.level_statement);
383: END IF;

Line 382: p_msg_level=>fnd_log.level_statement);

378:
379: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
380: hz_utility_v2pub.debug(p_message=>' Executing: ' || l_exec_string,
381: p_prefix =>l_debug_prefix,
382: p_msg_level=>fnd_log.level_statement);
383: END IF;
384:
385: -- Execute the dynamic call.
386: EXECUTE IMMEDIATE l_exec_string USING IN OUT l_return_status; -- Bug 2776412

Line 432: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

428: l_party_id NUMBER(15);
429: l_debug_prefix VARCHAR2(30) := '';
430: BEGIN
431: -- Debug info.
432: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
433: hz_utility_v2pub.debug(p_message=>'validate_organization, x_validation_profile='
434: || x_validation_profile,
435: p_prefix =>l_debug_prefix,
436: p_msg_level=>fnd_log.level_statement);

Line 436: p_msg_level=>fnd_log.level_statement);

432: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
433: hz_utility_v2pub.debug(p_message=>'validate_organization, x_validation_profile='
434: || x_validation_profile,
435: p_prefix =>l_debug_prefix,
436: p_msg_level=>fnd_log.level_statement);
437: END IF;
438:
439: -- Check the profile option name.
440: -- Raise an error if it is not an "allowed" profile option.

Line 784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

780: l_party_id NUMBER(15);
781: l_debug_prefix VARCHAR2(30) := '';
782: BEGIN
783: -- Debug info.
784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
785: hz_utility_v2pub.debug(p_message=>'validate_group, x_validation_profile='
786: || x_validation_profile,
787: p_prefix =>l_debug_prefix,
788: p_msg_level=>fnd_log.level_statement);

Line 788: p_msg_level=>fnd_log.level_statement);

784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
785: hz_utility_v2pub.debug(p_message=>'validate_group, x_validation_profile='
786: || x_validation_profile,
787: p_prefix =>l_debug_prefix,
788: p_msg_level=>fnd_log.level_statement);
789: END IF;
790:
791: -- Check the profile option name.
792: -- Raise an error if it is not an "allowed" profile option.

Line 868: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

864: l_relationship_id NUMBER(15);
865: l_debug_prefix VARCHAR2(30) := '';
866: BEGIN
867: -- Debug info.
868: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug(p_message=>'validate_relationship_member, x_validation_prof='
870: || x_validation_profile,
871: p_prefix =>l_debug_prefix,
872: p_msg_level=>fnd_log.level_statement);

Line 872: p_msg_level=>fnd_log.level_statement);

868: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug(p_message=>'validate_relationship_member, x_validation_prof='
870: || x_validation_profile,
871: p_prefix =>l_debug_prefix,
872: p_msg_level=>fnd_log.level_statement);
873: END IF;
874:
875: -- Check the profile option name.
876: -- Raise an error if it is not an "allowed" profile option.

Line 923: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

919: l_relationship_id NUMBER(15);
920: l_debug_prefix VARCHAR2(30) := '';
921: BEGIN
922: -- Debug info.
923: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
924: hz_utility_v2pub.debug(p_message=>'validate_org_contact, x_validation_profile='|| x_validation_profile,
925: p_prefix =>l_debug_prefix,
926: p_msg_level=>fnd_log.level_statement);
927: END IF;

Line 926: p_msg_level=>fnd_log.level_statement);

922: -- Debug info.
923: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
924: hz_utility_v2pub.debug(p_message=>'validate_org_contact, x_validation_profile='|| x_validation_profile,
925: p_prefix =>l_debug_prefix,
926: p_msg_level=>fnd_log.level_statement);
927: END IF;
928:
929: -- Check the profile option name.
930: -- Raise an error if it is not an "allowed" profile option.

Line 1073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1069: l_party_site_id NUMBER(15);
1070: l_debug_prefix VARCHAR2(30) := '';
1071: BEGIN
1072: -- Debug info.
1073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1074: hz_utility_v2pub.debug(p_message=>'validate_party_site, x_validation_profile='|| x_validation_profile,
1075: p_prefix =>l_debug_prefix,
1076: p_msg_level=>fnd_log.level_statement);
1077: END IF;

Line 1076: p_msg_level=>fnd_log.level_statement);

1072: -- Debug info.
1073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1074: hz_utility_v2pub.debug(p_message=>'validate_party_site, x_validation_profile='|| x_validation_profile,
1075: p_prefix =>l_debug_prefix,
1076: p_msg_level=>fnd_log.level_statement);
1077: END IF;
1078:
1079: -- Check the profile option name.
1080: -- Raise an error if it is not an "allowed" profile option.

Line 1213: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1209: l_location_id NUMBER(15);
1210: l_debug_prefix VARCHAR2(30) := '';
1211: BEGIN
1212: -- Debug info.
1213: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1214: hz_utility_v2pub.debug(p_message=>'validate_location, x_validation_profile='|| x_validation_profile,
1215: p_prefix =>l_debug_prefix,
1216: p_msg_level=>fnd_log.level_statement);
1217: END IF;

Line 1216: p_msg_level=>fnd_log.level_statement);

1212: -- Debug info.
1213: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1214: hz_utility_v2pub.debug(p_message=>'validate_location, x_validation_profile='|| x_validation_profile,
1215: p_prefix =>l_debug_prefix,
1216: p_msg_level=>fnd_log.level_statement);
1217: END IF;
1218:
1219: -- Check the profile option name.
1220: -- Raise an error if it is not an "allowed" profile option.

Line 1413: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1409: l_contact_point_id NUMBER(15);
1410: l_debug_prefix VARCHAR2(30) := '';
1411: BEGIN
1412: -- Debug info.
1413: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1414: hz_utility_v2pub.debug(p_message=>'validate_contact_point, x_validation_profile='|| x_validation_profile,
1415: p_prefix =>l_debug_prefix,
1416: p_msg_level=>fnd_log.level_statement);
1417: END IF;

Line 1416: p_msg_level=>fnd_log.level_statement);

1412: -- Debug info.
1413: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1414: hz_utility_v2pub.debug(p_message=>'validate_contact_point, x_validation_profile='|| x_validation_profile,
1415: p_prefix =>l_debug_prefix,
1416: p_msg_level=>fnd_log.level_statement);
1417: END IF;
1418:
1419: -- Check the profile option name.
1420: -- Raise an error if it is not an "allowed" profile option.