691: ELSE -- Else return = -1 from get table value function
692:
693: debug_exit(l_proc_name);
694:
695: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
696: fnd_message.set_token ('TOKEN', l_error_msg);
697: fnd_message.raise_error;
698:
699: END IF; -- End if of return <> -1 check from get table value func...
692:
693: debug_exit(l_proc_name);
694:
695: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
696: fnd_message.set_token ('TOKEN', l_error_msg);
697: fnd_message.raise_error;
698:
699: END IF; -- End if of return <> -1 check from get table value func...
700:
693: debug_exit(l_proc_name);
694:
695: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
696: fnd_message.set_token ('TOKEN', l_error_msg);
697: fnd_message.raise_error;
698:
699: END IF; -- End if of return <> -1 check from get table value func...
700:
701: debug_exit(l_proc_name);
858: ELSE -- Else return = -1 from get table value function
859:
860: debug_exit(l_proc_name);
861:
862: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
863: fnd_message.set_token ('TOKEN', l_error_msg);
864: fnd_message.raise_error;
865:
866: END IF; -- End if of return <> -1 check from get table value func...
859:
860: debug_exit(l_proc_name);
861:
862: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
863: fnd_message.set_token ('TOKEN', l_error_msg);
864: fnd_message.raise_error;
865:
866: END IF; -- End if of return <> -1 check from get table value func...
867: --
860: debug_exit(l_proc_name);
861:
862: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
863: fnd_message.set_token ('TOKEN', l_error_msg);
864: fnd_message.raise_error;
865:
866: END IF; -- End if of return <> -1 check from get table value func...
867: --
868:
1002: ELSE -- Else return = -1 from get table value function
1003: debug('Leaving: '
1004: || l_proc_name, 40);
1005:
1006: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1007: fnd_message.set_token ('TOKEN', l_error_msg);
1008: fnd_message.raise_error;
1009:
1010: END IF; -- End if of return <> -1 check from get table value func...
1003: debug('Leaving: '
1004: || l_proc_name, 40);
1005:
1006: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1007: fnd_message.set_token ('TOKEN', l_error_msg);
1008: fnd_message.raise_error;
1009:
1010: END IF; -- End if of return <> -1 check from get table value func...
1011: --
1004: || l_proc_name, 40);
1005:
1006: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1007: fnd_message.set_token ('TOKEN', l_error_msg);
1008: fnd_message.raise_error;
1009:
1010: END IF; -- End if of return <> -1 check from get table value func...
1011: --
1012: -- Store it in the management allowance collection
1087: ELSE -- Else return = -1 from get table value function
1088:
1089: debug('Leaving: ' || l_proc_name,80);
1090:
1091: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1092: fnd_message.set_token ('TOKEN', l_error_msg);
1093: fnd_message.raise_error;
1094:
1095: END IF; -- End if of return <> -1 check from get table value func...
1088:
1089: debug('Leaving: ' || l_proc_name,80);
1090:
1091: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1092: fnd_message.set_token ('TOKEN', l_error_msg);
1093: fnd_message.raise_error;
1094:
1095: END IF; -- End if of return <> -1 check from get table value func...
1096:
1089: debug('Leaving: ' || l_proc_name,80);
1090:
1091: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1092: fnd_message.set_token ('TOKEN', l_error_msg);
1093: fnd_message.raise_error;
1094:
1095: END IF; -- End if of return <> -1 check from get table value func...
1096:
1097: -- RET1.a : start of block
1214: ELSE -- Else return = -1 from get table value function
1215: debug('Leaving: '
1216: || l_proc_name, 140);
1217:
1218: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1219: fnd_message.set_token ('TOKEN', l_error_msg);
1220: fnd_message.raise_error;
1221:
1222: END IF; -- End if of return <> -1 check from get table value func...
1215: debug('Leaving: '
1216: || l_proc_name, 140);
1217:
1218: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1219: fnd_message.set_token ('TOKEN', l_error_msg);
1220: fnd_message.raise_error;
1221:
1222: END IF; -- End if of return <> -1 check from get table value func...
1223: --
1216: || l_proc_name, 140);
1217:
1218: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1219: fnd_message.set_token ('TOKEN', l_error_msg);
1220: fnd_message.raise_error;
1221:
1222: END IF; -- End if of return <> -1 check from get table value func...
1223: --
1224: -- Store it in the TLR allowance collection
3998: debug_enter(l_proc_name);
3999:
4000: IF g_multi_lea_exist = 'Y' THEN
4001: -- Raise Warinig here
4002: --fnd_message.set_name ('BEN', 'BEN_23014_TPA_MANY_LEA');
4003: --fnd_message.set_token ('TOKEN1',g_lea_number);
4004: --fnd_message.set_token ('TOKEN2',g_token_org_name);
4005: --More than one organizations have been set up with the LEA Number
4006: --The organization
3999:
4000: IF g_multi_lea_exist = 'Y' THEN
4001: -- Raise Warinig here
4002: --fnd_message.set_name ('BEN', 'BEN_23014_TPA_MANY_LEA');
4003: --fnd_message.set_token ('TOKEN1',g_lea_number);
4004: --fnd_message.set_token ('TOKEN2',g_token_org_name);
4005: --More than one organizations have been set up with the LEA Number
4006: --The organization
4007: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
4000: IF g_multi_lea_exist = 'Y' THEN
4001: -- Raise Warinig here
4002: --fnd_message.set_name ('BEN', 'BEN_23014_TPA_MANY_LEA');
4003: --fnd_message.set_token ('TOKEN1',g_lea_number);
4004: --fnd_message.set_token ('TOKEN2',g_token_org_name);
4005: --More than one organizations have been set up with the LEA Number
4006: --The organization
4007: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
4008: (p_assignment_id => p_assignment_id
4037: debug_enter(l_proc_name);
4038:
4039: IF g_warn_no_location = 'Y' THEN
4040: -- Raise Warning here
4041: --fnd_message.set_name ('PQP', 'PQP_230151_NO_LOC_MAP_ON_LEA');
4042: --fnd_message.set_token ('TOKEN1',g_lea_number);
4043: -- These is no Location defined for LEA
4044: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
4045: (p_assignment_id => p_assignment_id
4038:
4039: IF g_warn_no_location = 'Y' THEN
4040: -- Raise Warning here
4041: --fnd_message.set_name ('PQP', 'PQP_230151_NO_LOC_MAP_ON_LEA');
4042: --fnd_message.set_token ('TOKEN1',g_lea_number);
4043: -- These is no Location defined for LEA
4044: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
4045: (p_assignment_id => p_assignment_id
4046: ,p_error_text => 'BEN_94007_NO_LOC_MAP_ON_LEA'
4254: ELSE -- Else return = -1 from get table value function
4255:
4256: debug_exit(l_proc_name);
4257:
4258: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
4259: fnd_message.set_token ('TOKEN', l_error_msg);
4260: fnd_message.raise_error;
4261:
4262: END IF; -- End if of return <> -1 check from get table value func...
4255:
4256: debug_exit(l_proc_name);
4257:
4258: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
4259: fnd_message.set_token ('TOKEN', l_error_msg);
4260: fnd_message.raise_error;
4261:
4262: END IF; -- End if of return <> -1 check from get table value func...
4263: --
4256: debug_exit(l_proc_name);
4257:
4258: fnd_message.set_name ('PQP', 'PQP_230661_OSP_DUMMY_MSG');
4259: fnd_message.set_token ('TOKEN', l_error_msg);
4260: fnd_message.raise_error;
4261:
4262: END IF; -- End if of return <> -1 check from get table value func...
4263: --
4264: