DBA Data[Home] [Help]

APPS.PQP_UTILITIES dependencies on FND_MESSAGE

Line 570: fnd_message.raise_error;

566: THEN
567: DEBUG('Leaving: ' || l_proc_name, -999);
568: END IF;
569:
570: fnd_message.raise_error;
571: ELSE
572: RAISE;
573: END IF;
574: END get_config_type_values;

Line 655: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');

651: THEN
652: debug(l_message);
653: END IF;
654:
655: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
656: fnd_message.set_token('TOKEN', l_message);
657:
658: END debug_others;
659:

Line 656: fnd_message.set_token('TOKEN', l_message);

652: debug(l_message);
653: END IF;
654:
655: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
656: fnd_message.set_token('TOKEN', l_message);
657:
658: END debug_others;
659:
660: --

Line 797: fnd_message.set_name('PQP', 'PQP_230585_INV_ABS_ID');

793: IF g_debug THEN
794: debug(' No Data Found');
795: debug_exit(l_proc_name);
796: END IF;
797: fnd_message.set_name('PQP', 'PQP_230585_INV_ABS_ID');
798: fnd_message.set_token('P_KEY_VAL', p_key_col);
799: p_message := fnd_message.get();
800: p_error_code := -1;
801: RETURN NULL;

Line 798: fnd_message.set_token('P_KEY_VAL', p_key_col);

794: debug(' No Data Found');
795: debug_exit(l_proc_name);
796: END IF;
797: fnd_message.set_name('PQP', 'PQP_230585_INV_ABS_ID');
798: fnd_message.set_token('P_KEY_VAL', p_key_col);
799: p_message := fnd_message.get();
800: p_error_code := -1;
801: RETURN NULL;
802: -- Added by tmehra for nocopy changes Feb'03

Line 799: p_message := fnd_message.get();

795: debug_exit(l_proc_name);
796: END IF;
797: fnd_message.set_name('PQP', 'PQP_230585_INV_ABS_ID');
798: fnd_message.set_token('P_KEY_VAL', p_key_col);
799: p_message := fnd_message.get();
800: p_error_code := -1;
801: RETURN NULL;
802: -- Added by tmehra for nocopy changes Feb'03
803:

Line 812: fnd_message.set_name('PQP', 'PQP_230585_INV_ABS_ID');

808: debug(SQLCODE);
809: debug(SQLERRM);
810: debug_exit(l_proc_name);
811: END IF;
812: fnd_message.set_name('PQP', 'PQP_230585_INV_ABS_ID');
813: fnd_message.set_token('P_KEY_VAL', p_key_col);
814: p_message := fnd_message.get();
815: p_error_code := -1;
816: RETURN NULL;

Line 813: fnd_message.set_token('P_KEY_VAL', p_key_col);

809: debug(SQLERRM);
810: debug_exit(l_proc_name);
811: END IF;
812: fnd_message.set_name('PQP', 'PQP_230585_INV_ABS_ID');
813: fnd_message.set_token('P_KEY_VAL', p_key_col);
814: p_message := fnd_message.get();
815: p_error_code := -1;
816: RETURN NULL;
817: --

Line 814: p_message := fnd_message.get();

810: debug_exit(l_proc_name);
811: END IF;
812: fnd_message.set_name('PQP', 'PQP_230585_INV_ABS_ID');
813: fnd_message.set_token('P_KEY_VAL', p_key_col);
814: p_message := fnd_message.get();
815: p_error_code := -1;
816: RETURN NULL;
817: --
818: END get_col_value;

Line 846: fnd_message.set_name('PQP', 'PQP_230595_INV_COL_NAME');

842: FETCH csr_data_type INTO l_data_type;
843:
844: IF csr_data_type%NOTFOUND
845: THEN
846: fnd_message.set_name('PQP', 'PQP_230595_INV_COL_NAME');
847: fnd_message.set_token('P_COL_NAME', p_col_nam);
848: p_message := fnd_message.get();
849: p_error_code := -1;
850: END IF;

Line 847: fnd_message.set_token('P_COL_NAME', p_col_nam);

843:
844: IF csr_data_type%NOTFOUND
845: THEN
846: fnd_message.set_name('PQP', 'PQP_230595_INV_COL_NAME');
847: fnd_message.set_token('P_COL_NAME', p_col_nam);
848: p_message := fnd_message.get();
849: p_error_code := -1;
850: END IF;
851:

Line 848: p_message := fnd_message.get();

844: IF csr_data_type%NOTFOUND
845: THEN
846: fnd_message.set_name('PQP', 'PQP_230595_INV_COL_NAME');
847: fnd_message.set_token('P_COL_NAME', p_col_nam);
848: p_message := fnd_message.get();
849: p_error_code := -1;
850: END IF;
851:
852: CLOSE csr_data_type;

Line 868: fnd_message.set_name('PQP', 'PQP_230595_INV_COL_NAME');

864: debug(SQLCODE);
865: debug(SQLERRM);
866: debug_exit(l_proc_name);
867: END IF;
868: fnd_message.set_name('PQP', 'PQP_230595_INV_COL_NAME');
869: fnd_message.set_token('P_COL_NAME', p_col_nam);
870: p_message := fnd_message.get();
871: p_error_code := -1;
872: RETURN NULL;

Line 869: fnd_message.set_token('P_COL_NAME', p_col_nam);

865: debug(SQLERRM);
866: debug_exit(l_proc_name);
867: END IF;
868: fnd_message.set_name('PQP', 'PQP_230595_INV_COL_NAME');
869: fnd_message.set_token('P_COL_NAME', p_col_nam);
870: p_message := fnd_message.get();
871: p_error_code := -1;
872: RETURN NULL;
873: END get_data_type;

Line 870: p_message := fnd_message.get();

866: debug_exit(l_proc_name);
867: END IF;
868: fnd_message.set_name('PQP', 'PQP_230595_INV_COL_NAME');
869: fnd_message.set_token('P_COL_NAME', p_col_nam);
870: p_message := fnd_message.get();
871: p_error_code := -1;
872: RETURN NULL;
873: END get_data_type;
874:

Line 1095: fnd_message.set_name('PQP', 'PQP_230596_NO_FLEX_DATA');

1091: THEN
1092: IF g_debug THEN
1093: debug(l_proc_name, 30);
1094: END IF;
1095: fnd_message.set_name('PQP', 'PQP_230596_NO_FLEX_DATA');
1096: fnd_message.set_token('FLEX_NAME', p_flex_name);
1097: p_message := fnd_message.get();
1098: p_error_code := -1;
1099: RETURN NULL;

Line 1096: fnd_message.set_token('FLEX_NAME', p_flex_name);

1092: IF g_debug THEN
1093: debug(l_proc_name, 30);
1094: END IF;
1095: fnd_message.set_name('PQP', 'PQP_230596_NO_FLEX_DATA');
1096: fnd_message.set_token('FLEX_NAME', p_flex_name);
1097: p_message := fnd_message.get();
1098: p_error_code := -1;
1099: RETURN NULL;
1100: END IF;

Line 1097: p_message := fnd_message.get();

1093: debug(l_proc_name, 30);
1094: END IF;
1095: fnd_message.set_name('PQP', 'PQP_230596_NO_FLEX_DATA');
1096: fnd_message.set_token('FLEX_NAME', p_flex_name);
1097: p_message := fnd_message.get();
1098: p_error_code := -1;
1099: RETURN NULL;
1100: END IF;
1101: ELSE

Line 1181: fnd_message.set_name('PQP', 'PQP_230597_INV_SEG_NAME');

1177:
1178: --
1179: IF csr_seg_name%NOTFOUND
1180: THEN
1181: fnd_message.set_name('PQP', 'PQP_230597_INV_SEG_NAME');
1182: fnd_message.set_token('FLEX_TITLE', p_flex_field_title);
1183: p_message := fnd_message.get();
1184: p_error_code := -1;
1185: CLOSE csr_seg_name;

Line 1182: fnd_message.set_token('FLEX_TITLE', p_flex_field_title);

1178: --
1179: IF csr_seg_name%NOTFOUND
1180: THEN
1181: fnd_message.set_name('PQP', 'PQP_230597_INV_SEG_NAME');
1182: fnd_message.set_token('FLEX_TITLE', p_flex_field_title);
1183: p_message := fnd_message.get();
1184: p_error_code := -1;
1185: CLOSE csr_seg_name;
1186: IF g_debug THEN

Line 1183: p_message := fnd_message.get();

1179: IF csr_seg_name%NOTFOUND
1180: THEN
1181: fnd_message.set_name('PQP', 'PQP_230597_INV_SEG_NAME');
1182: fnd_message.set_token('FLEX_TITLE', p_flex_field_title);
1183: p_message := fnd_message.get();
1184: p_error_code := -1;
1185: CLOSE csr_seg_name;
1186: IF g_debug THEN
1187: debug(l_proc_name || p_message);

Line 1415: fnd_message.get_string('PQP', 'PQP_230602_INV_INFO_TYPE');

1411: IF g_debug THEN
1412: debug(l_proc_name,15);
1413: END IF;
1414: p_error_msg :=
1415: fnd_message.get_string('PQP', 'PQP_230602_INV_INFO_TYPE');
1416: CLOSE csr_mult_occur;
1417: RETURN -1;
1418: END IF;
1419:

Line 1542: fnd_message.get_string('PQP', 'PQP_230602_INV_INFO_TYPE');

1538:
1539: IF csr_mult_occur%NOTFOUND
1540: THEN
1541: p_error_msg :=
1542: fnd_message.get_string('PQP', 'PQP_230602_INV_INFO_TYPE');
1543: CLOSE csr_mult_occur;
1544: RETURN -1;
1545: END IF;
1546:

Line 1684: p_message := fnd_message.get_string('PQP', 'PQP_230601_INV_ELE_NAME');

1680: FETCH csr_element_type INTO l_element_type_id;
1681:
1682: IF csr_element_type%NOTFOUND
1683: THEN
1684: p_message := fnd_message.get_string('PQP', 'PQP_230601_INV_ELE_NAME');
1685: p_error_code := -1;
1686: END IF;
1687:
1688: CLOSE csr_element_type;

Line 2476: fnd_message.set_name('PQP', 'PQP_230598_INV_TITLE');

2472:
2473: --
2474: IF csr_lookup_code%NOTFOUND
2475: THEN
2476: fnd_message.set_name('PQP', 'PQP_230598_INV_TITLE');
2477: fnd_message.set_token('LKUP_MEANING', p_lookup_meaning);
2478: p_message := fnd_message.get();
2479: END IF;
2480:

Line 2477: fnd_message.set_token('LKUP_MEANING', p_lookup_meaning);

2473: --
2474: IF csr_lookup_code%NOTFOUND
2475: THEN
2476: fnd_message.set_name('PQP', 'PQP_230598_INV_TITLE');
2477: fnd_message.set_token('LKUP_MEANING', p_lookup_meaning);
2478: p_message := fnd_message.get();
2479: END IF;
2480:
2481: --

Line 2478: p_message := fnd_message.get();

2474: IF csr_lookup_code%NOTFOUND
2475: THEN
2476: fnd_message.set_name('PQP', 'PQP_230598_INV_TITLE');
2477: fnd_message.set_token('LKUP_MEANING', p_lookup_meaning);
2478: p_message := fnd_message.get();
2479: END IF;
2480:
2481: --
2482: CLOSE csr_lookup_code;

Line 2890: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');

2886: THEN
2887:
2888: --IF p_error_code <> hr_utility.hr_error_number
2889: --THEN
2890: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
2891: fnd_message.set_token('TOKEN', p_error_message);
2892: fnd_message.raise_error;
2893: --ELSE
2894: -- RAISE hr_application_error;

Line 2891: fnd_message.set_token('TOKEN', p_error_message);

2887:
2888: --IF p_error_code <> hr_utility.hr_error_number
2889: --THEN
2890: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
2891: fnd_message.set_token('TOKEN', p_error_message);
2892: fnd_message.raise_error;
2893: --ELSE
2894: -- RAISE hr_application_error;
2895: -- error is an application error , ie 20001 hence continue

Line 2892: fnd_message.raise_error;

2888: --IF p_error_code <> hr_utility.hr_error_number
2889: --THEN
2890: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
2891: fnd_message.set_token('TOKEN', p_error_message);
2892: fnd_message.raise_error;
2893: --ELSE
2894: -- RAISE hr_application_error;
2895: -- error is an application error , ie 20001 hence continue
2896: -- defined in header.

Line 2910: FUNCTION pqp_fnd_message_set_token(

2906:
2907: --
2908: --
2909: --
2910: FUNCTION pqp_fnd_message_set_token(
2911: token IN VARCHAR2
2912: ,value IN VARCHAR2
2913: ,translate IN VARCHAR2 DEFAULT 'N'
2914: ) RETURN NUMBER IS

Line 2918: BEGIN -- pqp_fnd_message_set_token

2914: ) RETURN NUMBER IS
2915:
2916: l_translate BOOLEAN := FALSE;
2917:
2918: BEGIN -- pqp_fnd_message_set_token
2919:
2920: IF translate = 'Y' THEN
2921: l_translate := TRUE;
2922: END IF;

Line 2924: fnd_message.set_token

2920: IF translate = 'Y' THEN
2921: l_translate := TRUE;
2922: END IF;
2923:
2924: fnd_message.set_token
2925: (token => token
2926: ,value => value
2927: ,translate => l_translate
2928: );

Line 2932: END; -- pqp_fnd_message_set_token

2928: );
2929:
2930: RETURN 0;
2931: --
2932: END; -- pqp_fnd_message_set_token
2933:
2934: --
2935: --
2936: --

Line 2937: FUNCTION pqp_fnd_message_set_name(

2933:
2934: --
2935: --
2936: --
2937: FUNCTION pqp_fnd_message_set_name(
2938: application IN VARCHAR2
2939: ,name IN VARCHAR2
2940: ) RETURN NUMBER IS
2941: BEGIN -- pqp_fnd_message_set_name

Line 2941: BEGIN -- pqp_fnd_message_set_name

2937: FUNCTION pqp_fnd_message_set_name(
2938: application IN VARCHAR2
2939: ,name IN VARCHAR2
2940: ) RETURN NUMBER IS
2941: BEGIN -- pqp_fnd_message_set_name
2942:
2943: fnd_message.set_name
2944: (application => application
2945: ,name => name

Line 2943: fnd_message.set_name

2939: ,name IN VARCHAR2
2940: ) RETURN NUMBER IS
2941: BEGIN -- pqp_fnd_message_set_name
2942:
2943: fnd_message.set_name
2944: (application => application
2945: ,name => name
2946: );
2947:

Line 2950: END; -- pqp_fnd_message_set_name

2946: );
2947:
2948: RETURN 0;
2949: --
2950: END; -- pqp_fnd_message_set_name
2951: --
2952: --
2953:
2954: