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.INV_KANBAN_PVT dependencies on FND_MSG_PUB

Line 164: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161:
162: WHEN OTHERS THEN
163:
164: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
165: THEN
166: FND_MSG_PUB.Add_Exc_Msg
167: ( G_PKG_NAME
168: , 'Validate_Pull_Sequence'

Line 166: FND_MSG_PUB.Add_Exc_Msg

162: WHEN OTHERS THEN
163:
164: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
165: THEN
166: FND_MSG_PUB.Add_Exc_Msg
167: ( G_PKG_NAME
168: , 'Validate_Pull_Sequence'
169: );
170: END IF;

Line 189: FND_MSG_PUB.Add;

185: if p_Pull_Sequence_Rec.Organization_Id is null
186: then
187: FND_MESSAGE.SET_NAME('INV','INV_ORG_REQUIRED');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization');
189: FND_MSG_PUB.Add;
190: Raise FND_API.G_EXC_ERROR;
191: End if;
192:
193: if p_Pull_Sequence_Rec.inventory_item_id is null

Line 196: FND_MSG_PUB.Add;

192:
193: if p_Pull_Sequence_Rec.inventory_item_id is null
194: then
195: FND_MESSAGE.SET_NAME('INV','INV_ITEM_REQUIRED');
196: FND_MSG_PUB.Add;
197: Raise FND_API.G_EXC_ERROR;
198: end if;
199:
200: if p_Pull_Sequence_Rec.subinventory_name is null

Line 203: FND_MSG_PUB.Add;

199:
200: if p_Pull_Sequence_Rec.subinventory_name is null
201: then
202: FND_MESSAGE.SET_NAME('INV','INV_SUBINV_REQUIRED');
203: FND_MSG_PUB.Add;
204: Raise FND_API.G_EXC_ERROR;
205: end if;
206:
207: if p_Pull_Sequence_Rec.source_type is null

Line 211: FND_MSG_PUB.Add;

207: if p_Pull_Sequence_Rec.source_type is null
208: then
209: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SOURCE_TYPE',TRUE);
211: FND_MSG_PUB.Add;
212: Raise FND_API.G_EXC_ERROR;
213: end if;
214:
215: if p_Pull_Sequence_Rec.kanban_plan_id is null

Line 219: FND_MSG_PUB.Add;

215: if p_Pull_Sequence_Rec.kanban_plan_id is null
216: then
217: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_PLAN',TRUE);
219: FND_MSG_PUB.Add;
220: Raise FND_API.G_EXC_ERROR;
221: end if;
222:
223: if p_Pull_Sequence_Rec.source_type = INV_Kanban_PVT.G_Source_type_IntraOrg

Line 228: FND_MSG_PUB.Add;

224: And p_Pull_Sequence_Rec.source_subinventory is null
225: then
226: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SOURCE_SUBINV',TRUE);
228: FND_MSG_PUB.Add;
229: Raise FND_API.G_EXC_ERROR;
230: end if;
231:
232: /*Code modification for bug2186198*/

Line 238: FND_MSG_PUB.Add;

234: And p_Pull_Sequence_Rec.wip_line_id is null
235: then
236: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
238: FND_MSG_PUB.Add;
239: Raise FND_API.G_EXC_ERROR;
240: end if; */
241:
242:

Line 255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

251: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
252:
253: WHEN OTHERS THEN
254:
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg
258: ( G_PKG_NAME
259: , 'Validate_Pull_Sequence'

Line 257: FND_MSG_PUB.Add_Exc_Msg

253: WHEN OTHERS THEN
254:
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg
258: ( G_PKG_NAME
259: , 'Validate_Pull_Sequence'
260: );
261: END IF;

Line 279: FND_MSG_PUB.initialize;

275: l_Pull_Sequence_Rec INV_Kanban_PVT.Pull_sequence_Rec_Type;
276: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
277: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
278: Begin
279: FND_MSG_PUB.initialize;
280: l_Pull_Sequence_Rec := INV_PullSequence_PKG.Convert_Miss_To_Null
281: (p_Pull_Sequence_Rec);
282:
283: Validate_Pull_sequence(l_pull_sequence_rec);

Line 308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

304:
305: WHEN OTHERS THEN
306:
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg
311: ( G_PKG_NAME
312: , 'Insert_Pull_sequence'

Line 310: FND_MSG_PUB.Add_Exc_Msg

306:
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg
311: ( G_PKG_NAME
312: , 'Insert_Pull_sequence'
313: );
314: END IF;

Line 338: FND_MSG_PUB.initialize;

334:
335:
336: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
337: Begin
338: FND_MSG_PUB.initialize;
339: l_Pull_Sequence_Rec := x_Pull_Sequence_Rec;
340: l_Pull_Sequence_Rec.pull_sequence_id := Null;
341:
342: if (l_pull_Sequence_Rec.pull_sequence_Id is null or

Line 355: FND_MSG_PUB.Add;

351: l_pull_Sequence_Rec.Subinventory_Name = FND_API.G_MISS_CHAR )
352: then
353: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_PULL_SEQUENCE');
355: FND_MSG_PUB.Add;
356: l_return_status := FND_API.G_RET_STS_ERROR;
357:
358: elsif (l_pull_Sequence_Rec.pull_sequence_Id is null or
359: l_pull_Sequence_Rec.pull_sequence_Id = FND_API.G_MISS_NUM)

Line 401: FND_MSG_PUB.Add;

397: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
398: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
399: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Pull_Sequence_Rec.Subinventory_Name);
400: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
401: FND_MSG_PUB.Add;
402: l_return_status := FND_API.G_RET_STS_ERROR;
403: When Others
404: Then
405: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

449:
450: WHEN OTHERS THEN
451:
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg
456: ( G_PKG_NAME
457: , 'Update_Pull_sequence'

Line 455: FND_MSG_PUB.Add_Exc_Msg

451:
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg
456: ( G_PKG_NAME
457: , 'Update_Pull_sequence'
458: );
459: END IF;

Line 495: FND_MSG_PUB.initialize;

491: CURSOR C2 IS SELECT mtl_kanban_pull_sequences_s.nextval FROM sys.dual;
492: --Get new pull_sequence_id during insert.
493:
494: Begin
495: FND_MSG_PUB.initialize;
496: l_PullSeqTable := p_Pull_Sequence_tbl;
497: l_operation_tbl:= p_operation_tbl;
498:
499: SELECT MTL_KANBAN_CARD_PRINT_TEMP_S.nextval

Line 622: FND_MSG_PUB.Add;

618: COMMIT;
619: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');
620: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);
621: fnd_message.set_token('PROCESS','INV_GENERATE_KANBAN_CARDS', TRUE);
622: FND_MSG_PUB.Add;
623: ELSE
624: fnd_message.set_name('INV','INV_PROCESS_FAILED');
625: fnd_message.set_token('PROCESS', 'INV_GENERATE_KANBAN_CARDS', TRUE);
626: FND_MSG_PUB.Add;

Line 626: FND_MSG_PUB.Add;

622: FND_MSG_PUB.Add;
623: ELSE
624: fnd_message.set_name('INV','INV_PROCESS_FAILED');
625: fnd_message.set_token('PROCESS', 'INV_GENERATE_KANBAN_CARDS', TRUE);
626: FND_MSG_PUB.Add;
627: RAISE FND_API.G_EXC_ERROR;
628: END IF;
629: END IF;
630:

Line 666: FND_MSG_PUB.Add;

662: COMMIT;
663: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');
664: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);
665: fnd_message.set_token('PROCESS', 'INV_PRINT_KANBAN_CARDS', TRUE);
666: FND_MSG_PUB.Add;
667: ELSE
668: -- delete from MTL_KANBAN_CARD_PRINT_TEMP
669: -- where
670: -- report_id = l_report_id;

Line 674: FND_MSG_PUB.Add;

670: -- report_id = l_report_id;
671: -- COMMIT;
672: fnd_message.set_name('INV','INV_PROCESS_FAILED');
673: fnd_message.set_token('PROCESS', 'INV_PRINT_KANBAN_CARDS', TRUE);
674: FND_MSG_PUB.Add;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;
677: END IF;
678: x_return_status := l_return_status;

Line 690: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687:
688: WHEN OTHERS THEN
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg
693: ( G_PKG_NAME
694: , 'Update_Pull_sequence'

Line 692: FND_MSG_PUB.Add_Exc_Msg

688: WHEN OTHERS THEN
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg
693: ( G_PKG_NAME
694: , 'Update_Pull_sequence'
695: );
696: END IF;

Line 727: FND_MSG_PUB.initialize;

723: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
724: l_temp NUMBER := NULL;
725: l_update Boolean := TRUE; -- For Bug 3740514
726: Begin
727: FND_MSG_PUB.initialize;
728:
729: IF p_Kanban_Card_Id is NULL THEN
730: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');

Line 732: FND_MSG_PUB.Add;

728:
729: IF p_Kanban_Card_Id is NULL THEN
730: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');
732: FND_MSG_PUB.Add;
733: l_return_status := FND_API.G_RET_STS_ERROR;
734: ELSIF p_supply_status is null THEN
735: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
736: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SUPPLY_STATUS');

Line 737: FND_MSG_PUB.Add;

733: l_return_status := FND_API.G_RET_STS_ERROR;
734: ELSIF p_supply_status is null THEN
735: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
736: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SUPPLY_STATUS');
737: FND_MSG_PUB.Add;
738: l_return_status := FND_API.G_RET_STS_ERROR;
739: ELSE
740:
741: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row

Line 758: FND_MSG_PUB.ADD;

754: EXCEPTION
755: WHEN OTHERS THEN
756: l_return_status := FND_API.G_RET_STS_ERROR;
757: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_LOCK_KANBAN_CARD');
758: FND_MSG_PUB.ADD;
759: END;
760:
761: IF l_return_status = FND_API.g_ret_sts_error THEN
762: NULL;

Line 766: FND_MSG_PUB.ADD;

762: NULL;
763: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Hold ) THEN
764: l_return_status := FND_API.G_RET_STS_ERROR;
765: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_HOLD_CARD');
766: FND_MSG_PUB.ADD;
767: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Cancel ) then
768: l_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
770: FND_MSG_PUB.ADD;

Line 770: FND_MSG_PUB.ADD;

766: FND_MSG_PUB.ADD;
767: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Cancel ) then
768: l_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
770: FND_MSG_PUB.ADD;
771:
772: --Bug 3288422 fix.
773: ELSE
774: IF INV_KanbanCard_PKG.Supply_Status_Change_OK

Line 818: FND_MSG_PUB.Add;

814: then
815: FND_MESSAGE.SET_TOKEN('CARD_NUMBER',l_kanban_card_rec.kanban_card_number);
816: End If;
817: l_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Add;
819: END IF;--IF INV_KanbanCard_PKG.Supply_Status_Change_OK
820: END IF;--IF l_return_status = FND_API.g_ret_sts_error
821: END IF;--IF p_Kanban_Card_Id is NULL THEN
822:

Line 842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

838:
839: WHEN OTHERS THEN
840:
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843: THEN
844: FND_MSG_PUB.Add_Exc_Msg
845: ( G_PKG_NAME
846: , 'Update_Card_Supply_Status'

Line 844: FND_MSG_PUB.Add_Exc_Msg

840:
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843: THEN
844: FND_MSG_PUB.Add_Exc_Msg
845: ( G_PKG_NAME
846: , 'Update_Card_Supply_Status'
847: );
848: END IF;

Line 925: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

921:
922: WHEN OTHERS THEN
923:
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: FND_MSG_PUB.Add_Exc_Msg
928: ( G_PKG_NAME
929: , 'Update_Card_Supply_Status'

Line 927: FND_MSG_PUB.Add_Exc_Msg

923:
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: FND_MSG_PUB.Add_Exc_Msg
928: ( G_PKG_NAME
929: , 'Update_Card_Supply_Status'
930: );
931: END IF;

Line 989: FND_MSG_PUB.initialize;

985:
986: -- Initialize message list.
987:
988: IF FND_API.to_Boolean(p_init_msg_list) THEN
989: FND_MSG_PUB.initialize;
990: END IF;
991:
992: mydebug('Calling Update_Card_Supply_Status 2');
993: Update_Card_Supply_Status(X_Return_Status => l_Return_Status,

Line 1012: FND_MSG_PUB.Count_And_Get

1008: COMMIT WORK;
1009: END IF;
1010:
1011: -- Standard call to get message count and if count is 1, get message info.
1012: FND_MSG_PUB.Count_And_Get
1013: ( p_count => x_msg_count ,
1014: p_data => x_msg_data
1015: );
1016:

Line 1022: FND_MSG_PUB.Count_And_Get

1018:
1019: WHEN FND_API.G_EXC_ERROR THEN
1020: ROLLBACK TO KANBAN_PVT;
1021: x_return_status := FND_API.G_RET_STS_ERROR ;
1022: FND_MSG_PUB.Count_And_Get
1023: ( p_count => x_msg_count ,
1024: p_data => x_msg_data
1025: );
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1029: FND_MSG_PUB.Count_And_Get

1025: );
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: ROLLBACK TO KANBAN_PVT;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: FND_MSG_PUB.Count_And_Get
1030: ( p_count => x_msg_count ,
1031: p_data => x_msg_data
1032: );
1033:

Line 1037: IF FND_MSG_PUB.Check_Msg_Level

1033:
1034: WHEN OTHERS THEN
1035: ROLLBACK TO KANBAN_PVT;
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1037: IF FND_MSG_PUB.Check_Msg_Level
1038: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1039: THEN
1040: FND_MSG_PUB.Add_Exc_Msg
1041: ( G_PKG_NAME ,

Line 1038: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1034: WHEN OTHERS THEN
1035: ROLLBACK TO KANBAN_PVT;
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1037: IF FND_MSG_PUB.Check_Msg_Level
1038: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1039: THEN
1040: FND_MSG_PUB.Add_Exc_Msg
1041: ( G_PKG_NAME ,
1042: l_api_name

Line 1040: FND_MSG_PUB.Add_Exc_Msg

1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1037: IF FND_MSG_PUB.Check_Msg_Level
1038: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1039: THEN
1040: FND_MSG_PUB.Add_Exc_Msg
1041: ( G_PKG_NAME ,
1042: l_api_name
1043: );
1044: END IF;

Line 1045: FND_MSG_PUB.Count_And_Get

1041: ( G_PKG_NAME ,
1042: l_api_name
1043: );
1044: END IF;
1045: FND_MSG_PUB.Count_And_Get
1046: ( p_count => x_msg_count ,
1047: p_data => x_msg_data
1048: );
1049:

Line 1088: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1084:
1085: WHEN OTHERS THEN
1086:
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1089: THEN
1090: FND_MSG_PUB.Add_Exc_Msg
1091: ( G_PKG_NAME
1092: , 'Update_Card_Supply_Status'

Line 1090: FND_MSG_PUB.Add_Exc_Msg

1086:
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1089: THEN
1090: FND_MSG_PUB.Add_Exc_Msg
1091: ( G_PKG_NAME
1092: , 'Update_Card_Supply_Status'
1093: );
1094: END IF;

Line 1126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1122: When Too_many_rows Then
1123: return TRUE;
1124: When Others Then
1125:
1126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1127: THEN
1128: FND_MSG_PUB.Add_Exc_Msg
1129: ( G_PKG_NAME
1130: , 'Valid_kanban_Cards_exist'

Line 1128: FND_MSG_PUB.Add_Exc_Msg

1124: When Others Then
1125:
1126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1127: THEN
1128: FND_MSG_PUB.Add_Exc_Msg
1129: ( G_PKG_NAME
1130: , 'Valid_kanban_Cards_exist'
1131: );
1132: END IF;

Line 1223: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1219:
1220: When Too_many_rows Then
1221: return 0; -------Cards with status wait/inprocess exists
1222: When Others Then
1223: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1224: THEN
1225: FND_MSG_PUB.Add_Exc_Msg
1226: ( G_PKG_NAME
1227: , 'Diff_Qty_Kanban_Cards_Exist'

Line 1225: FND_MSG_PUB.Add_Exc_Msg

1221: return 0; -------Cards with status wait/inprocess exists
1222: When Others Then
1223: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1224: THEN
1225: FND_MSG_PUB.Add_Exc_Msg
1226: ( G_PKG_NAME
1227: , 'Diff_Qty_Kanban_Cards_Exist'
1228: );
1229: END IF;

Line 1377: FND_MSG_PUB.Add_Exc_Msg

1373: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_CARD_NOT_FOUND');
1374: FND_MESSAGE.SET_TOKEN('CARDID',to_char(p_kanban_id) );
1375: RETURN FALSE;
1376: When OTHERS then
1377: FND_MSG_PUB.Add_Exc_Msg
1378: ( G_PKG_NAME
1379: , 'Valid_Production_Kanban_Card'
1380: );
1381: RETURN FALSE;

Line 1437: FND_MSG_PUB.Add_Exc_Msg

1433: return FALSE;
1434: When Too_many_rows Then
1435: return TRUE;
1436: When Others Then
1437: FND_MSG_PUB.Add_Exc_Msg
1438: ( G_PKG_NAME
1439: , 'Valid_Prod_kanban_Card'
1440: );
1441: return FALSE;

Line 1490: FND_MSG_PUB.initialize;

1486:
1487: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1488: BEGIN
1489:
1490: FND_MSG_PUB.initialize;
1491: l_kanban_Card_tbl.Delete;
1492:
1493:
1494:

Line 1516: FND_MSG_PUB.Add;

1512: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1513: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1514: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1515: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1516: FND_MSG_PUB.Add;
1517:
1518: l_return_status := FND_API.G_RET_STS_ERROR;
1519:
1520: end if;

Line 1534: FND_MSG_PUB.Add;

1530: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1531: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1532: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1533: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1534: FND_MSG_PUB.Add;
1535: l_return_status := FND_API.G_RET_STS_ERROR;
1536:
1537: end if;
1538:

Line 1646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1642:
1643: WHEN OTHERS THEN
1644:
1645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1647: THEN
1648: FND_MSG_PUB.Add_Exc_Msg
1649: ( G_PKG_NAME
1650: , 'Create_Kanban_Cards'

Line 1648: FND_MSG_PUB.Add_Exc_Msg

1644:
1645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1647: THEN
1648: FND_MSG_PUB.Add_Exc_Msg
1649: ( G_PKG_NAME
1650: , 'Create_Kanban_Cards'
1651: );
1652: END IF;

Line 1869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1865:
1866: Raise FND_API.G_EXC_ERROR;
1867:
1868: WHEN OTHERS THEN
1869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1870: THEN
1871: FND_MSG_PUB.Add_Exc_Msg
1872: ( G_PKG_NAME
1873: , 'Create_Requisition'

Line 1871: FND_MSG_PUB.Add_Exc_Msg

1867:
1868: WHEN OTHERS THEN
1869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1870: THEN
1871: FND_MSG_PUB.Add_Exc_Msg
1872: ( G_PKG_NAME
1873: , 'Create_Requisition'
1874: );
1875: END IF;

Line 2037: FND_MSG_PUB.Add_Exc_Msg

2033: x_trolin_tbl => l_x_trolin_tbl
2034: );
2035:
2036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2037: FND_MSG_PUB.Add_Exc_Msg
2038: ( G_PKG_NAME
2039: , 'Create_transfer_order'
2040: );
2041: RAISE FND_API.G_EXC_ERROR;

Line 2043: FND_MSG_PUB.Add_Exc_Msg

2039: , 'Create_transfer_order'
2040: );
2041: RAISE FND_API.G_EXC_ERROR;
2042: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2043: FND_MSG_PUB.Add_Exc_Msg
2044: ( G_PKG_NAME
2045: , 'Create_transfer_order'
2046: );
2047: RAISE FND_API.G_EXC_ERROR;

Line 2078: FND_MSG_PUB.Add;

2074:
2075: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2076: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
2077: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2078: FND_MSG_PUB.Add;
2079: ELSE
2080: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2081: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2082: FND_MSG_PUB.Add;

Line 2082: FND_MSG_PUB.Add;

2078: FND_MSG_PUB.Add;
2079: ELSE
2080: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2081: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2082: FND_MSG_PUB.Add;
2083: END IF;
2084:
2085: END IF;
2086: /* End of fix for 3905884*/

Line 2093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2089: WHEN FND_API.G_EXC_ERROR THEN
2090: Raise FND_API.G_EXC_ERROR;
2091:
2092: WHEN OTHERS THEN
2093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2094: FND_MSG_PUB.Add_Exc_Msg
2095: ( G_PKG_NAME
2096: , 'Create_Transfer_Order'
2097: );

Line 2094: FND_MSG_PUB.Add_Exc_Msg

2090: Raise FND_API.G_EXC_ERROR;
2091:
2092: WHEN OTHERS THEN
2093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2094: FND_MSG_PUB.Add_Exc_Msg
2095: ( G_PKG_NAME
2096: , 'Create_Transfer_Order'
2097: );
2098: END IF;

Line 2130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2126: end if;
2127:
2128: exception
2129: WHEN OTHERS THEN
2130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2131: THEN
2132: FND_MSG_PUB.Add_Exc_Msg
2133: ( G_PKG_NAME
2134: , 'Launch_MLP'

Line 2132: FND_MSG_PUB.Add_Exc_Msg

2128: exception
2129: WHEN OTHERS THEN
2130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2131: THEN
2132: FND_MSG_PUB.Add_Exc_Msg
2133: ( G_PKG_NAME
2134: , 'Launch_MLP'
2135: );
2136: END IF;

Line 2257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2253:
2254: Raise FND_API.G_EXC_ERROR;
2255:
2256: WHEN OTHERS THEN
2257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2258: THEN
2259: FND_MSG_PUB.Add_Exc_Msg
2260: ( G_PKG_NAME
2261: , 'Create_Wip_Discrete'

Line 2259: FND_MSG_PUB.Add_Exc_Msg

2255:
2256: WHEN OTHERS THEN
2257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2258: THEN
2259: FND_MSG_PUB.Add_Exc_Msg
2260: ( G_PKG_NAME
2261: , 'Create_Wip_Discrete'
2262: );
2263: END IF;

Line 2299: FND_MSG_PUB.Add_Exc_Msg

2295: LINE_ID = p_kanban_card_rec_tbl(1).wip_line_id AND
2296: organization_id = p_kanban_card_rec_tbl(1).organization_id;
2297: exception
2298: When others then
2299: FND_MSG_PUB.Add_Exc_Msg
2300: ( G_PKG_NAME
2301: , 'Create Rep Sched|Wip Line Not Defined'
2302: );
2303: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2325: FND_MSG_PUB.Add_Exc_Msg

2321: rep_sched_exist := 'N';
2322: When TOO_MANY_ROWS then
2323: rep_sched_exist := 'Y';
2324: When others then
2325: FND_MSG_PUB.Add_Exc_Msg
2326: ( G_PKG_NAME
2327: , 'Create Rep Sched|checking existing Schedules'
2328: );
2329: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2462: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2458: WHEN FND_API.G_EXC_ERROR THEN
2459: Raise FND_API.G_EXC_ERROR;
2460:
2461: WHEN OTHERS THEN
2462: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2463: THEN
2464: FND_MSG_PUB.Add_Exc_Msg
2465: ( G_PKG_NAME
2466: , 'Create_Rep_Schedule'

Line 2464: FND_MSG_PUB.Add_Exc_Msg

2460:
2461: WHEN OTHERS THEN
2462: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2463: THEN
2464: FND_MSG_PUB.Add_Exc_Msg
2465: ( G_PKG_NAME
2466: , 'Create_Rep_Schedule'
2467: );
2468: END IF;

Line 2578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2574:
2575: Raise FND_API.G_EXC_ERROR;
2576:
2577: WHEN OTHERS THEN
2578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2579: THEN
2580: FND_MSG_PUB.Add_Exc_Msg
2581: ( G_PKG_NAME
2582: , 'Create_Flow_Schedule'

Line 2580: FND_MSG_PUB.Add_Exc_Msg

2576:
2577: WHEN OTHERS THEN
2578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2579: THEN
2580: FND_MSG_PUB.Add_Exc_Msg
2581: ( G_PKG_NAME
2582: , 'Create_Flow_Schedule'
2583: );
2584: END IF;

Line 2770: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2766:
2767: Raise FND_API.G_EXC_ERROR;
2768:
2769: WHEN OTHERS THEN
2770: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2771: THEN
2772: FND_MSG_PUB.Add_Exc_Msg
2773: ( G_PKG_NAME
2774: , 'Create_lot_based_job'

Line 2772: FND_MSG_PUB.Add_Exc_Msg

2768:
2769: WHEN OTHERS THEN
2770: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2771: THEN
2772: FND_MSG_PUB.Add_Exc_Msg
2773: ( G_PKG_NAME
2774: , 'Create_lot_based_job'
2775: );
2776: END IF;

Line 2811: FND_MSG_PUB.Add_Exc_Msg

2807: inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
2808: organization_id = p_kanban_card_rec_tbl(1).organization_id;
2809: exception
2810: when others then
2811: FND_MSG_PUB.Add_Exc_Msg
2812: ( G_PKG_NAME
2813: , 'Ist SQL stmt'
2814: );
2815: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2829: FND_MSG_PUB.Add_Exc_Msg

2825: exception
2826: when NO_DATA_FOUND then
2827: v_cfm_flag := 2;
2828: when others then
2829: FND_MSG_PUB.Add_Exc_Msg
2830: ( G_PKG_NAME
2831: , 'wip line id IS NULL'
2832: );
2833: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2889: FND_MSG_PUB.Add;

2885: exception
2886: when NO_DATA_FOUND then
2887: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
2889: FND_MSG_PUB.Add;
2890: Raise FND_API.G_EXC_ERROR;
2891: when others then
2892: FND_MSG_PUB.Add_Exc_Msg
2893: (G_PKG_NAME ,'wip line id IS NULL');

Line 2892: FND_MSG_PUB.Add_Exc_Msg

2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
2889: FND_MSG_PUB.Add;
2890: Raise FND_API.G_EXC_ERROR;
2891: when others then
2892: FND_MSG_PUB.Add_Exc_Msg
2893: (G_PKG_NAME ,'wip line id IS NULL');
2894: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2895: end ;
2896: create_rep_schedule(p_kanban_card_rec_tbl, v_fixed_lead_time,

Line 2927: FND_MSG_PUB.Add_Exc_Msg

2923: exception
2924: when NO_DATA_FOUND then
2925: v_cfm_flag := 2;
2926: when others then
2927: FND_MSG_PUB.Add_Exc_Msg
2928: ( G_PKG_NAME
2929: , 'wip line id IS not NULL'
2930: );
2931: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2984: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2980:
2981: Raise FND_API.G_EXC_ERROR;
2982:
2983: WHEN OTHERS THEN
2984: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2985: THEN
2986: FND_MSG_PUB.Add_Exc_Msg
2987: ( G_PKG_NAME
2988: , 'Create_Wip_Job'

Line 2986: FND_MSG_PUB.Add_Exc_Msg

2982:
2983: WHEN OTHERS THEN
2984: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2985: THEN
2986: FND_MSG_PUB.Add_Exc_Msg
2987: ( G_PKG_NAME
2988: , 'Create_Wip_Job'
2989: );
2990: END IF;

Line 3282: FND_MSG_PUB.Add;

3278: Then
3279: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3280: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
3281: End If;
3282: FND_MSG_PUB.Add;
3283: Raise FND_API.G_EXC_ERROR;
3284:
3285: WHEN FND_API.G_EXC_ERROR THEN
3286:

Line 3290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3286:
3287: Raise FND_API.G_EXC_ERROR;
3288:
3289: WHEN OTHERS THEN
3290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3291: THEN
3292: FND_MSG_PUB.Add_Exc_Msg
3293: ( G_PKG_NAME
3294: , 'Create_Replenishment'

Line 3292: FND_MSG_PUB.Add_Exc_Msg

3288:
3289: WHEN OTHERS THEN
3290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3291: THEN
3292: FND_MSG_PUB.Add_Exc_Msg
3293: ( G_PKG_NAME
3294: , 'Create_Replenishment'
3295: );
3296: END IF;

Line 3495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3491: WHEN OTHERS THEN
3492:
3493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3494:
3495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3496: THEN
3497: FND_MSG_PUB.Add_Exc_Msg
3498: ( G_PKG_NAME
3499: , 'Check_And_Create_Replenishment'

Line 3497: FND_MSG_PUB.Add_Exc_Msg

3493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3494:
3495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3496: THEN
3497: FND_MSG_PUB.Add_Exc_Msg
3498: ( G_PKG_NAME
3499: , 'Check_And_Create_Replenishment'
3500: );
3501: END IF;

Line 3538: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3534: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3535:
3536: WHEN OTHERS THEN
3537:
3538: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3539: THEN
3540: FND_MSG_PUB.Add_Exc_Msg
3541: ( G_PKG_NAME
3542: , 'test'

Line 3540: FND_MSG_PUB.Add_Exc_Msg

3536: WHEN OTHERS THEN
3537:
3538: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3539: THEN
3540: FND_MSG_PUB.Add_Exc_Msg
3541: ( G_PKG_NAME
3542: , 'test'
3543: );
3544: END IF;

Line 3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3603: x_att := NULL;
3604: x_err_code := -1;
3605: x_err_msg := Substr(Sqlerrm,1,255);
3606:
3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3608: THEN
3609: FND_MSG_PUB.Add_Exc_Msg
3610: ( G_PKG_NAME
3611: ,'return_att_quantity'

Line 3609: FND_MSG_PUB.Add_Exc_Msg

3605: x_err_msg := Substr(Sqlerrm,1,255);
3606:
3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3608: THEN
3609: FND_MSG_PUB.Add_Exc_Msg
3610: ( G_PKG_NAME
3611: ,'return_att_quantity'
3612: );
3613: END IF;

Line 3646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3642: x_max_asmbly_qty := NULL;
3643: x_error_code := -1;
3644: x_error_msg := Substr(Sqlerrm,1,255);
3645:
3646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3647: THEN
3648: FND_MSG_PUB.Add_Exc_Msg
3649: ( G_PKG_NAME
3650: ,'return_max_kanban_asmbly_qty'

Line 3648: FND_MSG_PUB.Add_Exc_Msg

3644: x_error_msg := Substr(Sqlerrm,1,255);
3645:
3646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3647: THEN
3648: FND_MSG_PUB.Add_Exc_Msg
3649: ( G_PKG_NAME
3650: ,'return_max_kanban_asmbly_qty'
3651: );
3652: END IF;

Line 3755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3751: WHEN OTHERS THEN
3752: x_error_code := -1;
3753: x_error_msg := Substr(Sqlerrm,1,255);
3754:
3755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3756: THEN
3757: FND_MSG_PUB.Add_Exc_Msg
3758: ( G_PKG_NAME
3759: ,'GET_KANBAN_REC_GRP_INFO'

Line 3757: FND_MSG_PUB.Add_Exc_Msg

3753: x_error_msg := Substr(Sqlerrm,1,255);
3754:
3755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3756: THEN
3757: FND_MSG_PUB.Add_Exc_Msg
3758: ( G_PKG_NAME
3759: ,'GET_KANBAN_REC_GRP_INFO'
3760: );
3761: END IF;