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.ECE_RULES_PKG dependencies on FND_MESSAGE

Line 549: fnd_message.set_name ('EC', 'ECE_TP_NOT_FOUND');

545: from ece_mappings
546: where map_id = p_map_id;
547: bug 2151462 */
548:
549: fnd_message.set_name ('EC', 'ECE_TP_NOT_FOUND');
550: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
551: fnd_message.set_token ('LOCATION_CODE', l_location_code);
552: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
553: fnd_message.set_token ('ORG_ID', to_char(l_org_id));

Line 550: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);

546: where map_id = p_map_id;
547: bug 2151462 */
548:
549: fnd_message.set_name ('EC', 'ECE_TP_NOT_FOUND');
550: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
551: fnd_message.set_token ('LOCATION_CODE', l_location_code);
552: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
553: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
554: x_msg_text := fnd_message.get;

Line 551: fnd_message.set_token ('LOCATION_CODE', l_location_code);

547: bug 2151462 */
548:
549: fnd_message.set_name ('EC', 'ECE_TP_NOT_FOUND');
550: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
551: fnd_message.set_token ('LOCATION_CODE', l_location_code);
552: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
553: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
554: x_msg_text := fnd_message.get;
555: ec_debug.pl (0, x_msg_text);

Line 552: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);

548:
549: fnd_message.set_name ('EC', 'ECE_TP_NOT_FOUND');
550: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
551: fnd_message.set_token ('LOCATION_CODE', l_location_code);
552: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
553: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
554: x_msg_text := fnd_message.get;
555: ec_debug.pl (0, x_msg_text);
556: elsif loop_count > 1 then --bug2151462

Line 553: fnd_message.set_token ('ORG_ID', to_char(l_org_id));

549: fnd_message.set_name ('EC', 'ECE_TP_NOT_FOUND');
550: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
551: fnd_message.set_token ('LOCATION_CODE', l_location_code);
552: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
553: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
554: x_msg_text := fnd_message.get;
555: ec_debug.pl (0, x_msg_text);
556: elsif loop_count > 1 then --bug2151462
557:

Line 554: x_msg_text := fnd_message.get;

550: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
551: fnd_message.set_token ('LOCATION_CODE', l_location_code);
552: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
553: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
554: x_msg_text := fnd_message.get;
555: ec_debug.pl (0, x_msg_text);
556: elsif loop_count > 1 then --bug2151462
557:
558: xProgress := 'ECERULEB-30-1090';

Line 560: fnd_message.set_name ('EC', 'ECE_MULTIPLE_TP_FOUND');

556: elsif loop_count > 1 then --bug2151462
557:
558: xProgress := 'ECERULEB-30-1090';
559: x_valid_rule := 'N';
560: fnd_message.set_name ('EC', 'ECE_MULTIPLE_TP_FOUND');
561: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
562: fnd_message.set_token ('LOCATION_CODE', l_location_code);
563: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
564: fnd_message.set_token ('ORG_ID', to_char(l_org_id));

Line 561: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);

557:
558: xProgress := 'ECERULEB-30-1090';
559: x_valid_rule := 'N';
560: fnd_message.set_name ('EC', 'ECE_MULTIPLE_TP_FOUND');
561: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
562: fnd_message.set_token ('LOCATION_CODE', l_location_code);
563: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
564: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
565: x_msg_text := fnd_message.get;

Line 562: fnd_message.set_token ('LOCATION_CODE', l_location_code);

558: xProgress := 'ECERULEB-30-1090';
559: x_valid_rule := 'N';
560: fnd_message.set_name ('EC', 'ECE_MULTIPLE_TP_FOUND');
561: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
562: fnd_message.set_token ('LOCATION_CODE', l_location_code);
563: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
564: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
565: x_msg_text := fnd_message.get;
566: ec_debug.pl (0, x_msg_text);

Line 563: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);

559: x_valid_rule := 'N';
560: fnd_message.set_name ('EC', 'ECE_MULTIPLE_TP_FOUND');
561: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
562: fnd_message.set_token ('LOCATION_CODE', l_location_code);
563: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
564: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
565: x_msg_text := fnd_message.get;
566: ec_debug.pl (0, x_msg_text);
567: elsif loop_count = 1 and l_edi_flag = 'N' then

Line 564: fnd_message.set_token ('ORG_ID', to_char(l_org_id));

560: fnd_message.set_name ('EC', 'ECE_MULTIPLE_TP_FOUND');
561: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
562: fnd_message.set_token ('LOCATION_CODE', l_location_code);
563: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
564: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
565: x_msg_text := fnd_message.get;
566: ec_debug.pl (0, x_msg_text);
567: elsif loop_count = 1 and l_edi_flag = 'N' then
568:

Line 565: x_msg_text := fnd_message.get;

561: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
562: fnd_message.set_token ('LOCATION_CODE', l_location_code);
563: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
564: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
565: x_msg_text := fnd_message.get;
566: ec_debug.pl (0, x_msg_text);
567: elsif loop_count = 1 and l_edi_flag = 'N' then
568:
569: xProgress := 'ECERULEB-30-1090';

Line 571: fnd_message.set_name ('EC', 'ECE_TP_NOT_ENABLED');

567: elsif loop_count = 1 and l_edi_flag = 'N' then
568:
569: xProgress := 'ECERULEB-30-1090';
570: x_valid_rule := 'N';
571: fnd_message.set_name ('EC', 'ECE_TP_NOT_ENABLED');
572: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
573: fnd_message.set_token ('LOCATION_CODE', l_location_code);
574: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
575: fnd_message.set_token ('ORG_ID', to_char(l_org_id));

Line 572: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);

568:
569: xProgress := 'ECERULEB-30-1090';
570: x_valid_rule := 'N';
571: fnd_message.set_name ('EC', 'ECE_TP_NOT_ENABLED');
572: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
573: fnd_message.set_token ('LOCATION_CODE', l_location_code);
574: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
575: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
576: x_msg_text := fnd_message.get;

Line 573: fnd_message.set_token ('LOCATION_CODE', l_location_code);

569: xProgress := 'ECERULEB-30-1090';
570: x_valid_rule := 'N';
571: fnd_message.set_name ('EC', 'ECE_TP_NOT_ENABLED');
572: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
573: fnd_message.set_token ('LOCATION_CODE', l_location_code);
574: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
575: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
576: x_msg_text := fnd_message.get;
577: ec_debug.pl (0, x_msg_text);

Line 574: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);

570: x_valid_rule := 'N';
571: fnd_message.set_name ('EC', 'ECE_TP_NOT_ENABLED');
572: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
573: fnd_message.set_token ('LOCATION_CODE', l_location_code);
574: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
575: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
576: x_msg_text := fnd_message.get;
577: ec_debug.pl (0, x_msg_text);
578: end if;

Line 575: fnd_message.set_token ('ORG_ID', to_char(l_org_id));

571: fnd_message.set_name ('EC', 'ECE_TP_NOT_ENABLED');
572: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
573: fnd_message.set_token ('LOCATION_CODE', l_location_code);
574: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
575: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
576: x_msg_text := fnd_message.get;
577: ec_debug.pl (0, x_msg_text);
578: end if;
579:

Line 576: x_msg_text := fnd_message.get;

572: fnd_message.set_token ('TRANSLATOR_CODE', l_translator_code);
573: fnd_message.set_token ('LOCATION_CODE', l_location_code);
574: fnd_message.set_token ('TRANSACTION_TYPE', p_transaction_type);
575: fnd_message.set_token ('ORG_ID', to_char(l_org_id));
576: x_msg_text := fnd_message.get;
577: ec_debug.pl (0, x_msg_text);
578: end if;
579:
580: if ec_debug.G_debug_level >= 2 then

Line 665: fnd_message.set_name ('EC', 'ECE_TEST_PROD');

661: (l_file_test_flag is null) or
662: (l_setup_test_flag is null) then
663: xProgress := 'ECERULEB-40-1020';
664: x_valid_rule := 'N';
665: fnd_message.set_name ('EC', 'ECE_TEST_PROD');
666: x_msg_text := fnd_message.get;
667: ec_debug.pl (0, x_msg_text);
668: end if;
669:

Line 666: x_msg_text := fnd_message.get;

662: (l_setup_test_flag is null) then
663: xProgress := 'ECERULEB-40-1020';
664: x_valid_rule := 'N';
665: fnd_message.set_name ('EC', 'ECE_TEST_PROD');
666: x_msg_text := fnd_message.get;
667: ec_debug.pl (0, x_msg_text);
668: end if;
669:
670: if ec_debug.G_debug_level >= 2 then

Line 1043: fnd_message.set_name ('EC', 'ECE_VALUE_REQUIRED');

1039:
1040: if (p_column_value is NULL) then
1041: xProgress := 'ECERULEB-60-1010';
1042: x_valid_rule := 'N';
1043: fnd_message.set_name ('EC', 'ECE_VALUE_REQUIRED');
1044: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1045: x_msg_text := fnd_message.get;
1046: ec_debug.pl (0, x_msg_text);
1047: end if;

Line 1044: fnd_message.set_token ('COLUMN_NAME', p_column_name);

1040: if (p_column_value is NULL) then
1041: xProgress := 'ECERULEB-60-1010';
1042: x_valid_rule := 'N';
1043: fnd_message.set_name ('EC', 'ECE_VALUE_REQUIRED');
1044: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1045: x_msg_text := fnd_message.get;
1046: ec_debug.pl (0, x_msg_text);
1047: end if;
1048:

Line 1045: x_msg_text := fnd_message.get;

1041: xProgress := 'ECERULEB-60-1010';
1042: x_valid_rule := 'N';
1043: fnd_message.set_name ('EC', 'ECE_VALUE_REQUIRED');
1044: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1045: x_msg_text := fnd_message.get;
1046: ec_debug.pl (0, x_msg_text);
1047: end if;
1048:
1049: if ec_debug.G_debug_level >= 2 then

Line 1169: fnd_message.set_name ('EC', 'ECE_SIMPLE_LOOKUP');

1165: dbms_sql.close_cursor (l_sel_c);
1166:
1167: if (x_valid_rule = 'N') then
1168: xProgress := 'ECERULEB-70-1120';
1169: fnd_message.set_name ('EC', 'ECE_SIMPLE_LOOKUP');
1170: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1171: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1172: fnd_message.set_token ('LOOKUP_SELECT', l_select);
1173: x_msg_text := fnd_message.get;

Line 1170: fnd_message.set_token ('COLUMN_NAME', p_column_name);

1166:
1167: if (x_valid_rule = 'N') then
1168: xProgress := 'ECERULEB-70-1120';
1169: fnd_message.set_name ('EC', 'ECE_SIMPLE_LOOKUP');
1170: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1171: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1172: fnd_message.set_token ('LOOKUP_SELECT', l_select);
1173: x_msg_text := fnd_message.get;
1174: ec_debug.pl (0, x_msg_text);

Line 1171: fnd_message.set_token ('COLUMN_VALUE', p_column_value);

1167: if (x_valid_rule = 'N') then
1168: xProgress := 'ECERULEB-70-1120';
1169: fnd_message.set_name ('EC', 'ECE_SIMPLE_LOOKUP');
1170: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1171: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1172: fnd_message.set_token ('LOOKUP_SELECT', l_select);
1173: x_msg_text := fnd_message.get;
1174: ec_debug.pl (0, x_msg_text);
1175: end if;

Line 1172: fnd_message.set_token ('LOOKUP_SELECT', l_select);

1168: xProgress := 'ECERULEB-70-1120';
1169: fnd_message.set_name ('EC', 'ECE_SIMPLE_LOOKUP');
1170: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1171: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1172: fnd_message.set_token ('LOOKUP_SELECT', l_select);
1173: x_msg_text := fnd_message.get;
1174: ec_debug.pl (0, x_msg_text);
1175: end if;
1176:

Line 1173: x_msg_text := fnd_message.get;

1169: fnd_message.set_name ('EC', 'ECE_SIMPLE_LOOKUP');
1170: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1171: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1172: fnd_message.set_token ('LOOKUP_SELECT', l_select);
1173: x_msg_text := fnd_message.get;
1174: ec_debug.pl (0, x_msg_text);
1175: end if;
1176:
1177: if ec_debug.G_debug_level >= 2 then

Line 1302: fnd_message.set_name ('EC', 'ECE_VALUESET');

1298: fnd_vset.get_value_end (l_valueset);
1299:
1300: if (x_valid_rule = 'N') then
1301: xProgress := 'ECERULEB-80-1110';
1302: fnd_message.set_name ('EC', 'ECE_VALUESET');
1303: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1304: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1305: fnd_message.set_token ('VALUESET', l_valueset_name);
1306: x_msg_text := fnd_message.get;

Line 1303: fnd_message.set_token ('COLUMN_NAME', p_column_name);

1299:
1300: if (x_valid_rule = 'N') then
1301: xProgress := 'ECERULEB-80-1110';
1302: fnd_message.set_name ('EC', 'ECE_VALUESET');
1303: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1304: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1305: fnd_message.set_token ('VALUESET', l_valueset_name);
1306: x_msg_text := fnd_message.get;
1307: ec_debug.pl (0, x_msg_text);

Line 1304: fnd_message.set_token ('COLUMN_VALUE', p_column_value);

1300: if (x_valid_rule = 'N') then
1301: xProgress := 'ECERULEB-80-1110';
1302: fnd_message.set_name ('EC', 'ECE_VALUESET');
1303: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1304: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1305: fnd_message.set_token ('VALUESET', l_valueset_name);
1306: x_msg_text := fnd_message.get;
1307: ec_debug.pl (0, x_msg_text);
1308: end if;

Line 1305: fnd_message.set_token ('VALUESET', l_valueset_name);

1301: xProgress := 'ECERULEB-80-1110';
1302: fnd_message.set_name ('EC', 'ECE_VALUESET');
1303: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1304: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1305: fnd_message.set_token ('VALUESET', l_valueset_name);
1306: x_msg_text := fnd_message.get;
1307: ec_debug.pl (0, x_msg_text);
1308: end if;
1309:

Line 1306: x_msg_text := fnd_message.get;

1302: fnd_message.set_name ('EC', 'ECE_VALUESET');
1303: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1304: fnd_message.set_token ('COLUMN_VALUE', p_column_value);
1305: fnd_message.set_token ('VALUESET', l_valueset_name);
1306: x_msg_text := fnd_message.get;
1307: ec_debug.pl (0, x_msg_text);
1308: end if;
1309:
1310: if ec_debug.G_debug_level >= 2 then

Line 1469: fnd_message.set_name ('EC', 'ECE_NULL_DEPENDENCY');

1465:
1466: else
1467: xProgress := 'ECERULEB-90-1100';
1468: x_valid_rule := 'N';
1469: fnd_message.set_name ('EC', 'ECE_NULL_DEPENDENCY');
1470: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1471: fnd_message.set_token ('COMPARISON_CODE', l_comp_code);
1472: x_msg_text := fnd_message.get;
1473: ec_debug.pl (0, x_msg_text);

Line 1470: fnd_message.set_token ('COLUMN_NAME', p_column_name);

1466: else
1467: xProgress := 'ECERULEB-90-1100';
1468: x_valid_rule := 'N';
1469: fnd_message.set_name ('EC', 'ECE_NULL_DEPENDENCY');
1470: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1471: fnd_message.set_token ('COMPARISON_CODE', l_comp_code);
1472: x_msg_text := fnd_message.get;
1473: ec_debug.pl (0, x_msg_text);
1474: end if;

Line 1471: fnd_message.set_token ('COMPARISON_CODE', l_comp_code);

1467: xProgress := 'ECERULEB-90-1100';
1468: x_valid_rule := 'N';
1469: fnd_message.set_name ('EC', 'ECE_NULL_DEPENDENCY');
1470: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1471: fnd_message.set_token ('COMPARISON_CODE', l_comp_code);
1472: x_msg_text := fnd_message.get;
1473: ec_debug.pl (0, x_msg_text);
1474: end if;
1475:

Line 1472: x_msg_text := fnd_message.get;

1468: x_valid_rule := 'N';
1469: fnd_message.set_name ('EC', 'ECE_NULL_DEPENDENCY');
1470: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1471: fnd_message.set_token ('COMPARISON_CODE', l_comp_code);
1472: x_msg_text := fnd_message.get;
1473: ec_debug.pl (0, x_msg_text);
1474: end if;
1475:
1476: end if;

Line 1564: fnd_message.set_name ('EC', 'ECE_PREDEFINED_LIST');

1560: end if;
1561:
1562: if (x_valid_rule = 'N') then
1563: xProgress := 'ECERULEB-100-1020';
1564: fnd_message.set_name ('EC', 'ECE_PREDEFINED_LIST');
1565: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1566: fnd_message.set_token ('VALUE', p_column_value);
1567:
1568: if (l_comp_code = 'MUST_EQUAL') then

Line 1565: fnd_message.set_token ('COLUMN_NAME', p_column_name);

1561:
1562: if (x_valid_rule = 'N') then
1563: xProgress := 'ECERULEB-100-1020';
1564: fnd_message.set_name ('EC', 'ECE_PREDEFINED_LIST');
1565: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1566: fnd_message.set_token ('VALUE', p_column_value);
1567:
1568: if (l_comp_code = 'MUST_EQUAL') then
1569: xProgress := 'ECERULEB-100-1030';

Line 1566: fnd_message.set_token ('VALUE', p_column_value);

1562: if (x_valid_rule = 'N') then
1563: xProgress := 'ECERULEB-100-1020';
1564: fnd_message.set_name ('EC', 'ECE_PREDEFINED_LIST');
1565: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1566: fnd_message.set_token ('VALUE', p_column_value);
1567:
1568: if (l_comp_code = 'MUST_EQUAL') then
1569: xProgress := 'ECERULEB-100-1030';
1570: fnd_message.set_token ('COMPARISON', 'MUST EXISTS');

Line 1570: fnd_message.set_token ('COMPARISON', 'MUST EXISTS');

1566: fnd_message.set_token ('VALUE', p_column_value);
1567:
1568: if (l_comp_code = 'MUST_EQUAL') then
1569: xProgress := 'ECERULEB-100-1030';
1570: fnd_message.set_token ('COMPARISON', 'MUST EXISTS');
1571:
1572: elsif (l_comp_code = 'CANNOT_EQUAL') then
1573: xProgress := 'ECERULEB-100-1040';
1574: fnd_message.set_token ('COMPARISON', 'CANNOT EXISTS');

Line 1574: fnd_message.set_token ('COMPARISON', 'CANNOT EXISTS');

1570: fnd_message.set_token ('COMPARISON', 'MUST EXISTS');
1571:
1572: elsif (l_comp_code = 'CANNOT_EQUAL') then
1573: xProgress := 'ECERULEB-100-1040';
1574: fnd_message.set_token ('COMPARISON', 'CANNOT EXISTS');
1575: end if;
1576: x_msg_text := fnd_message.get;
1577: ec_debug.pl (0, x_msg_text);
1578: end if;

Line 1576: x_msg_text := fnd_message.get;

1572: elsif (l_comp_code = 'CANNOT_EQUAL') then
1573: xProgress := 'ECERULEB-100-1040';
1574: fnd_message.set_token ('COMPARISON', 'CANNOT EXISTS');
1575: end if;
1576: x_msg_text := fnd_message.get;
1577: ec_debug.pl (0, x_msg_text);
1578: end if;
1579:
1580: if ec_debug.G_debug_level >= 2 then

Line 1685: fnd_message.set_name ('EC', 'ECE_NULL_DEFAULT');

1681: end if;
1682:
1683: xProgress := 'ECERULEB-110-1060';
1684: x_valid_rule := 'N';
1685: fnd_message.set_name ('EC', 'ECE_NULL_DEFAULT');
1686: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1687: fnd_message.set_token ('VALUE', l_column_value);
1688: x_msg_text := fnd_message.get;
1689: ec_debug.pl (0, x_msg_text);

Line 1686: fnd_message.set_token ('COLUMN_NAME', p_column_name);

1682:
1683: xProgress := 'ECERULEB-110-1060';
1684: x_valid_rule := 'N';
1685: fnd_message.set_name ('EC', 'ECE_NULL_DEFAULT');
1686: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1687: fnd_message.set_token ('VALUE', l_column_value);
1688: x_msg_text := fnd_message.get;
1689: ec_debug.pl (0, x_msg_text);
1690:

Line 1687: fnd_message.set_token ('VALUE', l_column_value);

1683: xProgress := 'ECERULEB-110-1060';
1684: x_valid_rule := 'N';
1685: fnd_message.set_name ('EC', 'ECE_NULL_DEFAULT');
1686: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1687: fnd_message.set_token ('VALUE', l_column_value);
1688: x_msg_text := fnd_message.get;
1689: ec_debug.pl (0, x_msg_text);
1690:
1691: end if;

Line 1688: x_msg_text := fnd_message.get;

1684: x_valid_rule := 'N';
1685: fnd_message.set_name ('EC', 'ECE_NULL_DEFAULT');
1686: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1687: fnd_message.set_token ('VALUE', l_column_value);
1688: x_msg_text := fnd_message.get;
1689: ec_debug.pl (0, x_msg_text);
1690:
1691: end if;
1692:

Line 1756: fnd_message.set_name ('EC', 'ECE_DATATYPE_CHECKING');

1752: END;
1753:
1754: if (x_valid_rule = 'N') then
1755: xProgress := 'ECERULEB-120-1040';
1756: fnd_message.set_name ('EC', 'ECE_DATATYPE_CHECKING');
1757: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1758: fnd_message.set_token ('VALUE', p_column_value);
1759: fnd_message.set_token ('DATATYPE', p_column_datatype);
1760: x_msg_text := fnd_message.get;

Line 1757: fnd_message.set_token ('COLUMN_NAME', p_column_name);

1753:
1754: if (x_valid_rule = 'N') then
1755: xProgress := 'ECERULEB-120-1040';
1756: fnd_message.set_name ('EC', 'ECE_DATATYPE_CHECKING');
1757: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1758: fnd_message.set_token ('VALUE', p_column_value);
1759: fnd_message.set_token ('DATATYPE', p_column_datatype);
1760: x_msg_text := fnd_message.get;
1761: ec_debug.pl (0, x_msg_text);

Line 1758: fnd_message.set_token ('VALUE', p_column_value);

1754: if (x_valid_rule = 'N') then
1755: xProgress := 'ECERULEB-120-1040';
1756: fnd_message.set_name ('EC', 'ECE_DATATYPE_CHECKING');
1757: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1758: fnd_message.set_token ('VALUE', p_column_value);
1759: fnd_message.set_token ('DATATYPE', p_column_datatype);
1760: x_msg_text := fnd_message.get;
1761: ec_debug.pl (0, x_msg_text);
1762: end if;

Line 1759: fnd_message.set_token ('DATATYPE', p_column_datatype);

1755: xProgress := 'ECERULEB-120-1040';
1756: fnd_message.set_name ('EC', 'ECE_DATATYPE_CHECKING');
1757: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1758: fnd_message.set_token ('VALUE', p_column_value);
1759: fnd_message.set_token ('DATATYPE', p_column_datatype);
1760: x_msg_text := fnd_message.get;
1761: ec_debug.pl (0, x_msg_text);
1762: end if;
1763:

Line 1760: x_msg_text := fnd_message.get;

1756: fnd_message.set_name ('EC', 'ECE_DATATYPE_CHECKING');
1757: fnd_message.set_token ('COLUMN_NAME', p_column_name);
1758: fnd_message.set_token ('VALUE', p_column_value);
1759: fnd_message.set_token ('DATATYPE', p_column_datatype);
1760: x_msg_text := fnd_message.get;
1761: ec_debug.pl (0, x_msg_text);
1762: end if;
1763:
1764: if ec_debug.G_debug_level >= 2 then

Line 2401: fnd_message.set_name ('EC', 'ECE_INCONSISENT_ADDRESS');

2397: /* bug 2151462 Added new messages and modified the existing ones */
2398:
2399: elsif (l_status_code = ece_trading_partners_pub.g_inconsistent_addr_comp) then
2400: xProgress := 'ECERULEB-130-1450';
2401: fnd_message.set_name ('EC', 'ECE_INCONSISENT_ADDRESS');
2402: fnd_message.set_token ('ADDRESS', p_address);
2403: fnd_message.set_token ('A1', l_addr1);
2404: fnd_message.set_token ('A2', l_addr2);
2405: fnd_message.set_token ('A3', l_addr3);

Line 2402: fnd_message.set_token ('ADDRESS', p_address);

2398:
2399: elsif (l_status_code = ece_trading_partners_pub.g_inconsistent_addr_comp) then
2400: xProgress := 'ECERULEB-130-1450';
2401: fnd_message.set_name ('EC', 'ECE_INCONSISENT_ADDRESS');
2402: fnd_message.set_token ('ADDRESS', p_address);
2403: fnd_message.set_token ('A1', l_addr1);
2404: fnd_message.set_token ('A2', l_addr2);
2405: fnd_message.set_token ('A3', l_addr3);
2406: fnd_message.set_token ('A4', l_addr4);

Line 2403: fnd_message.set_token ('A1', l_addr1);

2399: elsif (l_status_code = ece_trading_partners_pub.g_inconsistent_addr_comp) then
2400: xProgress := 'ECERULEB-130-1450';
2401: fnd_message.set_name ('EC', 'ECE_INCONSISENT_ADDRESS');
2402: fnd_message.set_token ('ADDRESS', p_address);
2403: fnd_message.set_token ('A1', l_addr1);
2404: fnd_message.set_token ('A2', l_addr2);
2405: fnd_message.set_token ('A3', l_addr3);
2406: fnd_message.set_token ('A4', l_addr4);
2407: fnd_message.set_token ('CITY', l_city);

Line 2404: fnd_message.set_token ('A2', l_addr2);

2400: xProgress := 'ECERULEB-130-1450';
2401: fnd_message.set_name ('EC', 'ECE_INCONSISENT_ADDRESS');
2402: fnd_message.set_token ('ADDRESS', p_address);
2403: fnd_message.set_token ('A1', l_addr1);
2404: fnd_message.set_token ('A2', l_addr2);
2405: fnd_message.set_token ('A3', l_addr3);
2406: fnd_message.set_token ('A4', l_addr4);
2407: fnd_message.set_token ('CITY', l_city);
2408: fnd_message.set_token ('POSTAL_CODE', l_zip);

Line 2405: fnd_message.set_token ('A3', l_addr3);

2401: fnd_message.set_name ('EC', 'ECE_INCONSISENT_ADDRESS');
2402: fnd_message.set_token ('ADDRESS', p_address);
2403: fnd_message.set_token ('A1', l_addr1);
2404: fnd_message.set_token ('A2', l_addr2);
2405: fnd_message.set_token ('A3', l_addr3);
2406: fnd_message.set_token ('A4', l_addr4);
2407: fnd_message.set_token ('CITY', l_city);
2408: fnd_message.set_token ('POSTAL_CODE', l_zip);
2409: fnd_message.set_token ('ORG_ID', l_org_id);

Line 2406: fnd_message.set_token ('A4', l_addr4);

2402: fnd_message.set_token ('ADDRESS', p_address);
2403: fnd_message.set_token ('A1', l_addr1);
2404: fnd_message.set_token ('A2', l_addr2);
2405: fnd_message.set_token ('A3', l_addr3);
2406: fnd_message.set_token ('A4', l_addr4);
2407: fnd_message.set_token ('CITY', l_city);
2408: fnd_message.set_token ('POSTAL_CODE', l_zip);
2409: fnd_message.set_token ('ORG_ID', l_org_id);
2410: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);

Line 2407: fnd_message.set_token ('CITY', l_city);

2403: fnd_message.set_token ('A1', l_addr1);
2404: fnd_message.set_token ('A2', l_addr2);
2405: fnd_message.set_token ('A3', l_addr3);
2406: fnd_message.set_token ('A4', l_addr4);
2407: fnd_message.set_token ('CITY', l_city);
2408: fnd_message.set_token ('POSTAL_CODE', l_zip);
2409: fnd_message.set_token ('ORG_ID', l_org_id);
2410: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2411: l_msg_text := fnd_message.get;

Line 2408: fnd_message.set_token ('POSTAL_CODE', l_zip);

2404: fnd_message.set_token ('A2', l_addr2);
2405: fnd_message.set_token ('A3', l_addr3);
2406: fnd_message.set_token ('A4', l_addr4);
2407: fnd_message.set_token ('CITY', l_city);
2408: fnd_message.set_token ('POSTAL_CODE', l_zip);
2409: fnd_message.set_token ('ORG_ID', l_org_id);
2410: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2411: l_msg_text := fnd_message.get;
2412: ec_debug.pl (0, l_msg_text);

Line 2409: fnd_message.set_token ('ORG_ID', l_org_id);

2405: fnd_message.set_token ('A3', l_addr3);
2406: fnd_message.set_token ('A4', l_addr4);
2407: fnd_message.set_token ('CITY', l_city);
2408: fnd_message.set_token ('POSTAL_CODE', l_zip);
2409: fnd_message.set_token ('ORG_ID', l_org_id);
2410: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2411: l_msg_text := fnd_message.get;
2412: ec_debug.pl (0, l_msg_text);
2413: l_valid_rule := 'N';

Line 2410: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);

2406: fnd_message.set_token ('A4', l_addr4);
2407: fnd_message.set_token ('CITY', l_city);
2408: fnd_message.set_token ('POSTAL_CODE', l_zip);
2409: fnd_message.set_token ('ORG_ID', l_org_id);
2410: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2411: l_msg_text := fnd_message.get;
2412: ec_debug.pl (0, l_msg_text);
2413: l_valid_rule := 'N';
2414:

Line 2411: l_msg_text := fnd_message.get;

2407: fnd_message.set_token ('CITY', l_city);
2408: fnd_message.set_token ('POSTAL_CODE', l_zip);
2409: fnd_message.set_token ('ORG_ID', l_org_id);
2410: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2411: l_msg_text := fnd_message.get;
2412: ec_debug.pl (0, l_msg_text);
2413: l_valid_rule := 'N';
2414:
2415: elsif (l_status_code = ece_trading_partners_pub.g_multiple_addr_found) then

Line 2417: fnd_message.set_name ('EC', 'ECE_MULTIPLE_ADDR_FOUND');

2413: l_valid_rule := 'N';
2414:
2415: elsif (l_status_code = ece_trading_partners_pub.g_multiple_addr_found) then
2416: xProgress := 'ECERULEB-130-1460';
2417: fnd_message.set_name ('EC', 'ECE_MULTIPLE_ADDR_FOUND');
2418: fnd_message.set_token ('ADDRESS', p_address);
2419: fnd_message.set_token ('A1', l_addr1);
2420: fnd_message.set_token ('A2', l_addr2);
2421: fnd_message.set_token ('A3', l_addr3);

Line 2418: fnd_message.set_token ('ADDRESS', p_address);

2414:
2415: elsif (l_status_code = ece_trading_partners_pub.g_multiple_addr_found) then
2416: xProgress := 'ECERULEB-130-1460';
2417: fnd_message.set_name ('EC', 'ECE_MULTIPLE_ADDR_FOUND');
2418: fnd_message.set_token ('ADDRESS', p_address);
2419: fnd_message.set_token ('A1', l_addr1);
2420: fnd_message.set_token ('A2', l_addr2);
2421: fnd_message.set_token ('A3', l_addr3);
2422: fnd_message.set_token ('A4', l_addr4);

Line 2419: fnd_message.set_token ('A1', l_addr1);

2415: elsif (l_status_code = ece_trading_partners_pub.g_multiple_addr_found) then
2416: xProgress := 'ECERULEB-130-1460';
2417: fnd_message.set_name ('EC', 'ECE_MULTIPLE_ADDR_FOUND');
2418: fnd_message.set_token ('ADDRESS', p_address);
2419: fnd_message.set_token ('A1', l_addr1);
2420: fnd_message.set_token ('A2', l_addr2);
2421: fnd_message.set_token ('A3', l_addr3);
2422: fnd_message.set_token ('A4', l_addr4);
2423: fnd_message.set_token ('CITY', l_city);

Line 2420: fnd_message.set_token ('A2', l_addr2);

2416: xProgress := 'ECERULEB-130-1460';
2417: fnd_message.set_name ('EC', 'ECE_MULTIPLE_ADDR_FOUND');
2418: fnd_message.set_token ('ADDRESS', p_address);
2419: fnd_message.set_token ('A1', l_addr1);
2420: fnd_message.set_token ('A2', l_addr2);
2421: fnd_message.set_token ('A3', l_addr3);
2422: fnd_message.set_token ('A4', l_addr4);
2423: fnd_message.set_token ('CITY', l_city);
2424: fnd_message.set_token ('POSTAL_CODE', l_zip);

Line 2421: fnd_message.set_token ('A3', l_addr3);

2417: fnd_message.set_name ('EC', 'ECE_MULTIPLE_ADDR_FOUND');
2418: fnd_message.set_token ('ADDRESS', p_address);
2419: fnd_message.set_token ('A1', l_addr1);
2420: fnd_message.set_token ('A2', l_addr2);
2421: fnd_message.set_token ('A3', l_addr3);
2422: fnd_message.set_token ('A4', l_addr4);
2423: fnd_message.set_token ('CITY', l_city);
2424: fnd_message.set_token ('POSTAL_CODE', l_zip);
2425: fnd_message.set_token ('ORG_ID', l_org_id);

Line 2422: fnd_message.set_token ('A4', l_addr4);

2418: fnd_message.set_token ('ADDRESS', p_address);
2419: fnd_message.set_token ('A1', l_addr1);
2420: fnd_message.set_token ('A2', l_addr2);
2421: fnd_message.set_token ('A3', l_addr3);
2422: fnd_message.set_token ('A4', l_addr4);
2423: fnd_message.set_token ('CITY', l_city);
2424: fnd_message.set_token ('POSTAL_CODE', l_zip);
2425: fnd_message.set_token ('ORG_ID', l_org_id);
2426: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);

Line 2423: fnd_message.set_token ('CITY', l_city);

2419: fnd_message.set_token ('A1', l_addr1);
2420: fnd_message.set_token ('A2', l_addr2);
2421: fnd_message.set_token ('A3', l_addr3);
2422: fnd_message.set_token ('A4', l_addr4);
2423: fnd_message.set_token ('CITY', l_city);
2424: fnd_message.set_token ('POSTAL_CODE', l_zip);
2425: fnd_message.set_token ('ORG_ID', l_org_id);
2426: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2427: l_msg_text := fnd_message.get;

Line 2424: fnd_message.set_token ('POSTAL_CODE', l_zip);

2420: fnd_message.set_token ('A2', l_addr2);
2421: fnd_message.set_token ('A3', l_addr3);
2422: fnd_message.set_token ('A4', l_addr4);
2423: fnd_message.set_token ('CITY', l_city);
2424: fnd_message.set_token ('POSTAL_CODE', l_zip);
2425: fnd_message.set_token ('ORG_ID', l_org_id);
2426: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2427: l_msg_text := fnd_message.get;
2428: ec_debug.pl (0, l_msg_text);

Line 2425: fnd_message.set_token ('ORG_ID', l_org_id);

2421: fnd_message.set_token ('A3', l_addr3);
2422: fnd_message.set_token ('A4', l_addr4);
2423: fnd_message.set_token ('CITY', l_city);
2424: fnd_message.set_token ('POSTAL_CODE', l_zip);
2425: fnd_message.set_token ('ORG_ID', l_org_id);
2426: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2427: l_msg_text := fnd_message.get;
2428: ec_debug.pl (0, l_msg_text);
2429: l_valid_rule := 'N';

Line 2426: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);

2422: fnd_message.set_token ('A4', l_addr4);
2423: fnd_message.set_token ('CITY', l_city);
2424: fnd_message.set_token ('POSTAL_CODE', l_zip);
2425: fnd_message.set_token ('ORG_ID', l_org_id);
2426: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2427: l_msg_text := fnd_message.get;
2428: ec_debug.pl (0, l_msg_text);
2429: l_valid_rule := 'N';
2430:

Line 2427: l_msg_text := fnd_message.get;

2423: fnd_message.set_token ('CITY', l_city);
2424: fnd_message.set_token ('POSTAL_CODE', l_zip);
2425: fnd_message.set_token ('ORG_ID', l_org_id);
2426: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2427: l_msg_text := fnd_message.get;
2428: ec_debug.pl (0, l_msg_text);
2429: l_valid_rule := 'N';
2430:
2431: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr) then

Line 2433: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS');

2429: l_valid_rule := 'N';
2430:
2431: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr) then
2432: xProgress := 'ECERULEB-130-1470';
2433: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS');
2434: fnd_message.set_token ('ADDRESS', p_address);
2435: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2436: fnd_message.set_token ('ORG_ID', l_org_id);
2437: l_msg_text := fnd_message.get;

Line 2434: fnd_message.set_token ('ADDRESS', p_address);

2430:
2431: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr) then
2432: xProgress := 'ECERULEB-130-1470';
2433: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS');
2434: fnd_message.set_token ('ADDRESS', p_address);
2435: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2436: fnd_message.set_token ('ORG_ID', l_org_id);
2437: l_msg_text := fnd_message.get;
2438: ec_debug.pl (0, l_msg_text);

Line 2435: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);

2431: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr) then
2432: xProgress := 'ECERULEB-130-1470';
2433: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS');
2434: fnd_message.set_token ('ADDRESS', p_address);
2435: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2436: fnd_message.set_token ('ORG_ID', l_org_id);
2437: l_msg_text := fnd_message.get;
2438: ec_debug.pl (0, l_msg_text);
2439: l_valid_rule := 'N';

Line 2436: fnd_message.set_token ('ORG_ID', l_org_id);

2432: xProgress := 'ECERULEB-130-1470';
2433: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS');
2434: fnd_message.set_token ('ADDRESS', p_address);
2435: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2436: fnd_message.set_token ('ORG_ID', l_org_id);
2437: l_msg_text := fnd_message.get;
2438: ec_debug.pl (0, l_msg_text);
2439: l_valid_rule := 'N';
2440:

Line 2437: l_msg_text := fnd_message.get;

2433: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS');
2434: fnd_message.set_token ('ADDRESS', p_address);
2435: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2436: fnd_message.set_token ('ORG_ID', l_org_id);
2437: l_msg_text := fnd_message.get;
2438: ec_debug.pl (0, l_msg_text);
2439: l_valid_rule := 'N';
2440:
2441: elsif (l_status_code = ece_trading_partners_pub.g_multiple_loc_found) then

Line 2443: fnd_message.set_name ('EC', 'ECE_MULTIPLE_LOC_FOUND');

2439: l_valid_rule := 'N';
2440:
2441: elsif (l_status_code = ece_trading_partners_pub.g_multiple_loc_found) then
2442: xProgress := 'ECERULEB-130-1480';
2443: fnd_message.set_name ('EC', 'ECE_MULTIPLE_LOC_FOUND');
2444: fnd_message.set_token ('ADDRESS', p_address);
2445: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2446: fnd_message.set_token ('ORG_ID', l_org_id);
2447: l_msg_text := fnd_message.get;

Line 2444: fnd_message.set_token ('ADDRESS', p_address);

2440:
2441: elsif (l_status_code = ece_trading_partners_pub.g_multiple_loc_found) then
2442: xProgress := 'ECERULEB-130-1480';
2443: fnd_message.set_name ('EC', 'ECE_MULTIPLE_LOC_FOUND');
2444: fnd_message.set_token ('ADDRESS', p_address);
2445: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2446: fnd_message.set_token ('ORG_ID', l_org_id);
2447: l_msg_text := fnd_message.get;
2448: ec_debug.pl (0, l_msg_text);

Line 2445: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);

2441: elsif (l_status_code = ece_trading_partners_pub.g_multiple_loc_found) then
2442: xProgress := 'ECERULEB-130-1480';
2443: fnd_message.set_name ('EC', 'ECE_MULTIPLE_LOC_FOUND');
2444: fnd_message.set_token ('ADDRESS', p_address);
2445: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2446: fnd_message.set_token ('ORG_ID', l_org_id);
2447: l_msg_text := fnd_message.get;
2448: ec_debug.pl (0, l_msg_text);
2449: l_valid_rule := 'N';

Line 2446: fnd_message.set_token ('ORG_ID', l_org_id);

2442: xProgress := 'ECERULEB-130-1480';
2443: fnd_message.set_name ('EC', 'ECE_MULTIPLE_LOC_FOUND');
2444: fnd_message.set_token ('ADDRESS', p_address);
2445: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2446: fnd_message.set_token ('ORG_ID', l_org_id);
2447: l_msg_text := fnd_message.get;
2448: ec_debug.pl (0, l_msg_text);
2449: l_valid_rule := 'N';
2450:

Line 2447: l_msg_text := fnd_message.get;

2443: fnd_message.set_name ('EC', 'ECE_MULTIPLE_LOC_FOUND');
2444: fnd_message.set_token ('ADDRESS', p_address);
2445: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);
2446: fnd_message.set_token ('ORG_ID', l_org_id);
2447: l_msg_text := fnd_message.get;
2448: ec_debug.pl (0, l_msg_text);
2449: l_valid_rule := 'N';
2450:
2451: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr_id) then

Line 2453: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS_ID');

2449: l_valid_rule := 'N';
2450:
2451: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr_id) then
2452: xProgress := 'ECERULEB-130-1490';
2453: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS_ID');
2454: fnd_message.set_token ('ADDRESS', p_address);
2455: l_msg_text := fnd_message.get;
2456: ec_debug.pl (0, l_msg_text);
2457: l_valid_rule := 'N';

Line 2454: fnd_message.set_token ('ADDRESS', p_address);

2450:
2451: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr_id) then
2452: xProgress := 'ECERULEB-130-1490';
2453: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS_ID');
2454: fnd_message.set_token ('ADDRESS', p_address);
2455: l_msg_text := fnd_message.get;
2456: ec_debug.pl (0, l_msg_text);
2457: l_valid_rule := 'N';
2458: end if;

Line 2455: l_msg_text := fnd_message.get;

2451: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr_id) then
2452: xProgress := 'ECERULEB-130-1490';
2453: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS_ID');
2454: fnd_message.set_token ('ADDRESS', p_address);
2455: l_msg_text := fnd_message.get;
2456: ec_debug.pl (0, l_msg_text);
2457: l_valid_rule := 'N';
2458: end if;
2459:

Line 2463: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_ID');

2459:
2460: else
2461: if (l_status_code = ece_trading_partners_pub.g_invalid_addr_id) then
2462: xProgress := 'ECERULEB-130-1500';
2463: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_ID');
2464: fnd_message.set_token ('ADDRESS', p_address);
2465: fnd_message.set_token ('ADDRESS_ID', l_addr_id);
2466: fnd_message.set_token ('ORG_ID', l_org_id);
2467: l_msg_text := fnd_message.get;

Line 2464: fnd_message.set_token ('ADDRESS', p_address);

2460: else
2461: if (l_status_code = ece_trading_partners_pub.g_invalid_addr_id) then
2462: xProgress := 'ECERULEB-130-1500';
2463: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_ID');
2464: fnd_message.set_token ('ADDRESS', p_address);
2465: fnd_message.set_token ('ADDRESS_ID', l_addr_id);
2466: fnd_message.set_token ('ORG_ID', l_org_id);
2467: l_msg_text := fnd_message.get;
2468: ec_debug.pl (0, l_msg_text);

Line 2465: fnd_message.set_token ('ADDRESS_ID', l_addr_id);

2461: if (l_status_code = ece_trading_partners_pub.g_invalid_addr_id) then
2462: xProgress := 'ECERULEB-130-1500';
2463: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_ID');
2464: fnd_message.set_token ('ADDRESS', p_address);
2465: fnd_message.set_token ('ADDRESS_ID', l_addr_id);
2466: fnd_message.set_token ('ORG_ID', l_org_id);
2467: l_msg_text := fnd_message.get;
2468: ec_debug.pl (0, l_msg_text);
2469: l_valid_rule := 'N';

Line 2466: fnd_message.set_token ('ORG_ID', l_org_id);

2462: xProgress := 'ECERULEB-130-1500';
2463: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_ID');
2464: fnd_message.set_token ('ADDRESS', p_address);
2465: fnd_message.set_token ('ADDRESS_ID', l_addr_id);
2466: fnd_message.set_token ('ORG_ID', l_org_id);
2467: l_msg_text := fnd_message.get;
2468: ec_debug.pl (0, l_msg_text);
2469: l_valid_rule := 'N';
2470:

Line 2467: l_msg_text := fnd_message.get;

2463: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_ID');
2464: fnd_message.set_token ('ADDRESS', p_address);
2465: fnd_message.set_token ('ADDRESS_ID', l_addr_id);
2466: fnd_message.set_token ('ORG_ID', l_org_id);
2467: l_msg_text := fnd_message.get;
2468: ec_debug.pl (0, l_msg_text);
2469: l_valid_rule := 'N';
2470:
2471: elsif (l_status_code = ece_trading_partners_pub.g_invalid_org_id) then

Line 2473: fnd_message.set_name ('EC', 'ECE_INVALID_ORG_ID');

2469: l_valid_rule := 'N';
2470:
2471: elsif (l_status_code = ece_trading_partners_pub.g_invalid_org_id) then
2472: xProgress := 'ECERULEB-130-1510';
2473: fnd_message.set_name ('EC', 'ECE_INVALID_ORG_ID');
2474: fnd_message.set_token ('ORG_ID', l_org_id);
2475: l_msg_text := fnd_message.get;
2476: ec_debug.pl (0, l_msg_text);
2477: l_valid_rule := 'N';

Line 2474: fnd_message.set_token ('ORG_ID', l_org_id);

2470:
2471: elsif (l_status_code = ece_trading_partners_pub.g_invalid_org_id) then
2472: xProgress := 'ECERULEB-130-1510';
2473: fnd_message.set_name ('EC', 'ECE_INVALID_ORG_ID');
2474: fnd_message.set_token ('ORG_ID', l_org_id);
2475: l_msg_text := fnd_message.get;
2476: ec_debug.pl (0, l_msg_text);
2477: l_valid_rule := 'N';
2478:

Line 2475: l_msg_text := fnd_message.get;

2471: elsif (l_status_code = ece_trading_partners_pub.g_invalid_org_id) then
2472: xProgress := 'ECERULEB-130-1510';
2473: fnd_message.set_name ('EC', 'ECE_INVALID_ORG_ID');
2474: fnd_message.set_token ('ORG_ID', l_org_id);
2475: l_msg_text := fnd_message.get;
2476: ec_debug.pl (0, l_msg_text);
2477: l_valid_rule := 'N';
2478:
2479: elsif (l_status_code = ece_trading_partners_pub.g_invalid_parameter) then

Line 2481: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_PARAMETER');

2477: l_valid_rule := 'N';
2478:
2479: elsif (l_status_code = ece_trading_partners_pub.g_invalid_parameter) then
2480: xProgress := 'ECERULEB-130-1520';
2481: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_PARAMETER');
2482: fnd_message.set_token ('ADDRESS', p_address);
2483: l_msg_text := fnd_message.get;
2484: ec_debug.pl (0, l_msg_text);
2485: l_valid_rule := 'N';

Line 2482: fnd_message.set_token ('ADDRESS', p_address);

2478:
2479: elsif (l_status_code = ece_trading_partners_pub.g_invalid_parameter) then
2480: xProgress := 'ECERULEB-130-1520';
2481: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_PARAMETER');
2482: fnd_message.set_token ('ADDRESS', p_address);
2483: l_msg_text := fnd_message.get;
2484: ec_debug.pl (0, l_msg_text);
2485: l_valid_rule := 'N';
2486:

Line 2483: l_msg_text := fnd_message.get;

2479: elsif (l_status_code = ece_trading_partners_pub.g_invalid_parameter) then
2480: xProgress := 'ECERULEB-130-1520';
2481: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_PARAMETER');
2482: fnd_message.set_token ('ADDRESS', p_address);
2483: l_msg_text := fnd_message.get;
2484: ec_debug.pl (0, l_msg_text);
2485: l_valid_rule := 'N';
2486:
2487: else