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_IMP_DQM_STAGE dependencies on FND_LOG

Line 121: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

117: and attribute_name = p_attr_name);
118:
119: l_procedure_name VARCHAR2(30) := '.USING_ALLOW_CUST' ;
120: BEGIN
121: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
122: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
123: END IF;
124: OPEN c1;
125: LOOP

Line 122: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

118:
119: l_procedure_name VARCHAR2(30) := '.USING_ALLOW_CUST' ;
120: BEGIN
121: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
122: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
123: END IF;
124: OPEN c1;
125: LOOP
126: FETCH c1 into using_allow_cust;

Line 866: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

862: p_rule_id IN NUMBER
863: ) IS
864: l_procedure_name VARCHAR2(30) := '.GEN_PKG_SPEC' ;
865: BEGIN
866: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
867: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter p_pkg_name='||p_pkg_name || ' p_rule_id='|| p_rule_id);
868: END IF;
869: IF is_test THEN
870: l('CREATE or REPLACE PACKAGE ' || p_pkg_name || ' AUTHID CURRENT_USER AS'); -- this

Line 867: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter p_pkg_name='||p_pkg_name || ' p_rule_id='|| p_rule_id);

863: ) IS
864: l_procedure_name VARCHAR2(30) := '.GEN_PKG_SPEC' ;
865: BEGIN
866: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
867: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter p_pkg_name='||p_pkg_name || ' p_rule_id='|| p_rule_id);
868: END IF;
869: IF is_test THEN
870: l('CREATE or REPLACE PACKAGE ' || p_pkg_name || ' AUTHID CURRENT_USER AS'); -- this
871: END IF;

Line 939: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

935: p_table_name := 'HZ_IMP_CONTACTS_INT';
936: ELSIF ((p_entity_name = 'CONTACT_POINTS') OR (p_entity_name = 'HZ_STAGED_CONTACT_POINTS')) THEN
937: p_table_name := 'HZ_IMP_CONTACTPTS_INT';
938: ELSE
939: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
940: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_entity_name='||p_entity_name);
941: END IF;
942: END IF;
943: END get_table_name;

Line 940: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_entity_name='||p_entity_name);

936: ELSIF ((p_entity_name = 'CONTACT_POINTS') OR (p_entity_name = 'HZ_STAGED_CONTACT_POINTS')) THEN
937: p_table_name := 'HZ_IMP_CONTACTPTS_INT';
938: ELSE
939: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
940: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_entity_name='||p_entity_name);
941: END IF;
942: END IF;
943: END get_table_name;
944:

Line 959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

955: is_using_allow_cust_attr VARCHAR2(1) := 'N';
956:
957: BEGIN
958: get_table_name(p_entity_name, l_table_name);
959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
960: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
961: END IF;
962: -- FOR TX IN (select decode(attribute_name, 'PARTY_NAME', 'ORGANIZATION_NAME', attribute_name) as attribute_name
963: FOR TX IN (select attribute_name

Line 960: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

956:
957: BEGIN
958: get_table_name(p_entity_name, l_table_name);
959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
960: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
961: END IF;
962: -- FOR TX IN (select decode(attribute_name, 'PARTY_NAME', 'ORGANIZATION_NAME', attribute_name) as attribute_name
963: FOR TX IN (select attribute_name
964: from hz_trans_attributes_b

Line 1027: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1023: /* ELSE IF (p_std_chk = DO_STD_CHK) THEN
1024:
1025: ELSE
1026: dbms_output.put_line('SOMETHING WRONG 1 ');
1027: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1028: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'',p_entity_name='||p_entity_name||' p_std_chk=' || p_std_chk);
1029: END IF;
1030: END IF;
1031: */

Line 1028: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'',p_entity_name='||p_entity_name||' p_std_chk=' || p_std_chk);

1024:
1025: ELSE
1026: dbms_output.put_line('SOMETHING WRONG 1 ');
1027: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1028: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'',p_entity_name='||p_entity_name||' p_std_chk=' || p_std_chk);
1029: END IF;
1030: END IF;
1031: */
1032: ELSIF p_entity_name = 'CONTACT_POINTS' /* and p_sql_str != null */ THEN

Line 1051: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1047: ELSE
1048: p_sql_str := p_sql_str || ', a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, b.party_action_flag, a.rowid, b.obj_id';
1049: END IF;
1050: ELSE
1051: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1052: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'',p_entity_name='||p_entity_name);
1053: END IF;
1054: END IF;
1055: ELSIF p_et_point = 'INT_TCA' THEN

Line 1052: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'',p_entity_name='||p_entity_name);

1048: p_sql_str := p_sql_str || ', a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, b.party_action_flag, a.rowid, b.obj_id';
1049: END IF;
1050: ELSE
1051: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1052: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'',p_entity_name='||p_entity_name);
1053: END IF;
1054: END IF;
1055: ELSIF p_et_point = 'INT_TCA' THEN
1056: IF p_entity_name = 'PARTY' /* and p_sql_str != null */ THEN

Line 1087: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1083: ELSE
1084: p_sql_str := p_sql_str || ', a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, a.rowid';
1085: END IF;
1086: ELSE
1087: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1088: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'',p_entity_name='||p_entity_name);
1089: END IF;
1090: END IF;
1091: ELSE

Line 1088: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'',p_entity_name='||p_entity_name);

1084: p_sql_str := p_sql_str || ', a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, a.rowid';
1085: END IF;
1086: ELSE
1087: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1088: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'',p_entity_name='||p_entity_name);
1089: END IF;
1090: END IF;
1091: ELSE
1092: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1092: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1088: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'',p_entity_name='||p_entity_name);
1089: END IF;
1090: END IF;
1091: ELSE
1092: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1093: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '||p_et_point);
1094: END IF;
1095: END IF;
1096: EXCEPTION WHEN OTHERS THEN

Line 1093: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '||p_et_point);

1089: END IF;
1090: END IF;
1091: ELSE
1092: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1093: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '||p_et_point);
1094: END IF;
1095: END IF;
1096: EXCEPTION WHEN OTHERS THEN
1097: RAISE FND_API.G_EXC_ERROR;

Line 1112: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1108: l_procedure_name VARCHAR2(30) := '.GET_TRANS_STR' ;
1109: l_table_name VARCHAR2(30);
1110: BEGIN
1111: get_table_name(p_entity_name, l_table_name);
1112: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1113: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1114: END IF;
1115: FOR TX IN ( select attribute_id || 'E' as STAGED_ATTRIBUTE_COLUMN
1116: from hz_trans_attributes_b

Line 1113: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1109: l_table_name VARCHAR2(30);
1110: BEGIN
1111: get_table_name(p_entity_name, l_table_name);
1112: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1113: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1114: END IF;
1115: FOR TX IN ( select attribute_id || 'E' as STAGED_ATTRIBUTE_COLUMN
1116: from hz_trans_attributes_b
1117: where attribute_id in (select attribute_id

Line 1171: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1167: IF (is_using_allow_cust_attr = 'Y') THEN
1168: p_sql_str := p_sql_str || ', H_CT_NAME ';
1169: END IF;
1170: ELSE
1171: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1172: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'', p_entity_name = '||p_entity_name);
1173: END IF;
1174: END IF;
1175: ELSIF p_et_point = 'INT_TCA' THEN

Line 1172: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'', p_entity_name = '||p_entity_name);

1168: p_sql_str := p_sql_str || ', H_CT_NAME ';
1169: END IF;
1170: ELSE
1171: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1172: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'', p_entity_name = '||p_entity_name);
1173: END IF;
1174: END IF;
1175: ELSIF p_et_point = 'INT_TCA' THEN
1176: IF p_entity_name = 'PARTY' THEN

Line 1209: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1205: IF (is_using_allow_cust_attr = 'Y') THEN
1206: p_sql_str := p_sql_str || ', H_CT_NAME ';
1207: END IF;
1208: ELSE
1209: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1210: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);
1211: END IF;
1212: END IF;
1213: ELSE

Line 1210: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);

1206: p_sql_str := p_sql_str || ', H_CT_NAME ';
1207: END IF;
1208: ELSE
1209: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1210: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);
1211: END IF;
1212: END IF;
1213: ELSE
1214: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1214: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1210: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);
1211: END IF;
1212: END IF;
1213: ELSE
1214: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1215: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '|| p_et_point);
1216: END IF;
1217: END IF;
1218: EXCEPTION WHEN OTHERS THEN

Line 1215: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '|| p_et_point);

1211: END IF;
1212: END IF;
1213: ELSE
1214: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1215: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '|| p_et_point);
1216: END IF;
1217: END IF;
1218: EXCEPTION WHEN OTHERS THEN
1219: RAISE FND_API.G_EXC_ERROR;

Line 1237: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1233: l_procedure_name VARCHAR2(30) := '.GET_CUST_INSERT_STR' ;
1234: l_table_name VARCHAR2(30);
1235: BEGIN
1236: get_table_name(p_entity_name, l_table_name);
1237: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1238: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1239: END IF;
1240: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1241: from hz_trans_functions_b

Line 1238: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1234: l_table_name VARCHAR2(30);
1235: BEGIN
1236: get_table_name(p_entity_name, l_table_name);
1237: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1238: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1239: END IF;
1240: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1241: from hz_trans_functions_b
1242: where attribute_id in (select attribute_id

Line 1280: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1276: l_table_name VARCHAR2(30);
1277: l_sql_str VARCHAR2(255) ;
1278: BEGIN
1279: get_table_name(p_entity_name, l_table_name);
1280: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1281: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1282: END IF;
1283: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1284: from hz_trans_functions_b

Line 1281: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1277: l_sql_str VARCHAR2(255) ;
1278: BEGIN
1279: get_table_name(p_entity_name, l_table_name);
1280: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1281: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1282: END IF;
1283: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1284: from hz_trans_functions_b
1285: where function_id in

Line 1357: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1353: get_cust_insert_str ('CONTACTS', p_rule_id, l_sql_str, NULL, 'CONTACT_NAME', null);
1354: p_sql_str := p_sql_str || l_sql_str;
1355: END IF;
1356: ELSE
1357: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1358: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'', p_entity_name = '||p_entity_name);
1359: END IF;
1360: END IF;
1361: ELSIF p_et_point = 'INT_TCA' THEN

Line 1358: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'', p_entity_name = '||p_entity_name);

1354: p_sql_str := p_sql_str || l_sql_str;
1355: END IF;
1356: ELSE
1357: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1358: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'', p_entity_name = '||p_entity_name);
1359: END IF;
1360: END IF;
1361: ELSIF p_et_point = 'INT_TCA' THEN
1362: IF p_entity_name = 'HZ_STAGED_PARTIES' THEN

Line 1405: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1401: get_cust_insert_str ('CONTACTS', p_rule_id, l_sql_str, NULL, 'CONTACT_NAME', null);
1402: p_sql_str := p_sql_str || l_sql_str;
1403: END IF;
1404: ELSE
1405: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1406: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);
1407: END IF;
1408: END IF;
1409: ELSE

Line 1406: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);

1402: p_sql_str := p_sql_str || l_sql_str;
1403: END IF;
1404: ELSE
1405: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1406: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);
1407: END IF;
1408: END IF;
1409: ELSE
1410: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1410: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1406: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);
1407: END IF;
1408: END IF;
1409: ELSE
1410: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1411: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '|| p_et_point);
1412: END IF;
1413: END IF;
1414: EXCEPTION WHEN OTHERS THEN

Line 1411: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '|| p_et_point);

1407: END IF;
1408: END IF;
1409: ELSE
1410: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1411: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '|| p_et_point);
1412: END IF;
1413: END IF;
1414: EXCEPTION WHEN OTHERS THEN
1415: RAISE FND_API.G_EXC_ERROR;

Line 1432: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1428: l_procedure_name VARCHAR2(30) := '.GET_CUST_INSERT_VAL_STR' ;
1429: l_table_name VARCHAR2(30);
1430: BEGIN
1431: get_table_name(p_entity_name, l_table_name);
1432: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1433: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1434: END IF;
1435: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1436: from hz_trans_functions_b

Line 1433: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1429: l_table_name VARCHAR2(30);
1430: BEGIN
1431: get_table_name(p_entity_name, l_table_name);
1432: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1433: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1434: END IF;
1435: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1436: from hz_trans_functions_b
1437: where attribute_id in (select attribute_id

Line 1474: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1470: l_table_name VARCHAR2(30);
1471: l_sql_str VARCHAR2(255);
1472: BEGIN
1473: get_table_name(p_entity_name, l_table_name);
1474: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1475: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1476: END IF;
1477: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1478: from hz_trans_functions_b

Line 1475: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1471: l_sql_str VARCHAR2(255);
1472: BEGIN
1473: get_table_name(p_entity_name, l_table_name);
1474: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1475: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1476: END IF;
1477: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1478: from hz_trans_functions_b
1479: where function_id in (select function_id

Line 1551: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1547: get_cust_insert_val_str ('CONTACTS', p_rule_id, l_sql_str, 'CT', 'CONTACT_NAME');
1548: p_sql_str := p_sql_str || l_sql_str;
1549: END IF;
1550: ELSE
1551: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1552: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'', p_entity_name = '||p_entity_name);
1553: END IF;
1554: END IF;
1555: ELSIF (p_et_point = 'INT_TCA') THEN

Line 1552: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'', p_entity_name = '||p_entity_name);

1548: p_sql_str := p_sql_str || l_sql_str;
1549: END IF;
1550: ELSE
1551: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1552: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_INT'', p_entity_name = '||p_entity_name);
1553: END IF;
1554: END IF;
1555: ELSIF (p_et_point = 'INT_TCA') THEN
1556: IF p_entity_name = 'HZ_STAGED_PARTIES' THEN

Line 1601: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1597: get_cust_insert_val_str ('CONTACTS', p_rule_id, l_sql_str, 'CT', 'CONTACT_NAME');
1598: p_sql_str := p_sql_str || l_sql_str;
1599: END IF;
1600: ELSE
1601: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1602: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);
1603: END IF;
1604: END IF;
1605: ELSE

Line 1602: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);

1598: p_sql_str := p_sql_str || l_sql_str;
1599: END IF;
1600: ELSE
1601: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1602: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);
1603: END IF;
1604: END IF;
1605: ELSE
1606: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1606: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1602: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = ''INT_TCA'', p_entity_name = '||p_entity_name);
1603: END IF;
1604: END IF;
1605: ELSE
1606: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1607: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '|| p_et_point);
1608: END IF;
1609: END IF;
1610: EXCEPTION WHEN OTHERS THEN

Line 1607: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '|| p_et_point);

1603: END IF;
1604: END IF;
1605: ELSE
1606: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1607: fnd_log.string(fnd_log.LEVEL_ERROR,G_PKG_NAME||l_procedure_name,'p_et_point = '|| p_et_point);
1608: END IF;
1609: END IF;
1610: EXCEPTION WHEN OTHERS THEN
1611: RAISE FND_API.G_EXC_ERROR;

Line 1634: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1630: where entity_name = 'PARTY_SITES'
1631: and attribute_name = 'ADDRESS');
1632: l_procedure_name VARCHAR2(30) := '.USING_RAW_PH_NO' ;
1633: BEGIN
1634: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1635: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1636: END IF;
1637: OPEN c1;
1638: LOOP

Line 1635: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1631: and attribute_name = 'ADDRESS');
1632: l_procedure_name VARCHAR2(30) := '.USING_RAW_PH_NO' ;
1633: BEGIN
1634: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1635: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1636: END IF;
1637: OPEN c1;
1638: LOOP
1639: FETCH c1 into using_address;

Line 1667: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1663: where entity_name = 'CONTACT_POINTS'
1664: and attribute_name = 'RAW_PHONE_NUMBER');
1665: l_procedure_name VARCHAR2(30) := '.USING_RAW_PH_NO' ;
1666: BEGIN
1667: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1668: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1669: END IF;
1670: OPEN c1;
1671: LOOP

Line 1668: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1664: and attribute_name = 'RAW_PHONE_NUMBER');
1665: l_procedure_name VARCHAR2(30) := '.USING_RAW_PH_NO' ;
1666: BEGIN
1667: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1668: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1669: END IF;
1670: OPEN c1;
1671: LOOP
1672: FETCH c1 into using_raw_ph_no;

Line 1700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1696: where entity_name = 'CONTACTS'
1697: and attribute_name = 'CONTACT_NAME' );
1698: l_procedure_name VARCHAR2(30) := '.USING_CONTACT_NAME' ;
1699: BEGIN
1700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1701: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1702: END IF;
1703: OPEN c1;
1704: LOOP

Line 1701: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1697: and attribute_name = 'CONTACT_NAME' );
1698: l_procedure_name VARCHAR2(30) := '.USING_CONTACT_NAME' ;
1699: BEGIN
1700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1701: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1702: END IF;
1703: OPEN c1;
1704: LOOP
1705: FETCH c1 into using_contact_name;

Line 1731: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1727: where entity_name = 'CONTACTS'
1728: and attribute_name = 'CONTACT_NAME' );
1729: l_procedure_name VARCHAR2(30) := '.USING_CONTACT_NAME' ;
1730: BEGIN
1731: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1732: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1733: END IF;
1734: OPEN c1;
1735: LOOP

Line 1732: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1728: and attribute_name = 'CONTACT_NAME' );
1729: l_procedure_name VARCHAR2(30) := '.USING_CONTACT_NAME' ;
1730: BEGIN
1731: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1732: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1733: END IF;
1734: OPEN c1;
1735: LOOP
1736: FETCH c1 into using_contact_name;

Line 1796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1792: -- VJN Introduced for Conditional Word Replacements
1793: NONE BOOLEAN := TRUE ;
1794: BEGIN
1795: get_table_name(p_entity_name, l_table_name);
1796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1797: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1798: END IF;
1799:
1800: -- VJN ADDED CODE FOR TRACKING CONDITION ATTRIBUTES AT THIS ENTITY LEVEL

Line 1797: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1793: NONE BOOLEAN := TRUE ;
1794: BEGIN
1795: get_table_name(p_entity_name, l_table_name);
1796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1797: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1798: END IF;
1799:
1800: -- VJN ADDED CODE FOR TRACKING CONDITION ATTRIBUTES AT THIS ENTITY LEVEL
1801: FOR TX IN ( ----------> CONDITIONAL REPLACEMENT CODE ENDS

Line 1959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1955: l_sel_str VARCHAR2(4000) := NULL;
1956: x_bool VARCHAR2(1);
1957: l_procedure_name VARCHAR2(30) := '.GEN_POP_PARTIES' ;
1958: BEGIN
1959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1960: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1961: END IF;
1962: l('PROCEDURE pop_parties (');
1963: l(' p_batch_id IN NUMBER,');

Line 1960: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

1956: x_bool VARCHAR2(1);
1957: l_procedure_name VARCHAR2(30) := '.GEN_POP_PARTIES' ;
1958: BEGIN
1959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1960: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1961: END IF;
1962: l('PROCEDURE pop_parties (');
1963: l(' p_batch_id IN NUMBER,');
1964: l(' p_from_osr IN VARCHAR2,');

Line 1981: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1977: l(' open p_party_cur FOR ');
1978: get_select_str('PARTY', p_rule_id, l_sel_str, 'INT_INT',null);
1979: l( l_sel_str);
1980: -- dbms_output.put_line('l_sel_str get_select_str ' || l_sel_str);
1981: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1982: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
1983: END IF;
1984: l_sel_str := '';
1985: -- select a.organization_name, a.duns_number_c, a.tax_reference,

Line 1982: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

1978: get_select_str('PARTY', p_rule_id, l_sel_str, 'INT_INT',null);
1979: l( l_sel_str);
1980: -- dbms_output.put_line('l_sel_str get_select_str ' || l_sel_str);
1981: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1982: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
1983: END IF;
1984: l_sel_str := '';
1985: -- select a.organization_name, a.duns_number_c, a.tax_reference,
1986: -- a.party_orig_system, a.party_orig_system_reference, b.party_id

Line 2000: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1996: l(' FETCH p_party_cur BULK COLLECT INTO ');
1997: get_trans_str('PARTY', p_rule_id, l_sel_str, 'INT_INT');
1998: l( l_sel_str);
1999: -- dbms_output.put_line('l_sel_str get_trans_str ' || l_sel_str);
2000: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2001: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2002: END IF;
2003: l_sel_str := '';
2004: /* H_TX4

Line 2001: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

1997: get_trans_str('PARTY', p_rule_id, l_sel_str, 'INT_INT');
1998: l( l_sel_str);
1999: -- dbms_output.put_line('l_sel_str get_trans_str ' || l_sel_str);
2000: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2001: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2002: END IF;
2003: l_sel_str := '';
2004: /* H_TX4
2005: ,H_TX11

Line 2024: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2020: -- pass STAGE wherever p_context is required.
2021: get_trans_proc('PARTY', p_rule_id, l_trans_list);
2022: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2023: -- dbms_output.put_line('l_trans_list get_trans_proc ' || l_trans_list(I));
2024: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2025: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
2026: END IF;
2027: l(l_trans_list(I));
2028: l_trans_list.DELETE(I);

Line 2025: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));

2021: get_trans_proc('PARTY', p_rule_id, l_trans_list);
2022: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2023: -- dbms_output.put_line('l_trans_list get_trans_proc ' || l_trans_list(I));
2024: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2025: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
2026: END IF;
2027: l(l_trans_list(I));
2028: l_trans_list.DELETE(I);
2029: END LOOP ;

Line 2043: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2039: l(' INSERT INTO HZ_SRCH_PARTIES (');
2040: get_insert_str('HZ_STAGED_PARTIES', p_rule_id, l_sel_str, 'INT_INT');
2041: l( l_sel_str);
2042: -- dbms_output.put_line('l_sel_str get_insert_str ' || l_sel_str);
2043: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2044: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2045: END IF;
2046: l_sel_str := '';
2047:

Line 2044: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2040: get_insert_str('HZ_STAGED_PARTIES', p_rule_id, l_sel_str, 'INT_INT');
2041: l( l_sel_str);
2042: -- dbms_output.put_line('l_sel_str get_insert_str ' || l_sel_str);
2043: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2044: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2045: END IF;
2046: l_sel_str := '';
2047:
2048: /* PARTY_ID

Line 2059: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2055: l(' ) VALUES ( ');
2056: get_insert_val_str('HZ_STAGED_PARTIES', p_rule_id, l_sel_str, 'INT_INT');
2057: l( l_sel_str);
2058: -- dbms_output.put_line('l_sel_str get_insert_val_str ' || l_sel_str);
2059: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2060: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2061: END IF;
2062: l_sel_str := '';
2063: /*

Line 2060: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);

2056: get_insert_val_str('HZ_STAGED_PARTIES', p_rule_id, l_sel_str, 'INT_INT');
2057: l( l_sel_str);
2058: -- dbms_output.put_line('l_sel_str get_insert_val_str ' || l_sel_str);
2059: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2060: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2061: END IF;
2062: l_sel_str := '';
2063: /*
2064: H_P_PARTY_ID(I)

Line 2104: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2100: l_sel_str VARCHAR2(4000) := NULL;
2101: x_bool VARCHAR2(1);
2102: l_procedure_name VARCHAR2(30) := '.GEN_POP_PARTIES_INT' ;
2103: BEGIN
2104: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2105: fnd_log.string(fnd_log.LEVEL_STATEMENT, G_PKG_NAME||l_procedure_name, 'Enter');
2106: END IF;
2107: x_bool := 'N';
2108:

Line 2105: fnd_log.string(fnd_log.LEVEL_STATEMENT, G_PKG_NAME||l_procedure_name, 'Enter');

2101: x_bool VARCHAR2(1);
2102: l_procedure_name VARCHAR2(30) := '.GEN_POP_PARTIES_INT' ;
2103: BEGIN
2104: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2105: fnd_log.string(fnd_log.LEVEL_STATEMENT, G_PKG_NAME||l_procedure_name, 'Enter');
2106: END IF;
2107: x_bool := 'N';
2108:
2109: l(' PROCEDURE pop_parties_int ( ');

Line 2129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2125: get_select_str('PARTY', p_rule_id, l_sel_str, 'INT_TCA', NULL);
2126: l_sel_str := l_sel_str || ' , a.party_id '; --bug 5393826
2127: l( l_sel_str);
2128: -- dbms_output.put_line('get_select_str (PARTY -int tca) ' || l_sel_str);
2129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2130: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2131: END IF;
2132: l_sel_str := '';
2133: /* select a.organization_name, a.duns_number_c, a.tax_reference,

Line 2130: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);

2126: l_sel_str := l_sel_str || ' , a.party_id '; --bug 5393826
2127: l( l_sel_str);
2128: -- dbms_output.put_line('get_select_str (PARTY -int tca) ' || l_sel_str);
2129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2130: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2131: END IF;
2132: l_sel_str := '';
2133: /* select a.organization_name, a.duns_number_c, a.tax_reference,
2134: a.party_orig_system, a.party_orig_system_reference

Line 2147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2143: get_trans_str('PARTY', p_rule_id, l_sel_str, 'INT_TCA');
2144: l_sel_str := l_sel_str || ' , H_P_PARTY_ID '; -- bug 5393826
2145: l( l_sel_str);
2146: -- dbms_output.put_line('get_trans_str PARTY int tca ' || l_sel_str);
2147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2148: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2149: END IF;
2150: l_sel_str := '';
2151: /* H_TX4

Line 2148: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);

2144: l_sel_str := l_sel_str || ' , H_P_PARTY_ID '; -- bug 5393826
2145: l( l_sel_str);
2146: -- dbms_output.put_line('get_trans_str PARTY int tca ' || l_sel_str);
2147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2148: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2149: END IF;
2150: l_sel_str := '';
2151: /* H_TX4
2152: ,H_TX11

Line 2170: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2166: -- pass STAGE wherever p_context is required.
2167: get_trans_proc('PARTY', p_rule_id, l_trans_list);
2168: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2169: -- dbms_output.put_line('get_trans_proc (PARTY int tca)' || l_trans_list(I));
2170: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2171: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_trans_list(I));
2172: END IF;
2173: l(l_trans_list(I));
2174: l_trans_list.DELETE(I);

Line 2171: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_trans_list(I));

2167: get_trans_proc('PARTY', p_rule_id, l_trans_list);
2168: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2169: -- dbms_output.put_line('get_trans_proc (PARTY int tca)' || l_trans_list(I));
2170: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2171: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_trans_list(I));
2172: END IF;
2173: l(l_trans_list(I));
2174: l_trans_list.DELETE(I);
2175: END LOOP ;

Line 2189: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2185: get_insert_str('HZ_STAGED_PARTIES', p_rule_id, l_sel_str, 'INT_TCA');
2186: l_sel_str := l_sel_str || ' , PARTY_ID '; -- bug 5393826
2187: l( l_sel_str);
2188: -- dbms_output.put_line('get_insert_str PARTY int tca ' || l_sel_str);
2189: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2190: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2191: END IF;
2192: l_sel_str := '';
2193: /* PARTY_OS

Line 2190: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);

2186: l_sel_str := l_sel_str || ' , PARTY_ID '; -- bug 5393826
2187: l( l_sel_str);
2188: -- dbms_output.put_line('get_insert_str PARTY int tca ' || l_sel_str);
2189: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2190: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2191: END IF;
2192: l_sel_str := '';
2193: /* PARTY_OS
2194: , PARTY_OSR

Line 2203: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2199: get_insert_val_str('HZ_STAGED_PARTIES', p_rule_id, l_sel_str, 'INT_TCA');
2200: l_sel_str := l_sel_str || ' , H_P_PARTY_ID(I) '; -- bug 5393826
2201: l( l_sel_str);
2202: -- dbms_output.put_line('l_sel_str get_insert_val_str ' || l_sel_str);
2203: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2204: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2205: END IF;
2206: l_sel_str := '';
2207: /* H_P_PARTY_OS(I)

Line 2204: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);

2200: l_sel_str := l_sel_str || ' , H_P_PARTY_ID(I) '; -- bug 5393826
2201: l( l_sel_str);
2202: -- dbms_output.put_line('l_sel_str get_insert_val_str ' || l_sel_str);
2203: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2204: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2205: END IF;
2206: l_sel_str := '';
2207: /* H_P_PARTY_OS(I)
2208: , H_P_PARTY_OSR(I)

Line 2245: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2241: l_sel_str VARCHAR2(4000) := NULL;
2242: x_bool VARCHAR2(1);
2243: l_procedure_name VARCHAR2(30) := '.GEN_POP_PARTY_SITES' ;
2244: BEGIN
2245: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2246: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2247: END IF;
2248: l('');
2249: l(' PROCEDURE pop_party_sites ( ');

Line 2246: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

2242: x_bool VARCHAR2(1);
2243: l_procedure_name VARCHAR2(30) := '.GEN_POP_PARTY_SITES' ;
2244: BEGIN
2245: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2246: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2247: END IF;
2248: l('');
2249: l(' PROCEDURE pop_party_sites ( ');
2250: l(' p_batch_id IN NUMBER, ');

Line 2267: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2263: l(' open l_party_site_cur for ');
2264: get_select_str('PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT', DO_STD_CHK);
2265: l( l_sel_str);
2266: -- dbms_output.put_line('select_str (PARTY_SITES) = ' || l_sel_str);
2267: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2268: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2269: END IF;
2270: l_sel_str := '';
2271: /*

Line 2268: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2264: get_select_str('PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT', DO_STD_CHK);
2265: l( l_sel_str);
2266: -- dbms_output.put_line('select_str (PARTY_SITES) = ' || l_sel_str);
2267: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2268: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2269: END IF;
2270: l_sel_str := '';
2271: /*
2272: select a.party_orig_system, a.party_orig_system_reference,

Line 2292: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2288: -- addition starts --
2289: get_select_str('PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT', DO_STD_CHK);
2290: l( l_sel_str);
2291: dbms_output.put_line('select_str (PARTY_SITES) = ' || l_sel_str);
2292: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2293: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2294: END IF;
2295: l_sel_str := '';
2296: l(' from hz_imp_addresses_int a, hz_imp_addresses_sg b ');

Line 2293: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2289: get_select_str('PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT', DO_STD_CHK);
2290: l( l_sel_str);
2291: dbms_output.put_line('select_str (PARTY_SITES) = ' || l_sel_str);
2292: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2293: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2294: END IF;
2295: l_sel_str := '';
2296: l(' from hz_imp_addresses_int a, hz_imp_addresses_sg b ');
2297: l(' where a.batch_id = p_batch_id ');

Line 2313: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2309: l(' FETCH l_party_site_cur BULK COLLECT INTO ');
2310: get_trans_str('PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT');
2311: l( l_sel_str);
2312: -- dbms_output.put_line('get_trans_str (PARTY_SITES) =' || l_sel_str);
2313: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2314: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2315: END IF;
2316: l_sel_str := '';
2317: /* H_P_PARTY_OS,

Line 2314: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);

2310: get_trans_str('PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT');
2311: l( l_sel_str);
2312: -- dbms_output.put_line('get_trans_str (PARTY_SITES) =' || l_sel_str);
2313: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2314: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2315: END IF;
2316: l_sel_str := '';
2317: /* H_P_PARTY_OS,
2318: H_P_PARTY_OSR,

Line 2340: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2336: l(' FOR I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST LOOP ');
2337: get_trans_proc('PARTY_SITES', p_rule_id, l_trans_list);
2338: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2339: -- dbms_output.put_line('get_trans_proc (PARTY_SITES) = ' || l_trans_list(I));
2340: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2341: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_trans_list(I));
2342: END IF;
2343: l(l_trans_list(I));
2344: l_trans_list.DELETE(I);

Line 2341: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_trans_list(I));

2337: get_trans_proc('PARTY_SITES', p_rule_id, l_trans_list);
2338: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2339: -- dbms_output.put_line('get_trans_proc (PARTY_SITES) = ' || l_trans_list(I));
2340: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2341: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_trans_list(I));
2342: END IF;
2343: l(l_trans_list(I));
2344: l_trans_list.DELETE(I);
2345: END LOOP ;

Line 2358: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2354: l(' INSERT INTO HZ_SRCH_PSITES ( ');
2355: get_insert_str('HZ_STAGED_PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT');
2356: l( l_sel_str);
2357: -- dbms_output.put_line('l_sel_str get_insert_str ' || l_sel_str);
2358: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2359: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2360: END IF;
2361: l_sel_str := '';
2362: /* PARTY_SITE_ID,

Line 2359: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);

2355: get_insert_str('HZ_STAGED_PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT');
2356: l( l_sel_str);
2357: -- dbms_output.put_line('l_sel_str get_insert_str ' || l_sel_str);
2358: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2359: fnd_log.string(fnd_log.LEVEL_PROCEDURE, G_PKG_NAME||l_procedure_name, l_sel_str);
2360: END IF;
2361: l_sel_str := '';
2362: /* PARTY_SITE_ID,
2363: PARTY_ID,

Line 2376: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2372: l(' ) VALUES ( ');
2373: get_insert_val_str('HZ_STAGED_PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT');
2374: l( l_sel_str);
2375: -- dbms_output.put_line(' get_insert_val_str (PARTY_SITES) = ' || l_sel_str);
2376: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2377: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2378: END IF;
2379: l_sel_str := '';
2380: /* H_P_PARTY_SITE_ID(I),

Line 2377: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2373: get_insert_val_str('HZ_STAGED_PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT');
2374: l( l_sel_str);
2375: -- dbms_output.put_line(' get_insert_val_str (PARTY_SITES) = ' || l_sel_str);
2376: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2377: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2378: END IF;
2379: l_sel_str := '';
2380: /* H_P_PARTY_SITE_ID(I),
2381: H_P_PARTY_ID(I),

Line 2422: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2418: l_sel_str VARCHAR2(4000) := NULL;
2419: x_bool VARCHAR2(1);
2420: l_procedure_name VARCHAR2(30) := '.GEN_POP_PARTY_SITES_INT' ;
2421: BEGIN
2422: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2423: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2424: END IF;
2425: l(' ');
2426: l(' PROCEDURE pop_party_sites_int ( ');

Line 2423: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

2419: x_bool VARCHAR2(1);
2420: l_procedure_name VARCHAR2(30) := '.GEN_POP_PARTY_SITES_INT' ;
2421: BEGIN
2422: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2423: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2424: END IF;
2425: l(' ');
2426: l(' PROCEDURE pop_party_sites_int ( ');
2427: l(' p_batch_id IN NUMBER, ');

Line 2448: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2444: get_select_str('PARTY_SITES', p_rule_id, l_sel_str, 'INT_TCA', null);
2445: l_sel_str := l_sel_str || ' , a.party_id '; --bug 5393826
2446: l( l_sel_str);
2447: -- dbms_output.put_line('select_str (PARTY_SITES int tca) = ' || l_sel_str);
2448: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2449: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2450: END IF;
2451: l_sel_str := '';
2452: /* select a.party_orig_system, a.party_orig_system_reference,

Line 2449: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2445: l_sel_str := l_sel_str || ' , a.party_id '; --bug 5393826
2446: l( l_sel_str);
2447: -- dbms_output.put_line('select_str (PARTY_SITES int tca) = ' || l_sel_str);
2448: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2449: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2450: END IF;
2451: l_sel_str := '';
2452: /* select a.party_orig_system, a.party_orig_system_reference,
2453: a.site_orig_system, a.site_orig_system_reference,

Line 2466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2462: get_trans_str('PARTY_SITES', p_rule_id, l_sel_str, 'INT_TCA');
2463: l_sel_str := l_sel_str || ' , H_P_PARTY_ID '; -- bug 5393826
2464: l( l_sel_str);
2465: -- dbms_output.put_line('get_trans_str (PARTY_SITES) =' || l_sel_str);
2466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2467: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2468: END IF;
2469: l_sel_str := '';
2470: /* H_P_PARTY_OS,

Line 2467: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2463: l_sel_str := l_sel_str || ' , H_P_PARTY_ID '; -- bug 5393826
2464: l( l_sel_str);
2465: -- dbms_output.put_line('get_trans_str (PARTY_SITES) =' || l_sel_str);
2466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2467: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2468: END IF;
2469: l_sel_str := '';
2470: /* H_P_PARTY_OS,
2471: H_P_PARTY_OSR,

Line 2489: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2485: l(' FOR I in H_P_PS_OSR.FIRST..H_P_PS_OSR.LAST LOOP ');
2486: get_trans_proc('PARTY_SITES', p_rule_id, l_trans_list);
2487: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2488: -- dbms_output.put_line('get_trans_proc (PARTY_SITES) = ' || l_trans_list(I));
2489: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2490: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
2491: END IF;
2492: l(l_trans_list(I));
2493: l_trans_list.DELETE(I);

Line 2490: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));

2486: get_trans_proc('PARTY_SITES', p_rule_id, l_trans_list);
2487: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2488: -- dbms_output.put_line('get_trans_proc (PARTY_SITES) = ' || l_trans_list(I));
2489: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2490: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
2491: END IF;
2492: l(l_trans_list(I));
2493: l_trans_list.DELETE(I);
2494: END LOOP ;

Line 2509: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2505: get_insert_str('HZ_STAGED_PARTY_SITES', p_rule_id, l_sel_str, 'INT_TCA');
2506: l_sel_str := l_sel_str || ' , PARTY_ID ';-- bug 5393826
2507: l( l_sel_str);
2508: -- dbms_output.put_line('l_sel_str get_insert_str ' || l_sel_str);
2509: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2510: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2511: END IF;
2512: l_sel_str := '';
2513: /* PARTY_OS,

Line 2510: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2506: l_sel_str := l_sel_str || ' , PARTY_ID ';-- bug 5393826
2507: l( l_sel_str);
2508: -- dbms_output.put_line('l_sel_str get_insert_str ' || l_sel_str);
2509: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2510: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2511: END IF;
2512: l_sel_str := '';
2513: /* PARTY_OS,
2514: PARTY_OSR,

Line 2525: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2521: get_insert_val_str('HZ_STAGED_PARTY_SITES', p_rule_id, l_sel_str, 'INT_TCA');
2522: l_sel_str := l_sel_str || ' , H_P_PARTY_ID(I) '; -- bug 5393826
2523: l( l_sel_str);
2524: -- dbms_output.put_line(' get_insert_val_str (PARTY_SITES) = ' || l_sel_str);
2525: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2526: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2527: END IF;
2528: l_sel_str := '';
2529: /* H_P_PARTY_OS(I),

Line 2526: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2522: l_sel_str := l_sel_str || ' , H_P_PARTY_ID(I) '; -- bug 5393826
2523: l( l_sel_str);
2524: -- dbms_output.put_line(' get_insert_val_str (PARTY_SITES) = ' || l_sel_str);
2525: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2526: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2527: END IF;
2528: l_sel_str := '';
2529: /* H_P_PARTY_OS(I),
2530: H_P_PARTY_OSR(I),

Line 2565: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2561: p_rule_id IN NUMBER
2562: ) IS
2563: l_procedure_name VARCHAR2(30) := '.GEN_STATIC_TEXT' ;
2564: BEGIN
2565: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2566: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2567: END IF;
2568: /*
2569: */

Line 2566: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

2562: ) IS
2563: l_procedure_name VARCHAR2(30) := '.GEN_STATIC_TEXT' ;
2564: BEGIN
2565: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2566: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2567: END IF;
2568: /*
2569: */
2570: l('PROCEDURE POP_INTERFACE_SEARCH_TAB (');

Line 2653: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2649: l_sel_str VARCHAR2(4000) := NULL;
2650: x_bool VARCHAR2(1) := NULL;
2651: l_procedure_name VARCHAR2(30) := '.GEN_GET_CONTACT_CUR' ;
2652: BEGIN
2653: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2654: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2655: END IF;
2656: l(' PROCEDURE get_contact_cur( ');
2657: l(' p_batch_id IN NUMBER, ');

Line 2654: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

2650: x_bool VARCHAR2(1) := NULL;
2651: l_procedure_name VARCHAR2(30) := '.GEN_GET_CONTACT_CUR' ;
2652: BEGIN
2653: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2654: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2655: END IF;
2656: l(' PROCEDURE get_contact_cur( ');
2657: l(' p_batch_id IN NUMBER, ');
2658: l(' p_from_osr IN VARCHAR2, ');

Line 2694: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2690: -- cursor1 if match_rule has contact_name, person_first_name, person_last_name in it.
2691: get_select_str('CONTACTS', p_rule_id, l_sel_str, 'INT_INT', NULL);
2692: l_sel_str := l_sel_str || ', c.person_first_name || '' '' || c.person_last_name as person_name' ;
2693: -- dbms_output.put_line('l_sel_str ' || l_sel_str);
2694: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2695: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2696: END IF;
2697: l(l_sel_str);
2698: l_sel_str := '';

Line 2695: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2691: get_select_str('CONTACTS', p_rule_id, l_sel_str, 'INT_INT', NULL);
2692: l_sel_str := l_sel_str || ', c.person_first_name || '' '' || c.person_last_name as person_name' ;
2693: -- dbms_output.put_line('l_sel_str ' || l_sel_str);
2694: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2695: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2696: END IF;
2697: l(l_sel_str);
2698: l_sel_str := '';
2699:

Line 2723: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2719: get_select_str('CONTACTS', p_rule_id, l_sel_str, 'INT_INT', NULL);
2720: l_sel_str := l_sel_str || ', c.party_name as person_name' ;
2721: l(l_sel_str);
2722: -- dbms_output.put_line('get_select_str (CONTACTS)' || l_sel_str);
2723: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2724: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2725: END IF;
2726: l_sel_str := '';
2727: /* l(' select a.sub_orig_system, a.sub_orig_system_reference, ');

Line 2724: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2720: l_sel_str := l_sel_str || ', c.party_name as person_name' ;
2721: l(l_sel_str);
2722: -- dbms_output.put_line('get_select_str (CONTACTS)' || l_sel_str);
2723: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2724: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2725: END IF;
2726: l_sel_str := '';
2727: /* l(' select a.sub_orig_system, a.sub_orig_system_reference, ');
2728: l(' a.site_orig_system, a.site_orig_system_reference, ');

Line 2751: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2747: get_select_str('CONTACTS', p_rule_id, l_sel_str, 'INT_INT', NULL);
2748: l_sel_str := l_sel_str || ' ' ; -- , null person_name
2749: l(l_sel_str);
2750: -- dbms_output.put_line('get_select_str (CONTACTS)' || l_sel_str);
2751: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2752: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2753: END IF;
2754: l_sel_str := '';
2755: /* l(' select a.sub_orig_system, a.sub_orig_system_reference, ');

Line 2752: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2748: l_sel_str := l_sel_str || ' ' ; -- , null person_name
2749: l(l_sel_str);
2750: -- dbms_output.put_line('get_select_str (CONTACTS)' || l_sel_str);
2751: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2752: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2753: END IF;
2754: l_sel_str := '';
2755: /* l(' select a.sub_orig_system, a.sub_orig_system_reference, ');
2756: l(' a.site_orig_system, a.site_orig_system_reference, ');

Line 2794: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2790: l_sel_str VARCHAR2(4000) := NULL;
2791: x_bool VARCHAR2(1) := NULL;
2792: l_procedure_name VARCHAR2(30) := '.GEN_GET_CONTACT_CUR_INT' ;
2793: BEGIN
2794: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2795: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2796: END IF;
2797: l(' PROCEDURE get_contact_cur_int( ');
2798: l(' p_batch_id IN NUMBER, ');

Line 2795: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

2791: x_bool VARCHAR2(1) := NULL;
2792: l_procedure_name VARCHAR2(30) := '.GEN_GET_CONTACT_CUR_INT' ;
2793: BEGIN
2794: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2795: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2796: END IF;
2797: l(' PROCEDURE get_contact_cur_int( ');
2798: l(' p_batch_id IN NUMBER, ');
2799: l(' p_from_osr IN VARCHAR2, ');

Line 2835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2831: -- cursor1 if match_rule has contact_name, person_first_name, person_last_name in it.
2832: get_select_str('CONTACTS', p_rule_id, l_sel_str, 'INT_TCA', NULL);
2833: -- dbms_output.put_line('l_sel_str (CONTACTS int tca 1)' || l_sel_str);
2834: l_sel_str := l_sel_str || ', c.person_first_name || '' '' || c.person_last_name as person_name' ;
2835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2836: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2837: END IF;
2838: -- dbms_output.put_line('l_sel_str (CONTACTS int tca)' || l_sel_str);
2839: l(l_sel_str);

Line 2836: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2832: get_select_str('CONTACTS', p_rule_id, l_sel_str, 'INT_TCA', NULL);
2833: -- dbms_output.put_line('l_sel_str (CONTACTS int tca 1)' || l_sel_str);
2834: l_sel_str := l_sel_str || ', c.person_first_name || '' '' || c.person_last_name as person_name' ;
2835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2836: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2837: END IF;
2838: -- dbms_output.put_line('l_sel_str (CONTACTS int tca)' || l_sel_str);
2839: l(l_sel_str);
2840: l_sel_str := '';

Line 2861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2857: get_select_str('CONTACTS', p_rule_id, l_sel_str, 'INT_TCA', NULL);
2858: l_sel_str := l_sel_str || ', c.party_name as person_name' ;
2859: l(l_sel_str);
2860: dbms_output.put_line('get_select_str (CONTACTS int_tca)' || l_sel_str);
2861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2862: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2863: END IF;
2864:
2865: l_sel_str := ''; */

Line 2862: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2858: l_sel_str := l_sel_str || ', c.party_name as person_name' ;
2859: l(l_sel_str);
2860: dbms_output.put_line('get_select_str (CONTACTS int_tca)' || l_sel_str);
2861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2862: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2863: END IF;
2864:
2865: l_sel_str := ''; */
2866: /* select a.sub_orig_system, a.sub_orig_system_reference,

Line 2883: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2879: get_select_str('CONTACTS', p_rule_id, l_sel_str, 'INT_TCA', NULL);
2880: l_sel_str := l_sel_str || ', null person_name' ;
2881: l(l_sel_str);
2882: -- dbms_output.put_line('get_select_str (CONTACTS int_tca)' || l_sel_str);
2883: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2884: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2885: END IF;
2886:
2887: l_sel_str := '';

Line 2884: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2880: l_sel_str := l_sel_str || ', null person_name' ;
2881: l(l_sel_str);
2882: -- dbms_output.put_line('get_select_str (CONTACTS int_tca)' || l_sel_str);
2883: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2884: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2885: END IF;
2886:
2887: l_sel_str := '';
2888: /* select a.sub_orig_system, a.sub_orig_system_reference,

Line 2915: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2911: l_sel_str VARCHAR2(4000) := NULL;
2912: x_bool VARCHAR2(1);
2913: l_procedure_name VARCHAR2(30) := '.GEN_POP_CONTACTS' ;
2914: BEGIN
2915: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2916: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2917: END IF;
2918: l(' PROCEDURE pop_contacts ( ');
2919: l(' p_batch_id IN NUMBER, ');

Line 2916: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

2912: x_bool VARCHAR2(1);
2913: l_procedure_name VARCHAR2(30) := '.GEN_POP_CONTACTS' ;
2914: BEGIN
2915: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2916: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
2917: END IF;
2918: l(' PROCEDURE pop_contacts ( ');
2919: l(' p_batch_id IN NUMBER, ');
2920: l(' p_from_osr IN VARCHAR2, ');

Line 2938: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2934: l(' FETCH l_contact_cur BULK COLLECT INTO ');
2935: get_trans_str('CONTACTS', p_rule_id, l_sel_str, 'INT_INT');
2936: l( l_sel_str);
2937: -- dbms_output.put_line('get_trans_str (CONTACTS) ' || l_sel_str);
2938: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2939: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2940: END IF;
2941: l_sel_str := '';
2942: /* H_P_SUBJECT_OS,

Line 2939: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2935: get_trans_str('CONTACTS', p_rule_id, l_sel_str, 'INT_INT');
2936: l( l_sel_str);
2937: -- dbms_output.put_line('get_trans_str (CONTACTS) ' || l_sel_str);
2938: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2939: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2940: END IF;
2941: l_sel_str := '';
2942: /* H_P_SUBJECT_OS,
2943: H_P_SUBJECT_OSR,

Line 2964: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2960: l(' FOR I in H_P_CONTACT_OSR.FIRST..H_P_CONTACT_OSR.LAST LOOP ');
2961: get_trans_proc('CONTACTS', p_rule_id, l_trans_list);
2962: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2963: -- dbms_output.put_line('get_trans_proc (CONTACTS)' || l_trans_list(I));
2964: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2965: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
2966: END IF;
2967: l(l_trans_list(I));
2968: l_trans_list.DELETE(I);

Line 2965: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));

2961: get_trans_proc('CONTACTS', p_rule_id, l_trans_list);
2962: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
2963: -- dbms_output.put_line('get_trans_proc (CONTACTS)' || l_trans_list(I));
2964: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2965: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
2966: END IF;
2967: l(l_trans_list(I));
2968: l_trans_list.DELETE(I);
2969: END LOOP ;

Line 2981: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2977: l(' INSERT INTO HZ_SRCH_CONTACTS ( ');
2978: get_insert_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_INT');
2979: l( l_sel_str);
2980: -- dbms_output.put_line(' get_insert_str (CONTACTS)' || l_sel_str);
2981: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2982: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2983: END IF;
2984: l_sel_str := '';
2985: /* PARTY_OS,

Line 2982: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2978: get_insert_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_INT');
2979: l( l_sel_str);
2980: -- dbms_output.put_line(' get_insert_str (CONTACTS)' || l_sel_str);
2981: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2982: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2983: END IF;
2984: l_sel_str := '';
2985: /* PARTY_OS,
2986: PARTY_OSR,

Line 2995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2991: l(' ) VALUES ( ');
2992: get_insert_val_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_INT');
2993: l( l_sel_str);
2994: -- dbms_output.put_line('get_insert_val_str (CONTACTS)' || l_sel_str);
2995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2996: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2997: END IF;
2998: l_sel_str := '';
2999: /* H_P_SUBJECT_OS(I),

Line 2996: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

2992: get_insert_val_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_INT');
2993: l( l_sel_str);
2994: -- dbms_output.put_line('get_insert_val_str (CONTACTS)' || l_sel_str);
2995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2996: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2997: END IF;
2998: l_sel_str := '';
2999: /* H_P_SUBJECT_OS(I),
3000: H_P_SUBJECT_OSR(I),

Line 3038: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3034: l_sel_str VARCHAR2(4000) := NULL;
3035: x_bool VARCHAR2(1);
3036: l_procedure_name VARCHAR2(30) := '.GEN_POP_CONTACTS_INT' ;
3037: BEGIN
3038: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3039: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3040: END IF;
3041: l(' PROCEDURE pop_contacts_int ( ');
3042: l(' p_batch_id IN NUMBER, ');

Line 3039: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

3035: x_bool VARCHAR2(1);
3036: l_procedure_name VARCHAR2(30) := '.GEN_POP_CONTACTS_INT' ;
3037: BEGIN
3038: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3039: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3040: END IF;
3041: l(' PROCEDURE pop_contacts_int ( ');
3042: l(' p_batch_id IN NUMBER, ');
3043: l(' p_from_osr IN VARCHAR2, ');

Line 3061: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3057: l(' FETCH l_contact_cur BULK COLLECT INTO ');
3058: get_trans_str('CONTACTS', p_rule_id, l_sel_str, 'INT_TCA');
3059: l( l_sel_str);
3060: -- dbms_output.put_line('get_trans_str (CONTACTS int_tca) ' || l_sel_str);
3061: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3062: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3063: END IF;
3064: l_sel_str := '';
3065: /* H_P_SUBJECT_OS,

Line 3062: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3058: get_trans_str('CONTACTS', p_rule_id, l_sel_str, 'INT_TCA');
3059: l( l_sel_str);
3060: -- dbms_output.put_line('get_trans_str (CONTACTS int_tca) ' || l_sel_str);
3061: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3062: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3063: END IF;
3064: l_sel_str := '';
3065: /* H_P_SUBJECT_OS,
3066: H_P_SUBJECT_OSR,

Line 3086: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3082: l(' FOR I in H_P_CONTACT_OS.FIRST..H_P_CONTACT_OS.LAST LOOP ');
3083: get_trans_proc('CONTACTS', p_rule_id, l_trans_list);
3084: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
3085: -- dbms_output.put_line('get_trans_proc (CONTACTS int_tca)' || l_trans_list(I));
3086: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3087: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
3088: END IF;
3089: l(l_trans_list(I));
3090: l_trans_list.DELETE(I);

Line 3087: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));

3083: get_trans_proc('CONTACTS', p_rule_id, l_trans_list);
3084: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
3085: -- dbms_output.put_line('get_trans_proc (CONTACTS int_tca)' || l_trans_list(I));
3086: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3087: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
3088: END IF;
3089: l(l_trans_list(I));
3090: l_trans_list.DELETE(I);
3091: END LOOP ;

Line 3102: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3098: l(' INSERT INTO HZ_SRCH_CONTACTS ( ');
3099: get_insert_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_TCA');
3100: l( l_sel_str);
3101: -- dbms_output.put_line(' get_insert_str (CONTACTS int_tca)' || l_sel_str);
3102: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3103: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3104: END IF;
3105: l_sel_str := '';
3106: /* PARTY_OS,

Line 3103: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3099: get_insert_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_TCA');
3100: l( l_sel_str);
3101: -- dbms_output.put_line(' get_insert_str (CONTACTS int_tca)' || l_sel_str);
3102: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3103: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3104: END IF;
3105: l_sel_str := '';
3106: /* PARTY_OS,
3107: PARTY_OSR,

Line 3116: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3112: l(' ) VALUES ( ');
3113: get_insert_val_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_TCA');
3114: l( l_sel_str);
3115: -- dbms_output.put_line('get_insert_val_str (CONTACTS int_tca)' || l_sel_str);
3116: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3117: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3118: END IF;
3119: l_sel_str := '';
3120: /* H_P_SUBJECT_OS(I),

Line 3117: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3113: get_insert_val_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_TCA');
3114: l( l_sel_str);
3115: -- dbms_output.put_line('get_insert_val_str (CONTACTS int_tca)' || l_sel_str);
3116: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3117: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3118: END IF;
3119: l_sel_str := '';
3120: /* H_P_SUBJECT_OS(I),
3121: H_P_SUBJECT_OSR(I),

Line 3157: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3153: l_sel_str VARCHAR2(4000) := NULL;
3154: x_bool VARCHAR2(1);
3155: l_procedure_name VARCHAR2(30) := '.GEN_POP_CP' ;
3156: BEGIN
3157: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3158: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3159: END IF;
3160: l(' PROCEDURE pop_cp ( ');
3161: l(' p_batch_id IN NUMBER, ');

Line 3158: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

3154: x_bool VARCHAR2(1);
3155: l_procedure_name VARCHAR2(30) := '.GEN_POP_CP' ;
3156: BEGIN
3157: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3158: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3159: END IF;
3160: l(' PROCEDURE pop_cp ( ');
3161: l(' p_batch_id IN NUMBER, ');
3162: l(' p_from_osr IN VARCHAR2, ');

Line 3177: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3173: -- query for interface to tca
3174: l(' open l_cp_cur for ');
3175: get_select_str('CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_INT', NULL);
3176: l( l_sel_str);
3177: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3178: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3179: END IF;
3180:
3181: -- dbms_output.put_line('get_select_str (CONTACT_POINTS) ' || l_sel_str);

Line 3178: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3174: l(' open l_cp_cur for ');
3175: get_select_str('CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_INT', NULL);
3176: l( l_sel_str);
3177: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3178: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3179: END IF;
3180:
3181: -- dbms_output.put_line('get_select_str (CONTACT_POINTS) ' || l_sel_str);
3182: l_sel_str := '';

Line 3201: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3197: l(' FETCH l_cp_cur BULK COLLECT INTO ');
3198: get_trans_str('CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_INT');
3199: l( l_sel_str);
3200: -- dbms_output.put_line('get_trans_str (CONTACT_POINTS) ' || l_sel_str);
3201: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3202: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3203: END IF;
3204: l_sel_str := '';
3205: /* H_TX41

Line 3202: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3198: get_trans_str('CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_INT');
3199: l( l_sel_str);
3200: -- dbms_output.put_line('get_trans_str (CONTACT_POINTS) ' || l_sel_str);
3201: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3202: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3203: END IF;
3204: l_sel_str := '';
3205: /* H_TX41
3206: , H_P_PARTY_ID

Line 3229: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3225: l(' FOR I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST LOOP ');
3226: get_trans_proc('CONTACT_POINTS', p_rule_id, l_trans_list);
3227: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
3228: -- dbms_output.put_line(' get_trans_proc (CONTACT_POINTS) ' || l_trans_list(I));
3229: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3230: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
3231: END IF;
3232: l(l_trans_list(I));
3233: l_trans_list.DELETE(I);

Line 3230: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));

3226: get_trans_proc('CONTACT_POINTS', p_rule_id, l_trans_list);
3227: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
3228: -- dbms_output.put_line(' get_trans_proc (CONTACT_POINTS) ' || l_trans_list(I));
3229: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3230: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
3231: END IF;
3232: l(l_trans_list(I));
3233: l_trans_list.DELETE(I);
3234: END LOOP ;

Line 3246: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3242: l(' INSERT INTO HZ_SRCH_CPTS ( ');
3243: get_insert_str('HZ_STAGED_CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_INT');
3244: l( l_sel_str);
3245: -- dbms_output.put_line(' get_insert_str (CONTACT_POINTS) ' || l_sel_str);
3246: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3247: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3248: END IF;
3249: l_sel_str := '';
3250: /* PARTY_SITE_ID,

Line 3247: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3243: get_insert_str('HZ_STAGED_CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_INT');
3244: l( l_sel_str);
3245: -- dbms_output.put_line(' get_insert_str (CONTACT_POINTS) ' || l_sel_str);
3246: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3247: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3248: END IF;
3249: l_sel_str := '';
3250: /* PARTY_SITE_ID,
3251: PARTY_ID,

Line 3265: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3261: l(' ) VALUES ( ');
3262: get_insert_val_str('HZ_STAGED_CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_INT');
3263: l( l_sel_str);
3264: -- dbms_output.put_line('get_insert_val_str (CONTACT_POINTS) ' || l_sel_str);
3265: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3266: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3267: END IF;
3268: l_sel_str := '';
3269: /* H_P_PARTY_SITE_ID(I),

Line 3266: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3262: get_insert_val_str('HZ_STAGED_CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_INT');
3263: l( l_sel_str);
3264: -- dbms_output.put_line('get_insert_val_str (CONTACT_POINTS) ' || l_sel_str);
3265: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3266: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3267: END IF;
3268: l_sel_str := '';
3269: /* H_P_PARTY_SITE_ID(I),
3270: H_P_PARTY_ID(I),

Line 3312: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3308: l_sel_str VARCHAR2(4000) := NULL;
3309: x_bool VARCHAR2(1);
3310: l_procedure_name VARCHAR2(30) := '.GEN_POP_CP_INT' ;
3311: BEGIN
3312: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3313: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3314: END IF;
3315: l(' ');
3316: l(' PROCEDURE pop_cp_int ( ');

Line 3313: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

3309: x_bool VARCHAR2(1);
3310: l_procedure_name VARCHAR2(30) := '.GEN_POP_CP_INT' ;
3311: BEGIN
3312: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3313: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3314: END IF;
3315: l(' ');
3316: l(' PROCEDURE pop_cp_int ( ');
3317: l(' p_batch_id IN NUMBER, ');

Line 3335: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3331: get_select_str('CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_TCA', NULL);
3332: l_sel_str := l_sel_str || ' , a.party_id '; --bug 5393826
3333: l( l_sel_str);
3334: -- dbms_output.put_line('get_select_str (CONTACT_POINTS) ' || l_sel_str);
3335: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3336: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3337: END IF;
3338: l_sel_str := '';
3339: /* select a.email_address, a.party_orig_system_reference,

Line 3336: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3332: l_sel_str := l_sel_str || ' , a.party_id '; --bug 5393826
3333: l( l_sel_str);
3334: -- dbms_output.put_line('get_select_str (CONTACT_POINTS) ' || l_sel_str);
3335: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3336: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3337: END IF;
3338: l_sel_str := '';
3339: /* select a.email_address, a.party_orig_system_reference,
3340: a.party_orig_system, a.cp_orig_system, a.cp_orig_system_reference,

Line 3355: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3351: get_trans_str('CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_TCA');
3352: l_sel_str := l_sel_str || ' , H_P_PARTY_ID '; -- bug 5393826
3353: l( l_sel_str);
3354: -- dbms_output.put_line('get_trans_str (CONTACT_POINTS) ' || l_sel_str);
3355: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3356: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3357: END IF;
3358: l_sel_str := '';
3359: /* H_TX41

Line 3356: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3352: l_sel_str := l_sel_str || ' , H_P_PARTY_ID '; -- bug 5393826
3353: l( l_sel_str);
3354: -- dbms_output.put_line('get_trans_str (CONTACT_POINTS) ' || l_sel_str);
3355: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3356: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3357: END IF;
3358: l_sel_str := '';
3359: /* H_TX41
3360: , H_P_PARTY_OS

Line 3379: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3375: l(' FOR I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST LOOP ');
3376: get_trans_proc('CONTACT_POINTS', p_rule_id, l_trans_list);
3377: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
3378: -- dbms_output.put_line(' get_trans_proc (CONTACT_POINTS) ' || l_trans_list(I));
3379: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3380: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
3381: END IF;
3382: l(l_trans_list(I));
3383: l_trans_list.DELETE(I);

Line 3380: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));

3376: get_trans_proc('CONTACT_POINTS', p_rule_id, l_trans_list);
3377: FOR I in l_trans_list.FIRST..l_trans_list.LAST LOOP
3378: -- dbms_output.put_line(' get_trans_proc (CONTACT_POINTS) ' || l_trans_list(I));
3379: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3380: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_trans_list(I));
3381: END IF;
3382: l(l_trans_list(I));
3383: l_trans_list.DELETE(I);
3384: END LOOP ;

Line 3395: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3391: get_insert_str('HZ_STAGED_CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_TCA');
3392: l_sel_str := l_sel_str || ' , PARTY_ID '; -- bug 5393826
3393: l( l_sel_str);
3394: -- dbms_output.put_line(' get_insert_str (CONTACT_POINTS) ' || l_sel_str);
3395: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3396: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3397: END IF;
3398: l_sel_str := '';
3399: /* PARTY_OS,

Line 3396: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3392: l_sel_str := l_sel_str || ' , PARTY_ID '; -- bug 5393826
3393: l( l_sel_str);
3394: -- dbms_output.put_line(' get_insert_str (CONTACT_POINTS) ' || l_sel_str);
3395: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3396: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3397: END IF;
3398: l_sel_str := '';
3399: /* PARTY_OS,
3400: PARTY_OSR,

Line 3411: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3407: get_insert_val_str('HZ_STAGED_CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_TCA');
3408: l_sel_str := l_sel_str || ' ,H_P_PARTY_ID(I) '; -- bug 5393826
3409: l( l_sel_str);
3410: -- dbms_output.put_line('get_insert_val_str (CONTACT_POINTS) ' || l_sel_str);
3411: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3412: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3413: END IF;
3414: l_sel_str := '';
3415: /* H_P_PARTY_OS(I),

Line 3412: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);

3408: l_sel_str := l_sel_str || ' ,H_P_PARTY_ID(I) '; -- bug 5393826
3409: l( l_sel_str);
3410: -- dbms_output.put_line('get_insert_val_str (CONTACT_POINTS) ' || l_sel_str);
3411: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3412: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
3413: END IF;
3414: l_sel_str := '';
3415: /* H_P_PARTY_OS(I),
3416: H_P_PARTY_OSR(I),

Line 3452: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3448: ) IS
3449: is_using_allow_cust_attr VARCHAR2(1) := 'N';
3450: l_procedure_name VARCHAR2(30) := '.GEN_DECLARATIONS' ;
3451: BEGIN
3452: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3453: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3454: END IF;
3455: l(' g_match_rule_id NUMBER := ' ||p_rule_id || ';');
3456: l(' TYPE StageImpContactCurTyp IS REF CURSOR;');

Line 3453: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

3449: is_using_allow_cust_attr VARCHAR2(1) := 'N';
3450: l_procedure_name VARCHAR2(30) := '.GEN_DECLARATIONS' ;
3451: BEGIN
3452: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3453: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3454: END IF;
3455: l(' g_match_rule_id NUMBER := ' ||p_rule_id || ';');
3456: l(' TYPE StageImpContactCurTyp IS REF CURSOR;');
3457: l(' TYPE NumberList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;');

Line 3636: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3632: and col.table_name = syn.table_name
3633: and col.column_name = l_attribute_name
3634: and col.owner = l_owner;
3635: BEGIN
3636: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3637: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3638: END IF;
3639: l_attribute_name := p_attribute_name || '_STD';
3640: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner)) THEN

Line 3637: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

3633: and col.column_name = l_attribute_name
3634: and col.owner = l_owner;
3635: BEGIN
3636: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3637: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3638: END IF;
3639: l_attribute_name := p_attribute_name || '_STD';
3640: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner)) THEN
3641: OPEN c1;

Line 3661: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3657: ) IS
3658: l_procedure_name VARCHAR2(30) := '.CHK_RT_REQ' ;
3659: l_table_name VARCHAR2(30);
3660: BEGIN
3661: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3662: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3663: END IF;
3664: get_table_name(p_entity_name, l_table_name);
3665: BEGIN

Line 3662: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

3658: l_procedure_name VARCHAR2(30) := '.CHK_RT_REQ' ;
3659: l_table_name VARCHAR2(30);
3660: BEGIN
3661: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3662: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3663: END IF;
3664: get_table_name(p_entity_name, l_table_name);
3665: BEGIN
3666: IF (p_entity_name = 'CONTACTS') THEN

Line 3739: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3735: l_auto_merge_score NUMBER;
3736: tmp VARCHAR2(30);
3737: l_procedure_name VARCHAR2(30) := '.GEN_PKG_BODY' ;
3738: BEGIN
3739: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3740: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3741: END IF;
3742: IF is_test THEN
3743: l('CREATE or REPLACE PACKAGE BODY ' || p_pkg_name || ' IS'); -- this

Line 3740: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

3736: tmp VARCHAR2(30);
3737: l_procedure_name VARCHAR2(30) := '.GEN_PKG_BODY' ;
3738: BEGIN
3739: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3740: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3741: END IF;
3742: IF is_test THEN
3743: l('CREATE or REPLACE PACKAGE BODY ' || p_pkg_name || ' IS'); -- this
3744: END IF;

Line 3834: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3830: l_batch_flag VARCHAR2(1);
3831: l_package_name VARCHAR2(2000);
3832: l_procedure_name VARCHAR2(30) := '.GEN_HZ_DQM_IMP_DEBUG' ;
3833: BEGIN
3834: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3835: fnd_log_repository.init;
3836: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter, p_rule_id='||p_rule_id);
3837: END IF;
3838: --Initialize API return status to success.

Line 3835: fnd_log_repository.init;

3831: l_package_name VARCHAR2(2000);
3832: l_procedure_name VARCHAR2(30) := '.GEN_HZ_DQM_IMP_DEBUG' ;
3833: BEGIN
3834: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3835: fnd_log_repository.init;
3836: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter, p_rule_id='||p_rule_id);
3837: END IF;
3838: --Initialize API return status to success.
3839: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3836: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter, p_rule_id='||p_rule_id);

3832: l_procedure_name VARCHAR2(30) := '.GEN_HZ_DQM_IMP_DEBUG' ;
3833: BEGIN
3834: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3835: fnd_log_repository.init;
3836: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter, p_rule_id='||p_rule_id);
3837: END IF;
3838: --Initialize API return status to success.
3839: x_return_status := FND_API.G_RET_STS_SUCCESS;
3840: -- Initialize the compiled package name