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

Line 89: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

85: -- this procedure handle the validations except that they know what they are doing.
86:
87: -- validate p_organization_id
88: IF p_organization_id IS NULL THEN
89: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
90: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
91: FND_MSG_PUB.ADD;
92: RAISE EXCP_USER_DEFINED;
93: ELSE

Line 90: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);

86:
87: -- validate p_organization_id
88: IF p_organization_id IS NULL THEN
89: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
90: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
91: FND_MSG_PUB.ADD;
92: RAISE EXCP_USER_DEFINED;
93: ELSE
94: BEGIN

Line 100: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

96: from mtl_parameters
97: where organization_id = p_organization_id ;
98: EXCEPTION
99: WHEN NO_DATA_FOUND THEN
100: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
101: FND_MSG_PUB.ADD;
102: RAISE EXCP_USER_DEFINED;
103: WHEN OTHERS THEN
104: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 104: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

100: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
101: FND_MSG_PUB.ADD;
102: RAISE EXCP_USER_DEFINED;
103: WHEN OTHERS THEN
104: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
105: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
106: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
107: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
108: FND_MSG_PUB.ADD;

Line 105: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);

101: FND_MSG_PUB.ADD;
102: RAISE EXCP_USER_DEFINED;
103: WHEN OTHERS THEN
104: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
105: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
106: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
107: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
108: FND_MSG_PUB.ADD;
109: RAISE EXCP_USER_DEFINED;

Line 106: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

102: RAISE EXCP_USER_DEFINED;
103: WHEN OTHERS THEN
104: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
105: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
106: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
107: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
108: FND_MSG_PUB.ADD;
109: RAISE EXCP_USER_DEFINED;
110: END;

Line 107: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);

103: WHEN OTHERS THEN
104: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
105: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
106: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
107: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
108: FND_MSG_PUB.ADD;
109: RAISE EXCP_USER_DEFINED;
110: END;
111: END IF;

Line 116: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

112:
113:
114: -- validate p_move_order_line_id
115: IF p_move_order_line_id IS NULL THEN
116: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
117: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_move_order_line_id', FALSE);
118: FND_MSG_PUB.ADD;
119: RAISE EXCP_USER_DEFINED;
120: ELSE

Line 117: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_move_order_line_id', FALSE);

113:
114: -- validate p_move_order_line_id
115: IF p_move_order_line_id IS NULL THEN
116: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
117: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_move_order_line_id', FALSE);
118: FND_MSG_PUB.ADD;
119: RAISE EXCP_USER_DEFINED;
120: ELSE
121: -- validate whether the move_order_line_id exists in the mmtt table

Line 129: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');

125: WHERE move_order_line_id = p_move_order_line_id
126: AND organization_id = p_organization_id;
127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
129: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
130: fnd_message.set_token ('LINE_ID', to_char(p_move_order_line_id), FALSE);
131: fnd_msg_pub.add;
132: RAISE EXCP_USER_DEFINED;
133: WHEN TOO_MANY_ROWS THEN

Line 130: fnd_message.set_token ('LINE_ID', to_char(p_move_order_line_id), FALSE);

126: AND organization_id = p_organization_id;
127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
129: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
130: fnd_message.set_token ('LINE_ID', to_char(p_move_order_line_id), FALSE);
131: fnd_msg_pub.add;
132: RAISE EXCP_USER_DEFINED;
133: WHEN TOO_MANY_ROWS THEN
134: -- This is normal. One move order line id can map to many transaction_temp_id's.

Line 137: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

133: WHEN TOO_MANY_ROWS THEN
134: -- This is normal. One move order line id can map to many transaction_temp_id's.
135: NULL;
136: WHEN OTHERS THEN
137: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
138: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
139: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
140: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', FALSE);
141: FND_MSG_PUB.ADD;

Line 138: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);

134: -- This is normal. One move order line id can map to many transaction_temp_id's.
135: NULL;
136: WHEN OTHERS THEN
137: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
138: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
139: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
140: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', FALSE);
141: FND_MSG_PUB.ADD;
142: RAISE EXCP_USER_DEFINED;

Line 139: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

135: NULL;
136: WHEN OTHERS THEN
137: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
138: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
139: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
140: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', FALSE);
141: FND_MSG_PUB.ADD;
142: RAISE EXCP_USER_DEFINED;
143: END;

Line 140: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', FALSE);

136: WHEN OTHERS THEN
137: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
138: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
139: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
140: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', FALSE);
141: FND_MSG_PUB.ADD;
142: RAISE EXCP_USER_DEFINED;
143: END;
144:

Line 152: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');

148: from csp_moveorder_lines
149: where line_id = p_move_order_line_id;
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
153: fnd_message.set_token ('LINE_ID', to_char(p_move_order_line_id), FALSE);
154: fnd_msg_pub.add;
155: RAISE EXCP_USER_DEFINED;
156: WHEN OTHERS THEN

Line 153: fnd_message.set_token ('LINE_ID', to_char(p_move_order_line_id), FALSE);

149: where line_id = p_move_order_line_id;
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
153: fnd_message.set_token ('LINE_ID', to_char(p_move_order_line_id), FALSE);
154: fnd_msg_pub.add;
155: RAISE EXCP_USER_DEFINED;
156: WHEN OTHERS THEN
157: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 157: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

153: fnd_message.set_token ('LINE_ID', to_char(p_move_order_line_id), FALSE);
154: fnd_msg_pub.add;
155: RAISE EXCP_USER_DEFINED;
156: WHEN OTHERS THEN
157: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
158: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
159: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
160: fnd_message.set_token('TABLE', 'csp_moveorder_lines', FALSE);
161: FND_MSG_PUB.ADD;

Line 158: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);

154: fnd_msg_pub.add;
155: RAISE EXCP_USER_DEFINED;
156: WHEN OTHERS THEN
157: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
158: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
159: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
160: fnd_message.set_token('TABLE', 'csp_moveorder_lines', FALSE);
161: FND_MSG_PUB.ADD;
162: RAISE EXCP_USER_DEFINED;

Line 159: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

155: RAISE EXCP_USER_DEFINED;
156: WHEN OTHERS THEN
157: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
158: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
159: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
160: fnd_message.set_token('TABLE', 'csp_moveorder_lines', FALSE);
161: FND_MSG_PUB.ADD;
162: RAISE EXCP_USER_DEFINED;
163: END;

Line 160: fnd_message.set_token('TABLE', 'csp_moveorder_lines', FALSE);

156: WHEN OTHERS THEN
157: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
158: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
159: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
160: fnd_message.set_token('TABLE', 'csp_moveorder_lines', FALSE);
161: FND_MSG_PUB.ADD;
162: RAISE EXCP_USER_DEFINED;
163: END;
164: END IF;

Line 222: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

218: ,X_MSG_DATA => X_MSG_DATA
219: ,X_RETURN_STATUS => X_RETURN_STATUS);
220: WHEN OTHERS THEN
221: Rollback to Update_Order_Line_Sts_PUB;
222: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
223: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
224: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
225: fnd_msg_pub.add;
226: fnd_msg_pub.count_and_get

Line 223: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

219: ,X_RETURN_STATUS => X_RETURN_STATUS);
220: WHEN OTHERS THEN
221: Rollback to Update_Order_Line_Sts_PUB;
222: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
223: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
224: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
225: fnd_msg_pub.add;
226: fnd_msg_pub.count_and_get
227: ( p_count => x_msg_count

Line 224: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

220: WHEN OTHERS THEN
221: Rollback to Update_Order_Line_Sts_PUB;
222: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
223: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
224: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
225: fnd_msg_pub.add;
226: fnd_msg_pub.count_and_get
227: ( p_count => x_msg_count
228: , p_data => x_msg_data);

Line 700: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

696: -- this procedure handle the validations except that you know what you are doing.
697:
698: -- validate p_organization_id
699: IF p_organization_id IS NULL THEN
700: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
701: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
702: FND_MSG_PUB.ADD;
703: RAISE EXCP_USER_DEFINED;
704: ELSE

Line 701: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);

697:
698: -- validate p_organization_id
699: IF p_organization_id IS NULL THEN
700: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
701: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
702: FND_MSG_PUB.ADD;
703: RAISE EXCP_USER_DEFINED;
704: ELSE
705: BEGIN

Line 711: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

707: from mtl_parameters
708: where organization_id = p_organization_id;
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
712: FND_MSG_PUB.ADD;
713: RAISE EXCP_USER_DEFINED;
714: WHEN OTHERS THEN
715: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 715: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

711: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
712: FND_MSG_PUB.ADD;
713: RAISE EXCP_USER_DEFINED;
714: WHEN OTHERS THEN
715: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
716: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
717: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
718: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
719: FND_MSG_PUB.ADD;

Line 716: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);

712: FND_MSG_PUB.ADD;
713: RAISE EXCP_USER_DEFINED;
714: WHEN OTHERS THEN
715: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
716: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
717: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
718: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
719: FND_MSG_PUB.ADD;
720: RAISE EXCP_USER_DEFINED;

Line 717: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

713: RAISE EXCP_USER_DEFINED;
714: WHEN OTHERS THEN
715: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
716: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
717: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
718: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
719: FND_MSG_PUB.ADD;
720: RAISE EXCP_USER_DEFINED;
721: END;

Line 718: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);

714: WHEN OTHERS THEN
715: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
716: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
717: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
718: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
719: FND_MSG_PUB.ADD;
720: RAISE EXCP_USER_DEFINED;
721: END;
722: END IF;

Line 728: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

724: END IF; -- end full validations
725:
726: -- Validate the p_packlist_line_id
727: IF nvl(p_packlist_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
728: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
729: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', FALSE);
730: FND_MSG_PUB.ADD;
731: RAISE EXCP_USER_DEFINED;
732: ELSE

Line 729: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', FALSE);

725:
726: -- Validate the p_packlist_line_id
727: IF nvl(p_packlist_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
728: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
729: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', FALSE);
730: FND_MSG_PUB.ADD;
731: RAISE EXCP_USER_DEFINED;
732: ELSE
733: -- get the packlist_header_id

Line 741: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');

737: where organization_id = p_organization_id
738: and packlist_line_id = p_packlist_line_id;
739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
742: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
743: fnd_msg_pub.add;
744: RAISE EXCP_USER_DEFINED;
745: WHEN OTHERS THEN

Line 742: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);

738: and packlist_line_id = p_packlist_line_id;
739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
742: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
743: fnd_msg_pub.add;
744: RAISE EXCP_USER_DEFINED;
745: WHEN OTHERS THEN
746: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 746: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

742: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
743: fnd_msg_pub.add;
744: RAISE EXCP_USER_DEFINED;
745: WHEN OTHERS THEN
746: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
747: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
748: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
749: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
750: fnd_msg_pub.add;

Line 747: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);

743: fnd_msg_pub.add;
744: RAISE EXCP_USER_DEFINED;
745: WHEN OTHERS THEN
746: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
747: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
748: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
749: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
750: fnd_msg_pub.add;
751: RAISE EXCP_USER_DEFINED;

Line 748: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

744: RAISE EXCP_USER_DEFINED;
745: WHEN OTHERS THEN
746: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
747: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
748: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
749: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
750: fnd_msg_pub.add;
751: RAISE EXCP_USER_DEFINED;
752: END;

Line 749: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);

745: WHEN OTHERS THEN
746: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
747: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
748: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
749: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
750: fnd_msg_pub.add;
751: RAISE EXCP_USER_DEFINED;
752: END;
753:

Line 761: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

757: FETCH l_Get_Packlist_Status_Csr INTO l_packlist_header_status;
758: CLOSE l_Get_Packlist_Status_Csr;
759:
760: IF l_packlist_header_status IS NULL THEN
761: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
762: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_status', FALSE);
763: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
764: fnd_message.set_token('TABLE', 'CSP_PACKLIST_HEADERS', FALSE);
765: fnd_msg_pub.add;

Line 762: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_status', FALSE);

758: CLOSE l_Get_Packlist_Status_Csr;
759:
760: IF l_packlist_header_status IS NULL THEN
761: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
762: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_status', FALSE);
763: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
764: fnd_message.set_token('TABLE', 'CSP_PACKLIST_HEADERS', FALSE);
765: fnd_msg_pub.add;
766: RAISE EXCP_USER_DEFINED;

Line 763: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

759:
760: IF l_packlist_header_status IS NULL THEN
761: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
762: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_status', FALSE);
763: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
764: fnd_message.set_token('TABLE', 'CSP_PACKLIST_HEADERS', FALSE);
765: fnd_msg_pub.add;
766: RAISE EXCP_USER_DEFINED;
767: END IF;

Line 764: fnd_message.set_token('TABLE', 'CSP_PACKLIST_HEADERS', FALSE);

760: IF l_packlist_header_status IS NULL THEN
761: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
762: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_status', FALSE);
763: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
764: fnd_message.set_token('TABLE', 'CSP_PACKLIST_HEADERS', FALSE);
765: fnd_msg_pub.add;
766: RAISE EXCP_USER_DEFINED;
767: END IF;
768:

Line 770: fnd_message.set_name('CSP', 'CSP_INVALID_PACKLIST_TXN');

766: RAISE EXCP_USER_DEFINED;
767: END IF;
768:
769: IF l_packlist_header_status = '3' THEN
770: fnd_message.set_name('CSP', 'CSP_INVALID_PACKLIST_TXN');
771: fnd_message.set_token('PACKLIST_HEADER_ID', to_char(l_packlist_header_id), FALSE);
772: fnd_msg_pub.add;
773: RAISE EXCP_USER_DEFINED;
774: END IF;

Line 771: fnd_message.set_token('PACKLIST_HEADER_ID', to_char(l_packlist_header_id), FALSE);

767: END IF;
768:
769: IF l_packlist_header_status = '3' THEN
770: fnd_message.set_name('CSP', 'CSP_INVALID_PACKLIST_TXN');
771: fnd_message.set_token('PACKLIST_HEADER_ID', to_char(l_packlist_header_id), FALSE);
772: fnd_msg_pub.add;
773: RAISE EXCP_USER_DEFINED;
774: END IF;
775:

Line 784: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');

780: where packlist_line_id = p_packlist_line_id
781: and organization_id = p_organization_id;
782: EXCEPTION
783: WHEN NO_DATA_FOUND THEN
784: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
785: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
786: fnd_msg_pub.add;
787: RAISE EXCP_USER_DEFINED;
788: WHEN OTHERS THEN

Line 785: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);

781: and organization_id = p_organization_id;
782: EXCEPTION
783: WHEN NO_DATA_FOUND THEN
784: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
785: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
786: fnd_msg_pub.add;
787: RAISE EXCP_USER_DEFINED;
788: WHEN OTHERS THEN
789: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 789: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

785: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
786: fnd_msg_pub.add;
787: RAISE EXCP_USER_DEFINED;
788: WHEN OTHERS THEN
789: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
790: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
791: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
792: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
793: fnd_msg_pub.add;

Line 790: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);

786: fnd_msg_pub.add;
787: RAISE EXCP_USER_DEFINED;
788: WHEN OTHERS THEN
789: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
790: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
791: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
792: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
793: fnd_msg_pub.add;
794: RAISE EXCP_USER_DEFINED;

Line 791: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

787: RAISE EXCP_USER_DEFINED;
788: WHEN OTHERS THEN
789: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
790: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
791: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
792: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
793: fnd_msg_pub.add;
794: RAISE EXCP_USER_DEFINED;
795: END;

Line 792: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);

788: WHEN OTHERS THEN
789: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
790: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
791: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
792: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
793: fnd_msg_pub.add;
794: RAISE EXCP_USER_DEFINED;
795: END;
796: END IF;

Line 847: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');

843: OPEN l_ml_records(p_transaction_temp_id);
844: FETCH l_ml_records INTO l_csp_mtltxn_rec;
845:
846: IF l_ml_records%NOTFOUND AND (p_receiving_option IN (0, 1)) THEN
847: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
848: fnd_msg_pub.add;
849: CLOSE l_ml_records;
850: RAISE EXCP_USER_DEFINED;
851: END IF;

Line 861: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');

857: OPEN l_Get_Moveorder_Headers(l_move_order_line_id);
858: FETCH l_Get_Moveorder_Headers INTO l_header_id;
859: IF l_Get_Moveorder_Headers%NOTFOUND THEN
860: CLOSE l_Get_Moveorder_Headers;
861: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
862: fnd_message.set_token ('LINE_ID', to_char(l_move_order_line_id), FALSE);
863: fnd_msg_pub.add;
864: RAISE EXCP_USER_DEFINED;
865: END IF;

Line 862: fnd_message.set_token ('LINE_ID', to_char(l_move_order_line_id), FALSE);

858: FETCH l_Get_Moveorder_Headers INTO l_header_id;
859: IF l_Get_Moveorder_Headers%NOTFOUND THEN
860: CLOSE l_Get_Moveorder_Headers;
861: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
862: fnd_message.set_token ('LINE_ID', to_char(l_move_order_line_id), FALSE);
863: fnd_msg_pub.add;
864: RAISE EXCP_USER_DEFINED;
865: END IF;
866: CLOSE l_Get_Moveorder_Headers;

Line 887: fnd_message.set_name ('CSP', 'CSP_INVALID_QUANTITY_RECEIVED');

883: RAISE EXCP_USER_DEFINED;
884: END IF;
885: GOTO END_JOB;
886: ELSE
887: fnd_message.set_name ('CSP', 'CSP_INVALID_QUANTITY_RECEIVED');
888: fnd_msg_pub.add;
889: RAISE EXCP_USER_DEFINED;
890: END IF; */
891: fnd_message.set_name ('CSP', 'CSP_INVALID_QUANTITY_RECEIVED');

Line 891: fnd_message.set_name ('CSP', 'CSP_INVALID_QUANTITY_RECEIVED');

887: fnd_message.set_name ('CSP', 'CSP_INVALID_QUANTITY_RECEIVED');
888: fnd_msg_pub.add;
889: RAISE EXCP_USER_DEFINED;
890: END IF; */
891: fnd_message.set_name ('CSP', 'CSP_INVALID_QUANTITY_RECEIVED');
892: fnd_msg_pub.add;
893: RAISE EXCP_USER_DEFINED;
894: ELSE
895: OPEN l_Get_Shipped_Received_Qty;

Line 898: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');

894: ELSE
895: OPEN l_Get_Shipped_Received_Qty;
896: FETCH l_Get_Shipped_Received_Qty INTO l_quantity_shipped, l_quantity_received;
897: IF l_Get_Shipped_Received_Qty%NOTFOUND THEN
898: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
899: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
900: fnd_msg_pub.add;
901: CLOSE l_Get_Shipped_Received_Qty;
902: RAISE EXCP_USER_DEFINED;

Line 899: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);

895: OPEN l_Get_Shipped_Received_Qty;
896: FETCH l_Get_Shipped_Received_Qty INTO l_quantity_shipped, l_quantity_received;
897: IF l_Get_Shipped_Received_Qty%NOTFOUND THEN
898: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
899: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
900: fnd_msg_pub.add;
901: CLOSE l_Get_Shipped_Received_Qty;
902: RAISE EXCP_USER_DEFINED;
903: END IF;

Line 920: fnd_message.set_name ('INV', 'INV-NO SUBINVENTORY RECORD');

916: AND organization_id = p_organization_id
917: AND nvl(disable_date, sysdate+1) > sysdate;
918: EXCEPTION
919: WHEN NO_DATA_FOUND THEN
920: fnd_message.set_name ('INV', 'INV-NO SUBINVENTORY RECORD');
921: fnd_message.set_token ('SUBINV', p_to_subinventory_code, FALSE);
922: fnd_message.set_token ('ORG', to_char(p_organization_id), FALSE);
923: fnd_msg_pub.add;
924: RAISE EXCP_USER_DEFINED;

Line 921: fnd_message.set_token ('SUBINV', p_to_subinventory_code, FALSE);

917: AND nvl(disable_date, sysdate+1) > sysdate;
918: EXCEPTION
919: WHEN NO_DATA_FOUND THEN
920: fnd_message.set_name ('INV', 'INV-NO SUBINVENTORY RECORD');
921: fnd_message.set_token ('SUBINV', p_to_subinventory_code, FALSE);
922: fnd_message.set_token ('ORG', to_char(p_organization_id), FALSE);
923: fnd_msg_pub.add;
924: RAISE EXCP_USER_DEFINED;
925: WHEN OTHERS THEN

Line 922: fnd_message.set_token ('ORG', to_char(p_organization_id), FALSE);

918: EXCEPTION
919: WHEN NO_DATA_FOUND THEN
920: fnd_message.set_name ('INV', 'INV-NO SUBINVENTORY RECORD');
921: fnd_message.set_token ('SUBINV', p_to_subinventory_code, FALSE);
922: fnd_message.set_token ('ORG', to_char(p_organization_id), FALSE);
923: fnd_msg_pub.add;
924: RAISE EXCP_USER_DEFINED;
925: WHEN OTHERS THEN
926: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 926: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

922: fnd_message.set_token ('ORG', to_char(p_organization_id), FALSE);
923: fnd_msg_pub.add;
924: RAISE EXCP_USER_DEFINED;
925: WHEN OTHERS THEN
926: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
927: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
928: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
929: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
930: fnd_msg_pub.add;

Line 927: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);

923: fnd_msg_pub.add;
924: RAISE EXCP_USER_DEFINED;
925: WHEN OTHERS THEN
926: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
927: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
928: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
929: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
930: fnd_msg_pub.add;
931: RAISE EXCP_USER_DEFINED;

Line 928: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

924: RAISE EXCP_USER_DEFINED;
925: WHEN OTHERS THEN
926: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
927: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
928: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
929: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
930: fnd_msg_pub.add;
931: RAISE EXCP_USER_DEFINED;
932: END;

Line 929: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);

925: WHEN OTHERS THEN
926: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
927: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
928: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
929: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
930: fnd_msg_pub.add;
931: RAISE EXCP_USER_DEFINED;
932: END;
933: END IF;

Line 944: fnd_message.set_name('INV', 'INV_LOCATOR_NOT_AVAILABLE');

940: AND subinventory_code = p_to_subinventory_code
941: AND nvl(disable_date, sysdate+1) > sysdate;
942: EXCEPTION
943: WHEN NO_DATA_FOUND THEN
944: fnd_message.set_name('INV', 'INV_LOCATOR_NOT_AVAILABLE');
945: fnd_msg_pub.add;
946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

944: fnd_message.set_name('INV', 'INV_LOCATOR_NOT_AVAILABLE');
945: fnd_msg_pub.add;
946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_locator_id', FALSE);
950: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
951: fnd_message.set_token('TABLE', 'mtl_item_locations', FALSE);
952: fnd_msg_pub.ADD;

Line 949: fnd_message.set_token('ERR_FIELD', 'p_locator_id', FALSE);

945: fnd_msg_pub.add;
946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_locator_id', FALSE);
950: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
951: fnd_message.set_token('TABLE', 'mtl_item_locations', FALSE);
952: fnd_msg_pub.ADD;
953: RAISE EXCP_USER_DEFINED;

Line 950: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_locator_id', FALSE);
950: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
951: fnd_message.set_token('TABLE', 'mtl_item_locations', FALSE);
952: fnd_msg_pub.ADD;
953: RAISE EXCP_USER_DEFINED;
954: END;

Line 951: fnd_message.set_token('TABLE', 'mtl_item_locations', FALSE);

947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_locator_id', FALSE);
950: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
951: fnd_message.set_token('TABLE', 'mtl_item_locations', FALSE);
952: fnd_msg_pub.ADD;
953: RAISE EXCP_USER_DEFINED;
954: END;
955: END IF;

Line 962: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');

958: -- It is now ready for the transactions
959: OPEN l_ml_records(p_transaction_temp_id);
960: FETCH l_ml_records INTO l_csp_mtltxn_rec;
961: IF l_ml_records%NOTFOUND AND (p_receiving_option IN (0, 1)) THEN
962: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
963: fnd_msg_pub.add;
964: CLOSE l_ml_records;
965: RAISE EXCP_USER_DEFINED;
966: ELSIF l_ml_records%NOTFOUND AND (p_receiving_option IN (2, 3)) THEN

Line 1043: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_LOT_MISSED');

1039:
1040: -- Now we have to check whether we need to insert into the mtlt and msnt tables.
1041: IF nvl(l_csp_mtltxn_rec.item_lot_control_code, 1) <> 1 THEN
1042: IF nvl(p_lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1043: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_LOT_MISSED');
1044: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1045: fnd_msg_pub.add;
1046: RAISE EXCP_USER_DEFINED;
1047: END IF;

Line 1044: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1040: -- Now we have to check whether we need to insert into the mtlt and msnt tables.
1041: IF nvl(l_csp_mtltxn_rec.item_lot_control_code, 1) <> 1 THEN
1042: IF nvl(p_lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1043: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_LOT_MISSED');
1044: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1045: fnd_msg_pub.add;
1046: RAISE EXCP_USER_DEFINED;
1047: END IF;
1048:

Line 1074: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

1070: ,p_mtlt_tbl_size => 1
1071: );
1072:
1073: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1074: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1075: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1076: fnd_message.set_token ('TABLE', 'MTL_TRANSACTION_LOTS_TEMP', FALSE);
1077: fnd_msg_pub.add;
1078: RAISE EXCP_USER_DEFINED;

Line 1075: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

1071: );
1072:
1073: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1074: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1075: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1076: fnd_message.set_token ('TABLE', 'MTL_TRANSACTION_LOTS_TEMP', FALSE);
1077: fnd_msg_pub.add;
1078: RAISE EXCP_USER_DEFINED;
1079: END IF;

Line 1076: fnd_message.set_token ('TABLE', 'MTL_TRANSACTION_LOTS_TEMP', FALSE);

1072:
1073: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1074: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1075: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1076: fnd_message.set_token ('TABLE', 'MTL_TRANSACTION_LOTS_TEMP', FALSE);
1077: fnd_msg_pub.add;
1078: RAISE EXCP_USER_DEFINED;
1079: END IF;
1080:

Line 1085: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_SERIAL_MISSED');

1081: -- If the item is also under serial control, we need to insert into the msnt.
1082: IF nvl(l_csp_mtltxn_rec.item_serial_control_code, 1) in (2,5) THEN
1083:
1084: IF nvl(p_serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1085: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_SERIAL_MISSED');
1086: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1087: fnd_msg_pub.add;
1088: RAISE EXCP_USER_DEFINED;
1089: ELSE

Line 1086: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1082: IF nvl(l_csp_mtltxn_rec.item_serial_control_code, 1) in (2,5) THEN
1083:
1084: IF nvl(p_serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1085: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_SERIAL_MISSED');
1086: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1087: fnd_msg_pub.add;
1088: RAISE EXCP_USER_DEFINED;
1089: ELSE
1090: IF p_quantity_received <> 1 THEN

Line 1091: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');

1087: fnd_msg_pub.add;
1088: RAISE EXCP_USER_DEFINED;
1089: ELSE
1090: IF p_quantity_received <> 1 THEN
1091: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');
1092: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1093: fnd_msg_pub.add;
1094: RAISE EXCP_USER_DEFINED;
1095: END IF;

Line 1092: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1088: RAISE EXCP_USER_DEFINED;
1089: ELSE
1090: IF p_quantity_received <> 1 THEN
1091: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');
1092: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1093: fnd_msg_pub.add;
1094: RAISE EXCP_USER_DEFINED;
1095: END IF;
1096: END IF;

Line 1111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

1107: where transaction_temp_id = l_mtlt_tbl(l_index).transaction_temp_id
1108: and lot_number = l_mtlt_tbl(l_index).lot_number;
1109:
1110: If (SQL%NOTFOUND) then
1111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1112: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1113: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', TRUE);
1114: fnd_msg_pub.add;
1115: RAISE EXCP_USER_DEFINED;

Line 1112: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

1108: and lot_number = l_mtlt_tbl(l_index).lot_number;
1109:
1110: If (SQL%NOTFOUND) then
1111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1112: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1113: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', TRUE);
1114: fnd_msg_pub.add;
1115: RAISE EXCP_USER_DEFINED;
1116: End If;

Line 1113: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', TRUE);

1109:
1110: If (SQL%NOTFOUND) then
1111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1112: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1113: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', TRUE);
1114: fnd_msg_pub.add;
1115: RAISE EXCP_USER_DEFINED;
1116: End If;
1117:

Line 1136: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

1132: ,p_msnt_tbl_size => 1
1133: );
1134:
1135: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1136: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1137: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1138: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);
1139: fnd_msg_pub.add;
1140: RAISE EXCP_USER_DEFINED;

Line 1137: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

1133: );
1134:
1135: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1136: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1137: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1138: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);
1139: fnd_msg_pub.add;
1140: RAISE EXCP_USER_DEFINED;
1141: END IF;

Line 1138: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);

1134:
1135: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1136: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1137: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1138: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);
1139: fnd_msg_pub.add;
1140: RAISE EXCP_USER_DEFINED;
1141: END IF;
1142: END IF;

Line 1147: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_SERIAL_MISSED');

1143: ELSIF nvl(l_csp_mtltxn_rec.item_lot_control_code, 1) = 1 AND
1144: nvl(l_csp_mtltxn_rec.item_serial_control_code, 1) in (2, 5) THEN
1145: -- Serial control only
1146: IF nvl(p_serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1147: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_SERIAL_MISSED');
1148: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1149: fnd_msg_pub.add;
1150: RAISE EXCP_USER_DEFINED;
1151: ELSE

Line 1148: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1144: nvl(l_csp_mtltxn_rec.item_serial_control_code, 1) in (2, 5) THEN
1145: -- Serial control only
1146: IF nvl(p_serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1147: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_SERIAL_MISSED');
1148: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1149: fnd_msg_pub.add;
1150: RAISE EXCP_USER_DEFINED;
1151: ELSE
1152: IF p_quantity_received <> 1 THEN

Line 1153: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');

1149: fnd_msg_pub.add;
1150: RAISE EXCP_USER_DEFINED;
1151: ELSE
1152: IF p_quantity_received <> 1 THEN
1153: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');
1154: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1155: fnd_msg_pub.add;
1156: RAISE EXCP_USER_DEFINED;
1157: END IF;

Line 1154: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1150: RAISE EXCP_USER_DEFINED;
1151: ELSE
1152: IF p_quantity_received <> 1 THEN
1153: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');
1154: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1155: fnd_msg_pub.add;
1156: RAISE EXCP_USER_DEFINED;
1157: END IF;
1158: END IF;

Line 1176: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

1172: ,p_msnt_tbl_size => 1
1173: );
1174:
1175: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1176: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1177: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1178: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);
1179: fnd_msg_pub.add;
1180: RAISE EXCP_USER_DEFINED;

Line 1177: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

1173: );
1174:
1175: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1176: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1177: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1178: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);
1179: fnd_msg_pub.add;
1180: RAISE EXCP_USER_DEFINED;
1181: END IF;

Line 1178: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);

1174:
1175: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1176: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1177: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1178: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);
1179: fnd_msg_pub.add;
1180: RAISE EXCP_USER_DEFINED;
1181: END IF;
1182: ELSE NULL; -- already taken care.

Line 1210: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');

1206: OPEN l_Get_Moveorder_Headers(l_move_order_line_id);
1207: FETCH l_Get_Moveorder_Headers INTO l_header_id;
1208: IF l_Get_Moveorder_Headers%NOTFOUND THEN
1209: CLOSE l_Get_Moveorder_Headers;
1210: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
1211: fnd_message.set_token ('LINE_ID', to_char(l_move_order_line_id), FALSE);
1212: fnd_msg_pub.add;
1213: RAISE EXCP_USER_DEFINED;
1214: END IF;

Line 1211: fnd_message.set_token ('LINE_ID', to_char(l_move_order_line_id), FALSE);

1207: FETCH l_Get_Moveorder_Headers INTO l_header_id;
1208: IF l_Get_Moveorder_Headers%NOTFOUND THEN
1209: CLOSE l_Get_Moveorder_Headers;
1210: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
1211: fnd_message.set_token ('LINE_ID', to_char(l_move_order_line_id), FALSE);
1212: fnd_msg_pub.add;
1213: RAISE EXCP_USER_DEFINED;
1214: END IF;
1215: CLOSE l_Get_Moveorder_Headers;

Line 1242: fnd_message.set_name ('CSP', 'CSP_ITEM_SUB_VIOLATION');

1238: and inventory_item_id = l_inventory_item_id
1239: and secondary_inventory = p_to_subinventory_code;
1240: EXCEPTION
1241: WHEN NO_DATA_FOUND THEN
1242: fnd_message.set_name ('CSP', 'CSP_ITEM_SUB_VIOLATION');
1243: fnd_message.set_token ('SUB', p_to_subinventory_code, FALSE);
1244: fnd_msg_pub.add;
1245: RAISE EXCP_USER_DEFINED;
1246: WHEN OTHERS THEN

Line 1243: fnd_message.set_token ('SUB', p_to_subinventory_code, FALSE);

1239: and secondary_inventory = p_to_subinventory_code;
1240: EXCEPTION
1241: WHEN NO_DATA_FOUND THEN
1242: fnd_message.set_name ('CSP', 'CSP_ITEM_SUB_VIOLATION');
1243: fnd_message.set_token ('SUB', p_to_subinventory_code, FALSE);
1244: fnd_msg_pub.add;
1245: RAISE EXCP_USER_DEFINED;
1246: WHEN OTHERS THEN
1247: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 1247: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

1243: fnd_message.set_token ('SUB', p_to_subinventory_code, FALSE);
1244: fnd_msg_pub.add;
1245: RAISE EXCP_USER_DEFINED;
1246: WHEN OTHERS THEN
1247: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1248: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
1249: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1250: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', FALSE);
1251: fnd_msg_pub.ADD;

Line 1248: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);

1244: fnd_msg_pub.add;
1245: RAISE EXCP_USER_DEFINED;
1246: WHEN OTHERS THEN
1247: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1248: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
1249: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1250: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', FALSE);
1251: fnd_msg_pub.ADD;
1252: RAISE EXCP_USER_DEFINED;

Line 1249: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

1245: RAISE EXCP_USER_DEFINED;
1246: WHEN OTHERS THEN
1247: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1248: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
1249: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1250: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', FALSE);
1251: fnd_msg_pub.ADD;
1252: RAISE EXCP_USER_DEFINED;
1253: END;

Line 1250: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', FALSE);

1246: WHEN OTHERS THEN
1247: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1248: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
1249: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1250: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', FALSE);
1251: fnd_msg_pub.ADD;
1252: RAISE EXCP_USER_DEFINED;
1253: END;
1254: END IF;

Line 1257: fnd_message.set_name ('INV', 'INV-NO ITEM RECORD');

1253: END;
1254: END IF;
1255: EXCEPTION
1256: WHEN NO_DATA_FOUND THEN
1257: fnd_message.set_name ('INV', 'INV-NO ITEM RECORD');
1258: fnd_msg_pub.add;
1259: RAISE EXCP_USER_DEFINED;
1260: WHEN OTHERS THEN
1261: fnd_message.set_name('CSP', 'CSP_ITEM_UNEXPECTED_ERRORS');

Line 1261: fnd_message.set_name('CSP', 'CSP_ITEM_UNEXPECTED_ERRORS');

1257: fnd_message.set_name ('INV', 'INV-NO ITEM RECORD');
1258: fnd_msg_pub.add;
1259: RAISE EXCP_USER_DEFINED;
1260: WHEN OTHERS THEN
1261: fnd_message.set_name('CSP', 'CSP_ITEM_UNEXPECTED_ERRORS');
1262: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1263: fnd_msg_pub.ADD;
1264: RAISE EXCP_USER_DEFINED;
1265: END;

Line 1262: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

1258: fnd_msg_pub.add;
1259: RAISE EXCP_USER_DEFINED;
1260: WHEN OTHERS THEN
1261: fnd_message.set_name('CSP', 'CSP_ITEM_UNEXPECTED_ERRORS');
1262: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1263: fnd_msg_pub.ADD;
1264: RAISE EXCP_USER_DEFINED;
1265: END;
1266: END IF;

Line 1288: fnd_message.set_name ('INV', 'INV_LOCATOR_NOT_AVAILABLE');

1284: AND locator_id = p_to_locator_id
1285: AND subinventory_code = p_to_subinventory_code;
1286: EXCEPTION
1287: WHEN NO_DATA_FOUND THEN
1288: fnd_message.set_name ('INV', 'INV_LOCATOR_NOT_AVAILABLE');
1289: fnd_msg_pub.add;
1290: RAISE EXCP_USER_DEFINED;
1291: WHEN OTHERS THEN
1292: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 1292: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

1288: fnd_message.set_name ('INV', 'INV_LOCATOR_NOT_AVAILABLE');
1289: fnd_msg_pub.add;
1290: RAISE EXCP_USER_DEFINED;
1291: WHEN OTHERS THEN
1292: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1293: fnd_message.set_token('ERR_FIELD', 'p_to_locator_id', FALSE);
1294: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1295: fnd_message.set_token('TABLE', 'mtl_item_loc_defaults', FALSE);
1296: fnd_msg_pub.ADD;

Line 1293: fnd_message.set_token('ERR_FIELD', 'p_to_locator_id', FALSE);

1289: fnd_msg_pub.add;
1290: RAISE EXCP_USER_DEFINED;
1291: WHEN OTHERS THEN
1292: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1293: fnd_message.set_token('ERR_FIELD', 'p_to_locator_id', FALSE);
1294: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1295: fnd_message.set_token('TABLE', 'mtl_item_loc_defaults', FALSE);
1296: fnd_msg_pub.ADD;
1297: RAISE EXCP_USER_DEFINED;

Line 1294: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

1290: RAISE EXCP_USER_DEFINED;
1291: WHEN OTHERS THEN
1292: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1293: fnd_message.set_token('ERR_FIELD', 'p_to_locator_id', FALSE);
1294: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1295: fnd_message.set_token('TABLE', 'mtl_item_loc_defaults', FALSE);
1296: fnd_msg_pub.ADD;
1297: RAISE EXCP_USER_DEFINED;
1298: END;

Line 1295: fnd_message.set_token('TABLE', 'mtl_item_loc_defaults', FALSE);

1291: WHEN OTHERS THEN
1292: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1293: fnd_message.set_token('ERR_FIELD', 'p_to_locator_id', FALSE);
1294: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1295: fnd_message.set_token('TABLE', 'mtl_item_loc_defaults', FALSE);
1296: fnd_msg_pub.ADD;
1297: RAISE EXCP_USER_DEFINED;
1298: END;
1299: END IF;

Line 1309: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');

1305: IF p_quantity_received > l_csp_mtltxn_rec.transaction_quantity THEN
1306:
1307: -- In this case, the user has to specify a p_receiving_option either 2 or 3.
1308: IF p_receiving_option NOT IN (2, 3) THEN
1309: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1310: fnd_msg_pub.add;
1311: RAISE EXCP_USER_DEFINED;
1312: End If;
1313:

Line 1321: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');

1317: Open l_Get_Org_Qty_Csr;
1318: Fetch l_Get_Org_Qty_Csr Into l_org_received_qty;
1319: Close l_Get_Org_Qty_Csr;
1320: If l_org_received_qty < 0 Then
1321: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1322: fnd_msg_pub.add;
1323: RAISE EXCP_USER_DEFINED;
1324: End If;
1325:

Line 1426: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');

1422: END IF;
1423: l_temp_id_to_be_processed := l_csp_mtltxn_rec.transaction_temp_id;
1424:
1425: Else -- this is an error.
1426: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1427: fnd_msg_pub.add;
1428: RAISE EXCP_USER_DEFINED;
1429: End If;
1430:

Line 1484: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');

1480: IF nvl(l_csp_mtltxn_over_rec.item_serial_control_code, 1) in (2,5) THEN
1481: -- This case should not happen because we always transact one serial number at time.
1482: -- Eventually, the transaction_qunatity is either 1 or the whole transaction temp record
1483: -- was deleted when the last expected serial number is transacted.
1484: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');
1485: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);
1486: fnd_msg_pub.add;
1487: RAISE EXCP_USER_DEFINED;
1488: END IF;

Line 1485: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);

1481: -- This case should not happen because we always transact one serial number at time.
1482: -- Eventually, the transaction_qunatity is either 1 or the whole transaction temp record
1483: -- was deleted when the last expected serial number is transacted.
1484: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');
1485: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);
1486: fnd_msg_pub.add;
1487: RAISE EXCP_USER_DEFINED;
1488: END IF;
1489: IF nvl(l_csp_mtltxn_over_rec.item_lot_control_code, 1) <> 1 THEN

Line 1491: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_LOT_MISSED');

1487: RAISE EXCP_USER_DEFINED;
1488: END IF;
1489: IF nvl(l_csp_mtltxn_over_rec.item_lot_control_code, 1) <> 1 THEN
1490: IF nvl(p_lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1491: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_LOT_MISSED');
1492: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);
1493: fnd_msg_pub.add;
1494: RAISE EXCP_USER_DEFINED;
1495: END IF;

Line 1492: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);

1488: END IF;
1489: IF nvl(l_csp_mtltxn_over_rec.item_lot_control_code, 1) <> 1 THEN
1490: IF nvl(p_lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1491: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_LOT_MISSED');
1492: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);
1493: fnd_msg_pub.add;
1494: RAISE EXCP_USER_DEFINED;
1495: END IF;
1496:

Line 1509: fnd_message.set_name ('CSP', 'CSP_NO_LOT_TXN_RECORD');

1505: BEGIN
1506: OPEN l_Get_Mtlt;
1507: FETCH l_Get_Mtlt INTO l_mtlt_tbl(l_index);
1508: IF l_Get_Mtlt%rowcount = 0 THEN
1509: fnd_message.set_name ('CSP', 'CSP_NO_LOT_TXN_RECORD');
1510: fnd_msg_pub.add;
1511: CLOSE l_Get_Mtlt;
1512: RAISE EXCP_USER_DEFINED;
1513: END IF;

Line 1528: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

1524: ,p_mtlt_tbl_size => 1
1525: );
1526:
1527: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1528: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1529: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1530: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
1531: fnd_msg_pub.add;
1532: RAISE EXCP_USER_DEFINED;

Line 1529: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

1525: );
1526:
1527: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1528: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1529: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1530: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
1531: fnd_msg_pub.add;
1532: RAISE EXCP_USER_DEFINED;
1533: END IF;

Line 1530: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);

1526:
1527: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1528: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1529: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1530: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
1531: fnd_msg_pub.add;
1532: RAISE EXCP_USER_DEFINED;
1533: END IF;
1534:

Line 1537: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_LOT_QTY');

1533: END IF;
1534:
1535: EXCEPTION
1536: WHEN NO_DATA_FOUND THEN
1537: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_LOT_QTY');
1538: fnd_message.set_token ('LOT_NUMBER', p_lot_number, FALSE);
1539: fnd_msg_pub.add;
1540: RAISE EXCP_USER_DEFINED;
1541: WHEN OTHERS THEN

Line 1538: fnd_message.set_token ('LOT_NUMBER', p_lot_number, FALSE);

1534:
1535: EXCEPTION
1536: WHEN NO_DATA_FOUND THEN
1537: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_LOT_QTY');
1538: fnd_message.set_token ('LOT_NUMBER', p_lot_number, FALSE);
1539: fnd_msg_pub.add;
1540: RAISE EXCP_USER_DEFINED;
1541: WHEN OTHERS THEN
1542: RAISE EXCP_USER_DEFINED;

Line 1572: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1568: where line_id = l_move_order_line_id;
1569:
1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1573: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1574: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1575: fnd_msg_pub.add;
1576: RAISE EXCP_USER_DEFINED;

Line 1573: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

1569:
1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1573: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1574: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1575: fnd_msg_pub.add;
1576: RAISE EXCP_USER_DEFINED;
1577: END;

Line 1574: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1573: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1574: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1575: fnd_msg_pub.add;
1576: RAISE EXCP_USER_DEFINED;
1577: END;
1578:

Line 1637: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1633: where line_id = l_move_order_line_id;
1634:
1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1638: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1639: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1640: fnd_msg_pub.add;
1641: RAISE EXCP_USER_DEFINED;

Line 1638: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

1634:
1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1638: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1639: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1640: fnd_msg_pub.add;
1641: RAISE EXCP_USER_DEFINED;
1642: END;

Line 1639: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1638: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1639: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1640: fnd_msg_pub.add;
1641: RAISE EXCP_USER_DEFINED;
1642: END;
1643:

Line 1677: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');

1673: -- 2. update the transaction_quantity of the existing one to the remaining quantity.
1674: l_recv_less_than_txn := fnd_api.g_true;
1675:
1676: IF p_receiving_option NOT IN (0, 1) THEN
1677: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1678: fnd_msg_pub.add;
1679: RAISE EXCP_USER_DEFINED;
1680: END IF;
1681: l_csp_mtltxn_bak_rec := l_csp_mtltxn_rec;

Line 1830: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_LOT_PACKLIST');

1826: END IF;
1827: END LOOP;
1828: IF NOT fnd_api.to_boolean(l_serial_lot_flag) AND
1829: l_Get_Packlist_SL%rowcount <> 0 THEN
1830: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_LOT_PACKLIST');
1831: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1832: fnd_msg_pub.add;
1833: CLOSE l_Get_Packlist_SL;
1834: RAISE EXCP_USER_DEFINED;

Line 1831: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

1827: END LOOP;
1828: IF NOT fnd_api.to_boolean(l_serial_lot_flag) AND
1829: l_Get_Packlist_SL%rowcount <> 0 THEN
1830: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_LOT_PACKLIST');
1831: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1832: fnd_msg_pub.add;
1833: CLOSE l_Get_Packlist_SL;
1834: RAISE EXCP_USER_DEFINED;
1835: END IF;

Line 1850: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');

1846: Fetch l_Get_Org_Qty_Csr Into l_org_received_qty;
1847: Close l_Get_Org_Qty_Csr;
1848:
1849: If l_org_received_qty < 0 Then
1850: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1851: fnd_msg_pub.add;
1852: RAISE EXCP_USER_DEFINED;
1853: End If;
1854:

Line 1955: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_LOT_PACKLIST');

1951: END IF;
1952: END LOOP;
1953: IF NOT fnd_api.to_boolean(l_serial_lot_flag) AND
1954: l_Get_Packlist_SL%rowcount <> 0 THEN
1955: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_LOT_PACKLIST');
1956: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1957: fnd_msg_pub.add;
1958: CLOSE l_Get_Packlist_SL;
1959: RAISE EXCP_USER_DEFINED;

Line 1956: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

1952: END LOOP;
1953: IF NOT fnd_api.to_boolean(l_serial_lot_flag) AND
1954: l_Get_Packlist_SL%rowcount <> 0 THEN
1955: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_LOT_PACKLIST');
1956: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1957: fnd_msg_pub.add;
1958: CLOSE l_Get_Packlist_SL;
1959: RAISE EXCP_USER_DEFINED;
1960: END IF;

Line 2084: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');

2080: -- Update the date_received and the packlist_status in the packlist. klou 5/17/00.
2081: Open l_Get_Packlist_Csr(l_packlist_header_id);
2082: Fetch l_Get_Packlist_Csr Into l_packlist_headers_rec;
2083: If l_Get_Packlist_Csr%NOTFOUND Then
2084: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
2085: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
2086: fnd_msg_pub.add;
2087: Close l_Get_Packlist_Csr;
2088: RAISE EXCP_USER_DEFINED;

Line 2085: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);

2081: Open l_Get_Packlist_Csr(l_packlist_header_id);
2082: Fetch l_Get_Packlist_Csr Into l_packlist_headers_rec;
2083: If l_Get_Packlist_Csr%NOTFOUND Then
2084: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
2085: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
2086: fnd_msg_pub.add;
2087: Close l_Get_Packlist_Csr;
2088: RAISE EXCP_USER_DEFINED;
2089: Else

Line 2194: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2190: ,X_MSG_DATA => X_MSG_DATA
2191: ,X_RETURN_STATUS => X_RETURN_STATUS);
2192: WHEN OTHERS THEN
2193: Rollback to confirm_receipt_PUB;
2194: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2195: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2196: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2197: fnd_msg_pub.add;
2198: fnd_msg_pub.count_and_get

Line 2195: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

2191: ,X_RETURN_STATUS => X_RETURN_STATUS);
2192: WHEN OTHERS THEN
2193: Rollback to confirm_receipt_PUB;
2194: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2195: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2196: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2197: fnd_msg_pub.add;
2198: fnd_msg_pub.count_and_get
2199: ( p_count => x_msg_count

Line 2196: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

2192: WHEN OTHERS THEN
2193: Rollback to confirm_receipt_PUB;
2194: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2195: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2196: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2197: fnd_msg_pub.add;
2198: fnd_msg_pub.count_and_get
2199: ( p_count => x_msg_count
2200: , p_data => x_msg_data);

Line 2417: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');

2413: BEGIN
2414: OPEN l_ml_records;
2415: FETCH l_ml_records INTO l_csp_mtltxn_rec;
2416: IF l_ml_records%NOTFOUND THEN
2417: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
2418: fnd_msg_pub.add;
2419: CLOSE l_ml_records;
2420: RAISE FND_API.G_EXC_ERROR;
2421: END IF;

Line 2450: FND_MESSAGE.SET_NAME('CSP', 'CSP_RECEIPT_SERIAL_LOT_FAILURE');

2446: delete from mtl_serial_numbers_temp
2447: where transaction_temp_id = l_Serial_Temp_Id_Del;
2448: End Loop;
2449: If l_Get_Serial_Lot_id_Csr%ROWCOUNT = 0 Then
2450: FND_MESSAGE.SET_NAME('CSP', 'CSP_RECEIPT_SERIAL_LOT_FAILURE');
2451: FND_MSG_PUB.ADD;
2452: Close l_Get_Serial_Lot_id_Csr;
2453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2454: End If;

Line 2482: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2478:
2479: Return fnd_api.g_true;
2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2483: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2484: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2485: fnd_msg_pub.add;
2486: Return fnd_api.g_false;

Line 2483: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

2479: Return fnd_api.g_true;
2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2483: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2484: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2485: fnd_msg_pub.add;
2486: Return fnd_api.g_false;
2487: END Clean_Up;

Line 2484: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2483: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2484: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2485: fnd_msg_pub.add;
2486: Return fnd_api.g_false;
2487: END Clean_Up;
2488:

Line 2521: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');

2517: , p_error_explanation => l_error_explanation
2518: );
2519:
2520: If (l_outcome = FALSE) Then
2521: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
2522: --FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, FALSE);
2523: -- FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
2524: FND_MESSAGE.SET_TOKEN('TRANSACTION_HEADER_ID', to_char(p_transaction_header_id), FALSE);
2525: FND_MSG_PUB.ADD;

Line 2522: --FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, FALSE);

2518: );
2519:
2520: If (l_outcome = FALSE) Then
2521: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
2522: --FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, FALSE);
2523: -- FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
2524: FND_MESSAGE.SET_TOKEN('TRANSACTION_HEADER_ID', to_char(p_transaction_header_id), FALSE);
2525: FND_MSG_PUB.ADD;
2526: CLOSE l_Get_Interface_Csr;

Line 2523: -- FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);

2519:
2520: If (l_outcome = FALSE) Then
2521: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
2522: --FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, FALSE);
2523: -- FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
2524: FND_MESSAGE.SET_TOKEN('TRANSACTION_HEADER_ID', to_char(p_transaction_header_id), FALSE);
2525: FND_MSG_PUB.ADD;
2526: CLOSE l_Get_Interface_Csr;
2527: Return l_outcome;

Line 2524: FND_MESSAGE.SET_TOKEN('TRANSACTION_HEADER_ID', to_char(p_transaction_header_id), FALSE);

2520: If (l_outcome = FALSE) Then
2521: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
2522: --FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, FALSE);
2523: -- FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
2524: FND_MESSAGE.SET_TOKEN('TRANSACTION_HEADER_ID', to_char(p_transaction_header_id), FALSE);
2525: FND_MSG_PUB.ADD;
2526: CLOSE l_Get_Interface_Csr;
2527: Return l_outcome;
2528: Else

Line 2807: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');

2803: WHERE transaction_temp_id = p_transaction_temp_id
2804: ORDER BY TRANSACTION_QUANTITY DESC;
2805: BEGIN
2806: IF p_receiving_option NOT IN (1, 2, 3) THEN
2807: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
2808: fnd_msg_pub.add;
2809: RAISE EXCP_USER_DEFINED;
2810: END IF;
2811:

Line 2815: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');

2811:
2812: OPEN l_ml_records;
2813: FETCH l_ml_records INTO l_csp_mtltxn_rec;
2814: IF l_ml_records%NOTFOUND THEN
2815: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
2816: fnd_msg_pub.add;
2817: CLOSE l_ml_records;
2818: RAISE FND_API.G_EXC_ERROR;
2819: END IF;

Line 2825: fnd_message.set_name('CSP', 'CSP_RECEIPT_ACCOUNT_NOT_FOUND');

2821:
2822: l_csp_mtltxn_rec.distribution_account_id := Get_CSP_Acccount_ID (l_csp_mtltxn_rec.organization_id);
2823:
2824: IF l_csp_mtltxn_rec.distribution_account_id IS NULL THEN
2825: fnd_message.set_name('CSP', 'CSP_RECEIPT_ACCOUNT_NOT_FOUND');
2826: fnd_msg_pub.add;
2827: RAISE FND_API.G_EXC_ERROR;
2828: END IF;
2829:

Line 3033: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3029: and fm_serial_number = l_msnt_tbl(l_index).fm_serial_number
3030: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3031:
3032: If (SQL%NOTFOUND) then
3033: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3034: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3035: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3036: fnd_msg_pub.add;
3037: CLOSE l_Get_Msnt;

Line 3034: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3030: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3031:
3032: If (SQL%NOTFOUND) then
3033: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3034: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3035: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3036: fnd_msg_pub.add;
3037: CLOSE l_Get_Msnt;
3038: RAISE EXCP_USER_DEFINED;

Line 3035: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);

3031:
3032: If (SQL%NOTFOUND) then
3033: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3034: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3035: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3036: fnd_msg_pub.add;
3037: CLOSE l_Get_Msnt;
3038: RAISE EXCP_USER_DEFINED;
3039: End If;

Line 3057: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3053: ,p_msnt_tbl_size => 1
3054: );
3055:
3056: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3057: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3058: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3059: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3060: fnd_msg_pub.add;
3061: CLOSE l_Get_Msnt;

Line 3058: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3054: );
3055:
3056: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3057: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3058: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3059: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3060: fnd_msg_pub.add;
3061: CLOSE l_Get_Msnt;
3062: RAISE EXCP_USER_DEFINED;

Line 3059: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);

3055:
3056: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3057: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3058: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3059: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3060: fnd_msg_pub.add;
3061: CLOSE l_Get_Msnt;
3062: RAISE EXCP_USER_DEFINED;
3063: END IF;

Line 3080: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3076: ,p_msnt_tbl_size => 1
3077: );
3078:
3079: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3080: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3081: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3082: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3083: fnd_msg_pub.add;
3084: CLOSE l_Get_Msnt;

Line 3081: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3077: );
3078:
3079: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3080: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3081: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3082: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3083: fnd_msg_pub.add;
3084: CLOSE l_Get_Msnt;
3085: RAISE EXCP_USER_DEFINED;

Line 3082: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);

3078:
3079: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3080: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3081: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3082: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3083: fnd_msg_pub.add;
3084: CLOSE l_Get_Msnt;
3085: RAISE EXCP_USER_DEFINED;
3086: END IF;

Line 3111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3107: and fm_serial_number = l_msnt_tbl(l_index).fm_serial_number
3108: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3109:
3110: If (SQL%NOTFOUND) then
3111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3112: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3113: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3114: fnd_msg_pub.add;
3115: CLOSE l_Get_Msnt;

Line 3112: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3108: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3109:
3110: If (SQL%NOTFOUND) then
3111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3112: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3113: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3114: fnd_msg_pub.add;
3115: CLOSE l_Get_Msnt;
3116: RAISE EXCP_USER_DEFINED;

Line 3113: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);

3109:
3110: If (SQL%NOTFOUND) then
3111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3112: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3113: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3114: fnd_msg_pub.add;
3115: CLOSE l_Get_Msnt;
3116: RAISE EXCP_USER_DEFINED;
3117: End If;

Line 3134: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3130: ,p_msnt_tbl_size => 1
3131: );
3132:
3133: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3134: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3135: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3136: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3137: fnd_msg_pub.add;
3138: CLOSE l_Get_Msnt;

Line 3135: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3131: );
3132:
3133: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3134: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3135: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3136: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3137: fnd_msg_pub.add;
3138: CLOSE l_Get_Msnt;
3139: RAISE EXCP_USER_DEFINED;

Line 3136: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);

3132:
3133: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3134: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3135: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3136: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3137: fnd_msg_pub.add;
3138: CLOSE l_Get_Msnt;
3139: RAISE EXCP_USER_DEFINED;
3140: END IF;

Line 3165: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3161: and fm_serial_number = l_msnt_tbl(l_index).fm_serial_number
3162: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3163:
3164: If (SQL%NOTFOUND) then
3165: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3166: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3167: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3168: fnd_msg_pub.add;
3169: CLOSE l_Get_Msnt;

Line 3166: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3162: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3163:
3164: If (SQL%NOTFOUND) then
3165: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3166: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3167: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3168: fnd_msg_pub.add;
3169: CLOSE l_Get_Msnt;
3170: RAISE EXCP_USER_DEFINED;

Line 3167: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);

3163:
3164: If (SQL%NOTFOUND) then
3165: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3166: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3167: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3168: fnd_msg_pub.add;
3169: CLOSE l_Get_Msnt;
3170: RAISE EXCP_USER_DEFINED;
3171: End If;

Line 3188: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3184: ,p_msnt_tbl_size => 1
3185: );
3186:
3187: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3188: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3189: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3190: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3191: fnd_msg_pub.add;
3192: CLOSE l_Get_Msnt;

Line 3189: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3185: );
3186:
3187: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3188: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3189: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3190: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3191: fnd_msg_pub.add;
3192: CLOSE l_Get_Msnt;
3193: RAISE EXCP_USER_DEFINED;

Line 3190: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);

3186:
3187: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3188: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3189: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3190: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3191: fnd_msg_pub.add;
3192: CLOSE l_Get_Msnt;
3193: RAISE EXCP_USER_DEFINED;
3194: END IF;

Line 3216: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3212: and fm_serial_number = l_msnt_tbl(l_index).fm_serial_number
3213: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3214:
3215: If (SQL%NOTFOUND) then
3216: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3217: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3218: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3219: fnd_msg_pub.add;
3220: CLOSE l_Get_Msnt;

Line 3217: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3213: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3214:
3215: If (SQL%NOTFOUND) then
3216: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3217: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3218: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3219: fnd_msg_pub.add;
3220: CLOSE l_Get_Msnt;
3221: RAISE EXCP_USER_DEFINED;

Line 3218: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);

3214:
3215: If (SQL%NOTFOUND) then
3216: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3217: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3218: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3219: fnd_msg_pub.add;
3220: CLOSE l_Get_Msnt;
3221: RAISE EXCP_USER_DEFINED;
3222: End If;

Line 3251: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3247: and fm_serial_number = l_msnt_tbl(l_index).fm_serial_number
3248: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3249:
3250: If (SQL%NOTFOUND) then
3251: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3252: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3253: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3254: fnd_msg_pub.add;
3255: CLOSE l_Get_Msnt;

Line 3252: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3248: and to_serial_number = l_msnt_tbl(l_index).to_serial_number;
3249:
3250: If (SQL%NOTFOUND) then
3251: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3252: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3253: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3254: fnd_msg_pub.add;
3255: CLOSE l_Get_Msnt;
3256: RAISE EXCP_USER_DEFINED;

Line 3253: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);

3249:
3250: If (SQL%NOTFOUND) then
3251: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3252: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3253: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3254: fnd_msg_pub.add;
3255: CLOSE l_Get_Msnt;
3256: RAISE EXCP_USER_DEFINED;
3257: End If;

Line 3268: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_TXN_RECORD');

3264: END LOOP;
3265:
3266: IF (l_Get_Msnt%rowcount = 0 AND p_serial_number IS NOT NULL) OR
3267: (l_Get_Msnt%rowcount <> 0 AND NOT fnd_api.to_boolean(l_done_flag)) THEN
3268: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_TXN_RECORD');
3269: fnd_msg_pub.add;
3270: IF l_Get_Msnt%ISOPEN THEN
3271: CLOSE l_Get_Msnt;
3272: END IF;

Line 3306: fnd_message.set_name ('CSP', 'CSP_NO_LOT_TXN_RECORD');

3302: OPEN l_Get_Mtlt_Lot_No;
3303: -- This loop only loops once if everything is correct. Otherwise, exceptions should be thrown.
3304: FETCH l_Get_Mtlt_Lot_No INTO l_mtlt_tbl(l_index);
3305: IF l_Get_Mtlt_Lot_No%rowcount = 0 THEN
3306: fnd_message.set_name ('CSP', 'CSP_NO_LOT_TXN_RECORD');
3307: fnd_msg_pub.add;
3308: CLOSE l_Get_Mtlt_Lot_No;
3309: RAISE EXCP_USER_DEFINED;
3310: END IF;

Line 3331: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3327: and serial_transaction_temp_id = l_mtlt_tbl(l_index).serial_transaction_temp_id
3328: and lot_number = l_mtlt_tbl(l_index).lot_number;
3329:
3330: If (SQL%NOTFOUND) then
3331: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3332: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3333: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3334: fnd_msg_pub.add;
3335: CLOSE l_Get_Mtlt;

Line 3332: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3328: and lot_number = l_mtlt_tbl(l_index).lot_number;
3329:
3330: If (SQL%NOTFOUND) then
3331: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3332: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3333: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3334: fnd_msg_pub.add;
3335: CLOSE l_Get_Mtlt;
3336: RAISE EXCP_USER_DEFINED;

Line 3333: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);

3329:
3330: If (SQL%NOTFOUND) then
3331: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3332: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3333: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3334: fnd_msg_pub.add;
3335: CLOSE l_Get_Mtlt;
3336: RAISE EXCP_USER_DEFINED;
3337: End If;

Line 3358: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3354: ,p_mtlt_tbl_size => 1
3355: );
3356:
3357: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3358: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3359: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3360: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3361: fnd_msg_pub.add;
3362: CLOSE l_Get_Mtlt;

Line 3359: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3355: );
3356:
3357: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3358: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3359: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3360: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3361: fnd_msg_pub.add;
3362: CLOSE l_Get_Mtlt;
3363: RAISE EXCP_USER_DEFINED;

Line 3360: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);

3356:
3357: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3358: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3359: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3360: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3361: fnd_msg_pub.add;
3362: CLOSE l_Get_Mtlt;
3363: RAISE EXCP_USER_DEFINED;
3364: ELSE

Line 3373: fnd_message.set_name ('CSP', 'CSP_INVALID_SERIAL_QTY');

3369:
3370: ELSIF l_quantity_remained < 0 THEN
3371: -- For serial controlled items that are also under lot-control, this case should not
3372: -- happen because confirm receipt is transacting one serial number at time.
3373: fnd_message.set_name ('CSP', 'CSP_INVALID_SERIAL_QTY');
3374: fnd_msg_pub.add;
3375: --l_msg_data := 'Unexpected errors.';
3376: CLOSE l_Get_Mtlt;
3377: RAISE EXCP_USER_DEFINED;

Line 3384: fnd_message.set_name ('CSP', 'CSP_INVALID_SERIAL_QTY');

3380: -- l_quantity_remained = 0, this case should not happen either.
3381: -- The p_quantity_received must be 1 when the item is under serial control.
3382: -- If the serial number in the msnt is the last one to be transacted
3383: -- i.e. when fm_serial_number = to_serial_number, the l_serial_case should be 1.
3384: fnd_message.set_name ('CSP', 'CSP_INVALID_SERIAL_QTY');
3385: fnd_msg_pub.add;
3386: CLOSE l_Get_Mtlt;
3387: RAISE EXCP_USER_DEFINED;
3388:

Line 3413: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3409: where transaction_temp_id = l_mtlt_tbl(l_index).transaction_temp_id
3410: and lot_number = l_mtlt_tbl(l_index).lot_number;
3411:
3412: If (SQL%NOTFOUND) then
3413: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3414: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3415: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3416: fnd_msg_pub.add;
3417: CLOSE l_Get_Mtlt;

Line 3414: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3410: and lot_number = l_mtlt_tbl(l_index).lot_number;
3411:
3412: If (SQL%NOTFOUND) then
3413: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3414: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3415: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3416: fnd_msg_pub.add;
3417: CLOSE l_Get_Mtlt;
3418: RAISE EXCP_USER_DEFINED;

Line 3415: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);

3411:
3412: If (SQL%NOTFOUND) then
3413: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3414: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3415: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3416: fnd_msg_pub.add;
3417: CLOSE l_Get_Mtlt;
3418: RAISE EXCP_USER_DEFINED;
3419: End If;

Line 3433: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3429: ,p_mtlt_tbl_size => 1
3430: );
3431:
3432: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3433: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3434: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3435: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3436: fnd_msg_pub.add;
3437: CLOSE l_Get_Mtlt;

Line 3434: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3430: );
3431:
3432: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3433: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3434: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3435: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3436: fnd_msg_pub.add;
3437: CLOSE l_Get_Mtlt;
3438: RAISE EXCP_USER_DEFINED;

Line 3435: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);

3431:
3432: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3433: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3434: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3435: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3436: fnd_msg_pub.add;
3437: CLOSE l_Get_Mtlt;
3438: RAISE EXCP_USER_DEFINED;
3439: END IF;

Line 3453: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');

3449: set transaction_temp_id = p_new_transaction_temp_id
3450: where transaction_temp_id = l_mtlt_tbl(l_index).transaction_temp_id
3451: and lot_number = l_mtlt_tbl(l_index).lot_number;
3452: If (SQL%NOTFOUND) then
3453: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3454: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3455: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3456: fnd_msg_pub.add;
3457: CLOSE l_Get_Mtlt;

Line 3454: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3450: where transaction_temp_id = l_mtlt_tbl(l_index).transaction_temp_id
3451: and lot_number = l_mtlt_tbl(l_index).lot_number;
3452: If (SQL%NOTFOUND) then
3453: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3454: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3455: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3456: fnd_msg_pub.add;
3457: CLOSE l_Get_Mtlt;
3458: RAISE EXCP_USER_DEFINED;

Line 3455: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);

3451: and lot_number = l_mtlt_tbl(l_index).lot_number;
3452: If (SQL%NOTFOUND) then
3453: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3454: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3455: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3456: fnd_msg_pub.add;
3457: CLOSE l_Get_Mtlt;
3458: RAISE EXCP_USER_DEFINED;
3459: End If;

Line 3464: fnd_message.set_name ('CSP', 'CSP_NO_LOT_TXN_RECORD');

3460: END IF;
3461: END LOOP;
3462:
3463: IF l_Get_Mtlt%rowcount = 0 THEN
3464: fnd_message.set_name ('CSP', 'CSP_NO_LOT_TXN_RECORD');
3465: fnd_msg_pub.add;
3466: --l_msg_data := 'Could not find any records in the mtl_transaction_lots_temp table.';
3467: CLOSE l_Get_Mtlt;
3468: RAISE EXCP_USER_DEFINED;

Line 3509: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

3505: ,X_MSG_DATA => X_MSG_DATA
3506: ,X_RETURN_STATUS => X_RETURN_STATUS);
3507: WHEN OTHERS THEN
3508: Rollback to Transact_Serial_Lots_PUB;
3509: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3510: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3511: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
3512: fnd_msg_pub.add;
3513: fnd_msg_pub.count_and_get

Line 3510: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

3506: ,X_RETURN_STATUS => X_RETURN_STATUS);
3507: WHEN OTHERS THEN
3508: Rollback to Transact_Serial_Lots_PUB;
3509: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3510: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3511: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
3512: fnd_msg_pub.add;
3513: fnd_msg_pub.count_and_get
3514: ( p_count => x_msg_count

Line 3511: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

3507: WHEN OTHERS THEN
3508: Rollback to Transact_Serial_Lots_PUB;
3509: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3510: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3511: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
3512: fnd_msg_pub.add;
3513: fnd_msg_pub.count_and_get
3514: ( p_count => x_msg_count
3515: , p_data => x_msg_data);

Line 3538: fnd_message.set_name ('INV', 'INV_INVALID_UOM_CONV');

3534: to_unit => p_csp_mtltxn_rec.item_primary_uom_code,
3535: from_name => p_csp_mtltxn_rec.transaction_uom,
3536: to_name => p_csp_mtltxn_rec.item_primary_uom_code);
3537: IF p_csp_mtltxn_rec.primary_quantity = -99999 THEN
3538: fnd_message.set_name ('INV', 'INV_INVALID_UOM_CONV');
3539: fnd_message.set_token ('VALUE1', p_csp_mtltxn_rec.transaction_uom, TRUE);
3540: fnd_message.set_token ('VALUE2', p_csp_mtltxn_rec.item_primary_uom_code, TRUE);
3541: fnd_msg_pub.add;
3542: RETURN fnd_api.g_false;

Line 3539: fnd_message.set_token ('VALUE1', p_csp_mtltxn_rec.transaction_uom, TRUE);

3535: from_name => p_csp_mtltxn_rec.transaction_uom,
3536: to_name => p_csp_mtltxn_rec.item_primary_uom_code);
3537: IF p_csp_mtltxn_rec.primary_quantity = -99999 THEN
3538: fnd_message.set_name ('INV', 'INV_INVALID_UOM_CONV');
3539: fnd_message.set_token ('VALUE1', p_csp_mtltxn_rec.transaction_uom, TRUE);
3540: fnd_message.set_token ('VALUE2', p_csp_mtltxn_rec.item_primary_uom_code, TRUE);
3541: fnd_msg_pub.add;
3542: RETURN fnd_api.g_false;
3543: END IF;

Line 3540: fnd_message.set_token ('VALUE2', p_csp_mtltxn_rec.item_primary_uom_code, TRUE);

3536: to_name => p_csp_mtltxn_rec.item_primary_uom_code);
3537: IF p_csp_mtltxn_rec.primary_quantity = -99999 THEN
3538: fnd_message.set_name ('INV', 'INV_INVALID_UOM_CONV');
3539: fnd_message.set_token ('VALUE1', p_csp_mtltxn_rec.transaction_uom, TRUE);
3540: fnd_message.set_token ('VALUE2', p_csp_mtltxn_rec.item_primary_uom_code, TRUE);
3541: fnd_msg_pub.add;
3542: RETURN fnd_api.g_false;
3543: END IF;
3544: END IF;