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 741: FND_MSG_PUB.initialize;

737: X_RETCODE => l_return_status);
738: -- end - eKanban project
739: -- continue with existing code if eKanban profile is not enabled.
740: else
741: FND_MSG_PUB.initialize;
742:
743: IF p_Kanban_Card_Id is NULL THEN
744: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');

Line 746: FND_MSG_PUB.Add;

742:
743: IF p_Kanban_Card_Id is NULL THEN
744: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');
746: FND_MSG_PUB.Add;
747: l_return_status := FND_API.G_RET_STS_ERROR;
748: ELSIF p_supply_status is null THEN
749: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SUPPLY_STATUS');

Line 751: FND_MSG_PUB.Add;

747: l_return_status := FND_API.G_RET_STS_ERROR;
748: ELSIF p_supply_status is null THEN
749: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SUPPLY_STATUS');
751: FND_MSG_PUB.Add;
752: l_return_status := FND_API.G_RET_STS_ERROR;
753: ELSE
754:
755: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row

Line 772: FND_MSG_PUB.ADD;

768: EXCEPTION
769: WHEN OTHERS THEN
770: l_return_status := FND_API.G_RET_STS_ERROR;
771: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_LOCK_KANBAN_CARD');
772: FND_MSG_PUB.ADD;
773: END;
774:
775: IF l_return_status = FND_API.g_ret_sts_error THEN
776: NULL;

Line 780: FND_MSG_PUB.ADD;

776: NULL;
777: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Hold ) THEN
778: l_return_status := FND_API.G_RET_STS_ERROR;
779: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_HOLD_CARD');
780: FND_MSG_PUB.ADD;
781: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Cancel ) then
782: l_return_status := FND_API.G_RET_STS_ERROR;
783: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
784: FND_MSG_PUB.ADD;

Line 784: FND_MSG_PUB.ADD;

780: FND_MSG_PUB.ADD;
781: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Cancel ) then
782: l_return_status := FND_API.G_RET_STS_ERROR;
783: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
784: FND_MSG_PUB.ADD;
785: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Planned ) then
786: l_return_status := FND_API.G_RET_STS_ERROR;
787: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
788: FND_MSG_PUB.ADD;

Line 788: FND_MSG_PUB.ADD;

784: FND_MSG_PUB.ADD;
785: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Planned ) then
786: l_return_status := FND_API.G_RET_STS_ERROR;
787: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
788: FND_MSG_PUB.ADD;
789: --Bug 3288422 fix.
790: ELSE
791: IF INV_KanbanCard_PKG.Supply_Status_Change_OK
792: (trunc(l_kanban_card_rec.supply_status),

Line 837: FND_MSG_PUB.Add;

833: then
834: FND_MESSAGE.SET_TOKEN('CARD_NUMBER',l_kanban_card_rec.kanban_card_number);
835: End If;
836: l_return_status := FND_API.G_RET_STS_ERROR;
837: FND_MSG_PUB.Add;
838: END IF;--IF INV_KanbanCard_PKG.Supply_Status_Change_OK
839: END IF;--IF l_return_status = FND_API.g_ret_sts_error
840: END IF;--IF p_Kanban_Card_Id is NULL THEN
841:

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

858:
859: WHEN OTHERS THEN
860:
861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
863: THEN
864: FND_MSG_PUB.Add_Exc_Msg
865: ( G_PKG_NAME
866: , 'Update_Card_Supply_Status'

Line 864: FND_MSG_PUB.Add_Exc_Msg

860:
861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
863: THEN
864: FND_MSG_PUB.Add_Exc_Msg
865: ( G_PKG_NAME
866: , 'Update_Card_Supply_Status'
867: );
868: END IF;

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

942:
943: WHEN OTHERS THEN
944:
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
947: THEN
948: FND_MSG_PUB.Add_Exc_Msg
949: ( G_PKG_NAME
950: , 'Update_Card_Supply_Status'

Line 948: FND_MSG_PUB.Add_Exc_Msg

944:
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
947: THEN
948: FND_MSG_PUB.Add_Exc_Msg
949: ( G_PKG_NAME
950: , 'Update_Card_Supply_Status'
951: );
952: END IF;

Line 1010: FND_MSG_PUB.initialize;

1006:
1007: -- Initialize message list.
1008:
1009: IF FND_API.to_Boolean(p_init_msg_list) THEN
1010: FND_MSG_PUB.initialize;
1011: END IF;
1012:
1013: mydebug('Calling Update_Card_Supply_Status 2');
1014: Update_Card_Supply_Status(X_Return_Status => l_Return_Status,

Line 1033: FND_MSG_PUB.Count_And_Get

1029: COMMIT WORK;
1030: END IF;
1031:
1032: -- Standard call to get message count and if count is 1, get message info.
1033: FND_MSG_PUB.Count_And_Get
1034: ( p_count => x_msg_count ,
1035: p_data => x_msg_data
1036: );
1037:

Line 1043: FND_MSG_PUB.Count_And_Get

1039:
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: ROLLBACK TO KANBAN_PVT;
1042: x_return_status := FND_API.G_RET_STS_ERROR ;
1043: FND_MSG_PUB.Count_And_Get
1044: ( p_count => x_msg_count ,
1045: p_data => x_msg_data
1046: );
1047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1050: FND_MSG_PUB.Count_And_Get

1046: );
1047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1048: ROLLBACK TO KANBAN_PVT;
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1050: FND_MSG_PUB.Count_And_Get
1051: ( p_count => x_msg_count ,
1052: p_data => x_msg_data
1053: );
1054:

Line 1058: IF FND_MSG_PUB.Check_Msg_Level

1054:
1055: WHEN OTHERS THEN
1056: ROLLBACK TO KANBAN_PVT;
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,

Line 1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1055: WHEN OTHERS THEN
1056: ROLLBACK TO KANBAN_PVT;
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,
1063: l_api_name

Line 1061: FND_MSG_PUB.Add_Exc_Msg

1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,
1063: l_api_name
1064: );
1065: END IF;

Line 1066: FND_MSG_PUB.Count_And_Get

1062: ( G_PKG_NAME ,
1063: l_api_name
1064: );
1065: END IF;
1066: FND_MSG_PUB.Count_And_Get
1067: ( p_count => x_msg_count ,
1068: p_data => x_msg_data
1069: );
1070:

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

1105:
1106: WHEN OTHERS THEN
1107:
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1110: THEN
1111: FND_MSG_PUB.Add_Exc_Msg
1112: ( G_PKG_NAME
1113: , 'Update_Card_Supply_Status'

Line 1111: FND_MSG_PUB.Add_Exc_Msg

1107:
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1110: THEN
1111: FND_MSG_PUB.Add_Exc_Msg
1112: ( G_PKG_NAME
1113: , 'Update_Card_Supply_Status'
1114: );
1115: END IF;

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

1143: When Too_many_rows Then
1144: return TRUE;
1145: When Others Then
1146:
1147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1148: THEN
1149: FND_MSG_PUB.Add_Exc_Msg
1150: ( G_PKG_NAME
1151: , 'Valid_kanban_Cards_exist'

Line 1149: FND_MSG_PUB.Add_Exc_Msg

1145: When Others Then
1146:
1147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1148: THEN
1149: FND_MSG_PUB.Add_Exc_Msg
1150: ( G_PKG_NAME
1151: , 'Valid_kanban_Cards_exist'
1152: );
1153: END IF;

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

1240:
1241: When Too_many_rows Then
1242: return 0; -------Cards with status wait/inprocess exists
1243: When Others Then
1244: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1245: THEN
1246: FND_MSG_PUB.Add_Exc_Msg
1247: ( G_PKG_NAME
1248: , 'Diff_Qty_Kanban_Cards_Exist'

Line 1246: FND_MSG_PUB.Add_Exc_Msg

1242: return 0; -------Cards with status wait/inprocess exists
1243: When Others Then
1244: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1245: THEN
1246: FND_MSG_PUB.Add_Exc_Msg
1247: ( G_PKG_NAME
1248: , 'Diff_Qty_Kanban_Cards_Exist'
1249: );
1250: END IF;

Line 1398: FND_MSG_PUB.Add_Exc_Msg

1394: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_CARD_NOT_FOUND');
1395: FND_MESSAGE.SET_TOKEN('CARDID',to_char(p_kanban_id) );
1396: RETURN FALSE;
1397: When OTHERS then
1398: FND_MSG_PUB.Add_Exc_Msg
1399: ( G_PKG_NAME
1400: , 'Valid_Production_Kanban_Card'
1401: );
1402: RETURN FALSE;

Line 1458: FND_MSG_PUB.Add_Exc_Msg

1454: return FALSE;
1455: When Too_many_rows Then
1456: return TRUE;
1457: When Others Then
1458: FND_MSG_PUB.Add_Exc_Msg
1459: ( G_PKG_NAME
1460: , 'Valid_Prod_kanban_Card'
1461: );
1462: return FALSE;

Line 1515: FND_MSG_PUB.initialize;

1511: l_temp NUMBER;
1512: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1513: BEGIN
1514:
1515: FND_MSG_PUB.initialize;
1516: l_kanban_Card_tbl.Delete;
1517:
1518:
1519:

Line 1541: FND_MSG_PUB.Add;

1537: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1538: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1539: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1540: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1541: FND_MSG_PUB.Add;
1542:
1543: l_return_status := FND_API.G_RET_STS_ERROR;
1544:
1545: end if;

Line 1559: FND_MSG_PUB.Add;

1555: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1556: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1557: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1558: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1559: FND_MSG_PUB.Add;
1560: l_return_status := FND_API.G_RET_STS_ERROR;
1561:
1562: end if;
1563:

Line 1623: FND_MSG_PUB.Add_Exc_Msg ( 'INV_Kanban_PVT',l_error_msg );

1619: and kanban_card_number = l_Kanban_Card_Number;
1620: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_EXISTS');
1621: fnd_message.set_token ('ATTRIBUTE', 'Kanban Card Number'||l_Kanban_Card_Number);
1622: l_error_msg := FND_MESSAGE.GET;
1623: FND_MSG_PUB.Add_Exc_Msg ( 'INV_Kanban_PVT',l_error_msg );
1624: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1625: exception
1626: when others then
1627: null;

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

1714:
1715: WHEN OTHERS THEN
1716:
1717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: FND_MSG_PUB.Add_Exc_Msg
1721: ( G_PKG_NAME
1722: , 'Create_Kanban_Cards'

Line 1720: FND_MSG_PUB.Add_Exc_Msg

1716:
1717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: FND_MSG_PUB.Add_Exc_Msg
1721: ( G_PKG_NAME
1722: , 'Create_Kanban_Cards'
1723: );
1724: END IF;

Line 1763: FND_MSG_PUB.initialize;

1759:
1760: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1761: BEGIN
1762:
1763: FND_MSG_PUB.initialize;
1764: l_kanban_Card_tbl.Delete;
1765:
1766: IF(p_pull_sequence_rec.release_kanban_flag =2) THEN
1767: l_card_status := INV_Kanban_Pvt.G_Card_Status_Hold;

Line 1786: FND_MSG_PUB.Add;

1782: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1783: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1784: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1785: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1786: FND_MSG_PUB.Add;
1787:
1788: l_return_status := FND_API.G_RET_STS_ERROR;
1789:
1790: end if;

Line 1804: FND_MSG_PUB.Add;

1800: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1801: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1802: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1803: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1804: FND_MSG_PUB.Add;
1805: l_return_status := FND_API.G_RET_STS_ERROR;
1806:
1807: end if;
1808:

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

1918:
1919: WHEN OTHERS THEN
1920:
1921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1923: THEN
1924: FND_MSG_PUB.Add_Exc_Msg
1925: ( G_PKG_NAME
1926: , 'Create_Kanban_Cards'

Line 1924: FND_MSG_PUB.Add_Exc_Msg

1920:
1921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1923: THEN
1924: FND_MSG_PUB.Add_Exc_Msg
1925: ( G_PKG_NAME
1926: , 'Create_Kanban_Cards'
1927: );
1928: END IF;

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

2162:
2163: Raise FND_API.G_EXC_ERROR;
2164:
2165: WHEN OTHERS THEN
2166: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2167: THEN
2168: FND_MSG_PUB.Add_Exc_Msg
2169: ( G_PKG_NAME
2170: , 'Create_Requisition'

Line 2168: FND_MSG_PUB.Add_Exc_Msg

2164:
2165: WHEN OTHERS THEN
2166: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2167: THEN
2168: FND_MSG_PUB.Add_Exc_Msg
2169: ( G_PKG_NAME
2170: , 'Create_Requisition'
2171: );
2172: END IF;

Line 2364: FND_MSG_PUB.Add_Exc_Msg

2360: x_trolin_tbl => l_x_trolin_tbl
2361: );
2362:
2363: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2364: FND_MSG_PUB.Add_Exc_Msg
2365: ( G_PKG_NAME
2366: , 'Create_transfer_order'
2367: );
2368: RAISE FND_API.G_EXC_ERROR;

Line 2370: FND_MSG_PUB.Add_Exc_Msg

2366: , 'Create_transfer_order'
2367: );
2368: RAISE FND_API.G_EXC_ERROR;
2369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2370: FND_MSG_PUB.Add_Exc_Msg
2371: ( G_PKG_NAME
2372: , 'Create_transfer_order'
2373: );
2374: RAISE FND_API.G_EXC_ERROR;

Line 2405: FND_MSG_PUB.Add;

2401:
2402: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2403: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
2404: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2405: FND_MSG_PUB.Add;
2406: ELSE
2407: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2408: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2409: FND_MSG_PUB.Add;

Line 2409: FND_MSG_PUB.Add;

2405: FND_MSG_PUB.Add;
2406: ELSE
2407: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2408: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2409: FND_MSG_PUB.Add;
2410: END IF;
2411:
2412: END IF;
2413: /* End of fix for 3905884*/

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

2416: WHEN FND_API.G_EXC_ERROR THEN
2417: Raise FND_API.G_EXC_ERROR;
2418:
2419: WHEN OTHERS THEN
2420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2421: FND_MSG_PUB.Add_Exc_Msg
2422: ( G_PKG_NAME
2423: , 'Create_Transfer_Order'
2424: );

Line 2421: FND_MSG_PUB.Add_Exc_Msg

2417: Raise FND_API.G_EXC_ERROR;
2418:
2419: WHEN OTHERS THEN
2420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2421: FND_MSG_PUB.Add_Exc_Msg
2422: ( G_PKG_NAME
2423: , 'Create_Transfer_Order'
2424: );
2425: END IF;

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

2453: end if;
2454:
2455: exception
2456: WHEN OTHERS THEN
2457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2458: THEN
2459: FND_MSG_PUB.Add_Exc_Msg
2460: ( G_PKG_NAME
2461: , 'Launch_MLP'

Line 2459: FND_MSG_PUB.Add_Exc_Msg

2455: exception
2456: WHEN OTHERS THEN
2457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2458: THEN
2459: FND_MSG_PUB.Add_Exc_Msg
2460: ( G_PKG_NAME
2461: , 'Launch_MLP'
2462: );
2463: END IF;

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

2623:
2624: Raise FND_API.G_EXC_ERROR;
2625:
2626: WHEN OTHERS THEN
2627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2628: THEN
2629: FND_MSG_PUB.Add_Exc_Msg
2630: ( G_PKG_NAME
2631: , 'Create_Wip_Discrete'

Line 2629: FND_MSG_PUB.Add_Exc_Msg

2625:
2626: WHEN OTHERS THEN
2627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2628: THEN
2629: FND_MSG_PUB.Add_Exc_Msg
2630: ( G_PKG_NAME
2631: , 'Create_Wip_Discrete'
2632: );
2633: END IF;

Line 2669: FND_MSG_PUB.Add_Exc_Msg

2665: LINE_ID = p_kanban_card_rec_tbl(1).wip_line_id AND
2666: organization_id = p_kanban_card_rec_tbl(1).organization_id;
2667: exception
2668: When others then
2669: FND_MSG_PUB.Add_Exc_Msg
2670: ( G_PKG_NAME
2671: , 'Create Rep Sched|Wip Line Not Defined'
2672: );
2673: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2695: FND_MSG_PUB.Add_Exc_Msg

2691: rep_sched_exist := 'N';
2692: When TOO_MANY_ROWS then
2693: rep_sched_exist := 'Y';
2694: When others then
2695: FND_MSG_PUB.Add_Exc_Msg
2696: ( G_PKG_NAME
2697: , 'Create Rep Sched|checking existing Schedules'
2698: );
2699: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

2834: WHEN FND_API.G_EXC_ERROR THEN
2835: Raise FND_API.G_EXC_ERROR;
2836:
2837: WHEN OTHERS THEN
2838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2839: THEN
2840: FND_MSG_PUB.Add_Exc_Msg
2841: ( G_PKG_NAME
2842: , 'Create_Rep_Schedule'

Line 2840: FND_MSG_PUB.Add_Exc_Msg

2836:
2837: WHEN OTHERS THEN
2838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2839: THEN
2840: FND_MSG_PUB.Add_Exc_Msg
2841: ( G_PKG_NAME
2842: , 'Create_Rep_Schedule'
2843: );
2844: END IF;

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

2956:
2957: Raise FND_API.G_EXC_ERROR;
2958:
2959: WHEN OTHERS THEN
2960: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2961: THEN
2962: FND_MSG_PUB.Add_Exc_Msg
2963: ( G_PKG_NAME
2964: , 'Create_Flow_Schedule'

Line 2962: FND_MSG_PUB.Add_Exc_Msg

2958:
2959: WHEN OTHERS THEN
2960: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2961: THEN
2962: FND_MSG_PUB.Add_Exc_Msg
2963: ( G_PKG_NAME
2964: , 'Create_Flow_Schedule'
2965: );
2966: END IF;

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

3162:
3163: Raise FND_API.G_EXC_ERROR;
3164:
3165: WHEN OTHERS THEN
3166: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3167: THEN
3168: FND_MSG_PUB.Add_Exc_Msg
3169: ( G_PKG_NAME
3170: , 'Create_lot_based_job'

Line 3168: FND_MSG_PUB.Add_Exc_Msg

3164:
3165: WHEN OTHERS THEN
3166: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3167: THEN
3168: FND_MSG_PUB.Add_Exc_Msg
3169: ( G_PKG_NAME
3170: , 'Create_lot_based_job'
3171: );
3172: END IF;

Line 3207: FND_MSG_PUB.Add_Exc_Msg

3203: inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
3204: organization_id = p_kanban_card_rec_tbl(1).organization_id;
3205: exception
3206: when others then
3207: FND_MSG_PUB.Add_Exc_Msg
3208: ( G_PKG_NAME
3209: , 'Ist SQL stmt'
3210: );
3211: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3225: FND_MSG_PUB.Add_Exc_Msg

3221: exception
3222: when NO_DATA_FOUND then
3223: v_cfm_flag := 2;
3224: when others then
3225: FND_MSG_PUB.Add_Exc_Msg
3226: ( G_PKG_NAME
3227: , 'wip line id IS NULL'
3228: );
3229: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3285: FND_MSG_PUB.Add;

3281: exception
3282: when NO_DATA_FOUND then
3283: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
3284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
3285: FND_MSG_PUB.Add;
3286: Raise FND_API.G_EXC_ERROR;
3287: when others then
3288: FND_MSG_PUB.Add_Exc_Msg
3289: (G_PKG_NAME ,'wip line id IS NULL');

Line 3288: FND_MSG_PUB.Add_Exc_Msg

3284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
3285: FND_MSG_PUB.Add;
3286: Raise FND_API.G_EXC_ERROR;
3287: when others then
3288: FND_MSG_PUB.Add_Exc_Msg
3289: (G_PKG_NAME ,'wip line id IS NULL');
3290: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3291: end ;
3292: create_rep_schedule(p_kanban_card_rec_tbl, v_fixed_lead_time,

Line 3323: FND_MSG_PUB.Add_Exc_Msg

3319: exception
3320: when NO_DATA_FOUND then
3321: v_cfm_flag := 2;
3322: when others then
3323: FND_MSG_PUB.Add_Exc_Msg
3324: ( G_PKG_NAME
3325: , 'wip line id IS not NULL'
3326: );
3327: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

3376:
3377: Raise FND_API.G_EXC_ERROR;
3378:
3379: WHEN OTHERS THEN
3380: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3381: THEN
3382: FND_MSG_PUB.Add_Exc_Msg
3383: ( G_PKG_NAME
3384: , 'Create_Wip_Job'

Line 3382: FND_MSG_PUB.Add_Exc_Msg

3378:
3379: WHEN OTHERS THEN
3380: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3381: THEN
3382: FND_MSG_PUB.Add_Exc_Msg
3383: ( G_PKG_NAME
3384: , 'Create_Wip_Job'
3385: );
3386: END IF;

Line 3681: FND_MSG_PUB.Add;

3677: Then
3678: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3679: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
3680: End If;
3681: FND_MSG_PUB.Add;
3682: Raise FND_API.G_EXC_ERROR;
3683:
3684: WHEN FND_API.G_EXC_ERROR THEN
3685:

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

3685:
3686: Raise FND_API.G_EXC_ERROR;
3687:
3688: WHEN OTHERS THEN
3689: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3690: THEN
3691: FND_MSG_PUB.Add_Exc_Msg
3692: ( G_PKG_NAME
3693: , 'Create_Replenishment'

Line 3691: FND_MSG_PUB.Add_Exc_Msg

3687:
3688: WHEN OTHERS THEN
3689: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3690: THEN
3691: FND_MSG_PUB.Add_Exc_Msg
3692: ( G_PKG_NAME
3693: , 'Create_Replenishment'
3694: );
3695: END IF;

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

3892: WHEN OTHERS THEN
3893:
3894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3895:
3896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3897: THEN
3898: FND_MSG_PUB.Add_Exc_Msg
3899: ( G_PKG_NAME
3900: , 'Check_And_Create_Replenishment'

Line 3898: FND_MSG_PUB.Add_Exc_Msg

3894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3895:
3896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3897: THEN
3898: FND_MSG_PUB.Add_Exc_Msg
3899: ( G_PKG_NAME
3900: , 'Check_And_Create_Replenishment'
3901: );
3902: END IF;

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

3935: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3936:
3937: WHEN OTHERS THEN
3938:
3939: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3940: THEN
3941: FND_MSG_PUB.Add_Exc_Msg
3942: ( G_PKG_NAME
3943: , 'test'

Line 3941: FND_MSG_PUB.Add_Exc_Msg

3937: WHEN OTHERS THEN
3938:
3939: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3940: THEN
3941: FND_MSG_PUB.Add_Exc_Msg
3942: ( G_PKG_NAME
3943: , 'test'
3944: );
3945: END IF;

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

4004: x_att := NULL;
4005: x_err_code := -1;
4006: x_err_msg := Substr(Sqlerrm,1,255);
4007:
4008: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4009: THEN
4010: FND_MSG_PUB.Add_Exc_Msg
4011: ( G_PKG_NAME
4012: ,'return_att_quantity'

Line 4010: FND_MSG_PUB.Add_Exc_Msg

4006: x_err_msg := Substr(Sqlerrm,1,255);
4007:
4008: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4009: THEN
4010: FND_MSG_PUB.Add_Exc_Msg
4011: ( G_PKG_NAME
4012: ,'return_att_quantity'
4013: );
4014: END IF;

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

4043: x_max_asmbly_qty := NULL;
4044: x_error_code := -1;
4045: x_error_msg := Substr(Sqlerrm,1,255);
4046:
4047: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4048: THEN
4049: FND_MSG_PUB.Add_Exc_Msg
4050: ( G_PKG_NAME
4051: ,'return_max_kanban_asmbly_qty'

Line 4049: FND_MSG_PUB.Add_Exc_Msg

4045: x_error_msg := Substr(Sqlerrm,1,255);
4046:
4047: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4048: THEN
4049: FND_MSG_PUB.Add_Exc_Msg
4050: ( G_PKG_NAME
4051: ,'return_max_kanban_asmbly_qty'
4052: );
4053: END IF;

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

4152: WHEN OTHERS THEN
4153: x_error_code := -1;
4154: x_error_msg := Substr(Sqlerrm,1,255);
4155:
4156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4157: THEN
4158: FND_MSG_PUB.Add_Exc_Msg
4159: ( G_PKG_NAME
4160: ,'GET_KANBAN_REC_GRP_INFO'

Line 4158: FND_MSG_PUB.Add_Exc_Msg

4154: x_error_msg := Substr(Sqlerrm,1,255);
4155:
4156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4157: THEN
4158: FND_MSG_PUB.Add_Exc_Msg
4159: ( G_PKG_NAME
4160: ,'GET_KANBAN_REC_GRP_INFO'
4161: );
4162: END IF;