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

Line 63: FND_MSG_PUB.initialize;

59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: ---------------------------------------------------------------
61: IF FND_API.to_Boolean(p_init_msg_list)
62: THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: --------------------------------------------
67: -- Initialize API return status to success

Line 225: FND_MSG_PUB.ADD;

221:
222: if(l_repair_group_id is null) then
223: FND_MESSAGE.Set_Name('CSD', 'CSD_API_REPAIR_GROUP_ID');
224: FND_MESSAGE.Set_Token('REPAIR_GROUP_ID',l_repair_group_id);
225: FND_MSG_PUB.ADD;
226: RAISE FND_API.G_EXC_ERROR;
227: end if;
228: -----------------------
229: -- insert into table

Line 302: FND_MSG_PUB.Count_And_Get

298:
299: --------------------------------------------------------------------------
300: -- Standard call to get message count and if count is 1, get message info.
301: --------------------------------------------------------------------------
302: FND_MSG_PUB.Count_And_Get
303: (p_count => x_msg_count,
304: p_data => x_msg_data
305: );
306:

Line 311: FND_MSG_PUB.Count_And_Get

307: EXCEPTION
308: WHEN FND_API.G_EXC_ERROR THEN
309: x_return_status := FND_API.G_RET_STS_ERROR ;
310: ROLLBACK TO create_repair_order_group;
311: FND_MSG_PUB.Count_And_Get
312: (p_count => x_msg_count,
313: p_data => x_msg_data );
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 317: FND_MSG_PUB.Count_And_Get

313: p_data => x_msg_data );
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
316: ROLLBACK TO create_repair_order_group;
317: FND_MSG_PUB.Count_And_Get
318: ( p_count => x_msg_count,
319: p_data => x_msg_data );
320: WHEN OTHERS THEN
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 323: IF FND_MSG_PUB.Check_Msg_Level

319: p_data => x_msg_data );
320: WHEN OTHERS THEN
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: ROLLBACK TO create_repair_order_group;
323: IF FND_MSG_PUB.Check_Msg_Level
324: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
325: THEN
326: FND_MSG_PUB.Add_Exc_Msg
327: (G_PKG_NAME ,

Line 324: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

320: WHEN OTHERS THEN
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: ROLLBACK TO create_repair_order_group;
323: IF FND_MSG_PUB.Check_Msg_Level
324: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
325: THEN
326: FND_MSG_PUB.Add_Exc_Msg
327: (G_PKG_NAME ,
328: l_api_name );

Line 326: FND_MSG_PUB.Add_Exc_Msg

322: ROLLBACK TO create_repair_order_group;
323: IF FND_MSG_PUB.Check_Msg_Level
324: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
325: THEN
326: FND_MSG_PUB.Add_Exc_Msg
327: (G_PKG_NAME ,
328: l_api_name );
329: END IF;
330: FND_MSG_PUB.Count_And_Get

Line 330: FND_MSG_PUB.Count_And_Get

326: FND_MSG_PUB.Add_Exc_Msg
327: (G_PKG_NAME ,
328: l_api_name );
329: END IF;
330: FND_MSG_PUB.Count_And_Get
331: (p_count => x_msg_count,
332: p_data => x_msg_data );
333:
334: END CREATE_REPAIR_GROUPS;

Line 399: FND_MSG_PUB.initialize;

395: -- Initialize message list if p_init_msg_list is set to TRUE.
396: --------------------------------------------------------------
397: IF FND_API.to_Boolean(p_init_msg_list)
398: THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: --------------------------------------------
403: -- Initialize API return status to success

Line 470: FND_MSG_PUB.ADD;

466:
467: IF repair_order_group%NOTFOUND THEN
468: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GROUP_MISSING');
469: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',l_repair_group_id);
470: FND_MSG_PUB.ADD;
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473:
474: IF repair_order_group%ISOPEN THEN

Line 497: FND_MSG_PUB.ADD;

493:
494:
495: FND_MESSAGE.SET_NAME('CSD','CSD_GRP_OBJ_VER_MISMATCH');
496: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',l_repair_group_id);
497: FND_MSG_PUB.ADD;
498: RAISE FND_API.G_EXC_ERROR;
499:
500: END IF;
501:

Line 559: FND_MSG_PUB.ADD;

555: (l_group_quantity <> x_repair_order_group_rec.group_quantity)) THEN
556:
557: FND_MESSAGE.SET_NAME('CSD','CSD_API_UPDATE_NOT_ALLOWED');
558: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',x_repair_order_group_rec.repair_group_id);
559: FND_MSG_PUB.ADD;
560:
561: RAISE FND_API.G_EXC_ERROR;
562:
563: END IF;

Line 632: FND_MSG_PUB.Count_And_Get

628:
629: --------------------------------------------------------------------------
630: -- Standard call to get message count and if count is 1, get message info.
631: --------------------------------------------------------------------------
632: FND_MSG_PUB.Count_And_Get
633: (p_count => x_msg_count,
634: p_data => x_msg_data
635: );
636:

Line 641: FND_MSG_PUB.Count_And_Get

637: EXCEPTION
638: WHEN FND_API.G_EXC_ERROR THEN
639: x_return_status := FND_API.G_RET_STS_ERROR ;
640: ROLLBACK TO update_group_repair_order;
641: FND_MSG_PUB.Count_And_Get
642: (p_count => x_msg_count,
643: p_data => x_msg_data );
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 647: FND_MSG_PUB.Count_And_Get

643: p_data => x_msg_data );
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
646: ROLLBACK TO update_group_repair_order;
647: FND_MSG_PUB.Count_And_Get
648: ( p_count => x_msg_count,
649: p_data => x_msg_data );
650: WHEN OTHERS THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 653: IF FND_MSG_PUB.Check_Msg_Level

649: p_data => x_msg_data );
650: WHEN OTHERS THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: ROLLBACK TO update_group_repair_order;
653: IF FND_MSG_PUB.Check_Msg_Level
654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
655: THEN
656: FND_MSG_PUB.Add_Exc_Msg
657: (G_PKG_NAME ,

Line 654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

650: WHEN OTHERS THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: ROLLBACK TO update_group_repair_order;
653: IF FND_MSG_PUB.Check_Msg_Level
654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
655: THEN
656: FND_MSG_PUB.Add_Exc_Msg
657: (G_PKG_NAME ,
658: l_api_name );

Line 656: FND_MSG_PUB.Add_Exc_Msg

652: ROLLBACK TO update_group_repair_order;
653: IF FND_MSG_PUB.Check_Msg_Level
654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
655: THEN
656: FND_MSG_PUB.Add_Exc_Msg
657: (G_PKG_NAME ,
658: l_api_name );
659: END IF;
660: FND_MSG_PUB.Count_And_Get

Line 660: FND_MSG_PUB.Count_And_Get

656: FND_MSG_PUB.Add_Exc_Msg
657: (G_PKG_NAME ,
658: l_api_name );
659: END IF;
660: FND_MSG_PUB.Count_And_Get
661: (p_count => x_msg_count,
662: p_data => x_msg_data );
663:
664: END UPDATE_REPAIR_GROUPS;

Line 717: FND_MSG_PUB.initialize;

713: -- Initialize message list if p_init_msg_list is set to TRUE.
714: --------------------------------------------------------------
715: IF FND_API.to_Boolean(p_init_msg_list)
716: THEN
717: FND_MSG_PUB.initialize;
718: END IF;
719:
720: --------------------------------------------
721: -- Initialize API return status to success

Line 780: FND_MSG_PUB.ADD;

776:
777: IF ( l_count > 0 ) then
778: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_ORDER_EXISTS');
779: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);
780: FND_MSG_PUB.ADD;
781:
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784: -----------------------------

Line 806: FND_MSG_PUB.Count_And_Get

802:
803: ---------------------------------------------------------------------------
804: -- Standard call to get message count and if count is 1, get message info.
805: ---------------------------------------------------------------------------
806: FND_MSG_PUB.Count_And_Get
807: (p_count => x_msg_count,
808: p_data => x_msg_data
809: );
810:

Line 815: FND_MSG_PUB.Count_And_Get

811: EXCEPTION
812: WHEN FND_API.G_EXC_ERROR THEN
813: x_return_status := FND_API.G_RET_STS_ERROR ;
814: ROLLBACK TO delete_repair_order_group;
815: FND_MSG_PUB.Count_And_Get
816: (p_count => x_msg_count,
817: p_data => x_msg_data );
818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 821: FND_MSG_PUB.Count_And_Get

817: p_data => x_msg_data );
818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
820: ROLLBACK TO delete_repair_order_group;
821: FND_MSG_PUB.Count_And_Get
822: ( p_count => x_msg_count,
823: p_data => x_msg_data );
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 827: IF FND_MSG_PUB.Check_Msg_Level

823: p_data => x_msg_data );
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
826: ROLLBACK TO delete_repair_order_group;
827: IF FND_MSG_PUB.Check_Msg_Level
828: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: FND_MSG_PUB.Add_Exc_Msg
831: (G_PKG_NAME ,

Line 828: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
826: ROLLBACK TO delete_repair_order_group;
827: IF FND_MSG_PUB.Check_Msg_Level
828: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: FND_MSG_PUB.Add_Exc_Msg
831: (G_PKG_NAME ,
832: l_api_name );

Line 830: FND_MSG_PUB.Add_Exc_Msg

826: ROLLBACK TO delete_repair_order_group;
827: IF FND_MSG_PUB.Check_Msg_Level
828: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: FND_MSG_PUB.Add_Exc_Msg
831: (G_PKG_NAME ,
832: l_api_name );
833: END IF;
834: FND_MSG_PUB.Count_And_Get

Line 834: FND_MSG_PUB.Count_And_Get

830: FND_MSG_PUB.Add_Exc_Msg
831: (G_PKG_NAME ,
832: l_api_name );
833: END IF;
834: FND_MSG_PUB.Count_And_Get
835: (p_count => x_msg_count,
836: p_data => x_msg_data );
837:
838: END DELETE_REPAIR_GROUPS;

Line 889: FND_MSG_PUB.initialize;

885: -- Initialize message list if p_init_msg_list is set to TRUE.
886: --------------------------------------------------------------
887: IF FND_API.to_Boolean(p_init_msg_list)
888: THEN
889: FND_MSG_PUB.initialize;
890: END IF;
891:
892: -------------------------------------------
893: -- Initialize API return status to success

Line 920: FND_MSG_PUB.Count_And_Get

916:
917: --------------------------------------------------------------------------
918: -- Standard call to get message count and if count is 1, get message info.
919: --------------------------------------------------------------------------
920: FND_MSG_PUB.Count_And_Get
921: (p_count => x_msg_count,
922: p_data => x_msg_data
923: );
924:

Line 929: FND_MSG_PUB.Count_And_Get

925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: x_return_status := FND_API.G_RET_STS_ERROR ;
928: ROLLBACK TO lock_repair_order_group;
929: FND_MSG_PUB.Count_And_Get
930: (p_count => x_msg_count,
931: p_data => x_msg_data );
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 935: FND_MSG_PUB.Count_And_Get

931: p_data => x_msg_data );
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934: ROLLBACK TO lock_repair_order_group;
935: FND_MSG_PUB.Count_And_Get
936: ( p_count => x_msg_count,
937: p_data => x_msg_data );
938: WHEN OTHERS THEN
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 941: IF FND_MSG_PUB.Check_Msg_Level

937: p_data => x_msg_data );
938: WHEN OTHERS THEN
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: ROLLBACK TO lock_repair_order_group;
941: IF FND_MSG_PUB.Check_Msg_Level
942: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
943: THEN
944: FND_MSG_PUB.Add_Exc_Msg
945: (G_PKG_NAME ,

Line 942: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

938: WHEN OTHERS THEN
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: ROLLBACK TO lock_repair_order_group;
941: IF FND_MSG_PUB.Check_Msg_Level
942: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
943: THEN
944: FND_MSG_PUB.Add_Exc_Msg
945: (G_PKG_NAME ,
946: l_api_name );

Line 944: FND_MSG_PUB.Add_Exc_Msg

940: ROLLBACK TO lock_repair_order_group;
941: IF FND_MSG_PUB.Check_Msg_Level
942: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
943: THEN
944: FND_MSG_PUB.Add_Exc_Msg
945: (G_PKG_NAME ,
946: l_api_name );
947: END IF;
948: FND_MSG_PUB.Count_And_Get

Line 948: FND_MSG_PUB.Count_And_Get

944: FND_MSG_PUB.Add_Exc_Msg
945: (G_PKG_NAME ,
946: l_api_name );
947: END IF;
948: FND_MSG_PUB.Count_And_Get
949: (p_count => x_msg_count,
950: p_data => x_msg_data );
951:
952: END LOCK_REPAIR_GROUPS;

Line 1025: FND_MSG_PUB.initialize;

1021: -- Initialize message list if p_init_msg_list is set to TRUE.
1022: --------------------------------------------------------------
1023: IF FND_API.to_Boolean(p_init_msg_list)
1024: THEN
1025: FND_MSG_PUB.initialize;
1026: END IF;
1027:
1028: -------------------------------------------
1029: -- Initialize API return status to success

Line 1103: FND_MSG_PUB.ADD;

1099: EXCEPTION
1100: WHEN NO_DATA_FOUND THEN
1101: FND_MESSAGE.SET_NAME('CSD','CSD_API_INVALID_RESOURCE');
1102: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',p_resource_id);
1103: FND_MSG_PUB.ADD;
1104:
1105: RAISE FND_API.G_EXC_ERROR;
1106: WHEN OTHERS THEN
1107: null;

Line 1155: FND_MSG_PUB.ADD;

1151: );
1152:
1153: If ( l_return_status <> 'S') then
1154: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_ORDER_UPD_FAIL');
1155: FND_MSG_PUB.ADD;
1156:
1157: RAISE FND_API.G_EXC_ERROR;
1158:
1159: End if;

Line 1315: FND_MSG_PUB.ADD;

1311:
1312: IF l_return_status <> 'S' THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR ;
1314: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GROUP_EST_FAIL');
1315: FND_MSG_PUB.ADD;
1316: ELSIF l_return_status = 'S' THEN
1317: x_object_version_number := l_group_ro_rec.object_version_number;
1318: END IF;
1319:

Line 1333: FND_MSG_PUB.Count_And_Get

1329:
1330: --------------------------------------------------------------------------
1331: -- Standard call to get message count and if count is 1, get message info.
1332: --------------------------------------------------------------------------
1333: FND_MSG_PUB.Count_And_Get
1334: (p_count => x_msg_count,
1335: p_data => x_msg_data
1336: );
1337:

Line 1342: FND_MSG_PUB.Count_And_Get

1338: EXCEPTION
1339: WHEN FND_API.G_EXC_ERROR THEN
1340: x_return_status := FND_API.G_RET_STS_ERROR ;
1341: ROLLBACK TO apply_to_group;
1342: FND_MSG_PUB.Count_And_Get
1343: (p_count => x_msg_count,
1344: p_data => x_msg_data );
1345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1348: FND_MSG_PUB.Count_And_Get

1344: p_data => x_msg_data );
1345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1347: ROLLBACK TO apply_to_group;
1348: FND_MSG_PUB.Count_And_Get
1349: ( p_count => x_msg_count,
1350: p_data => x_msg_data );
1351: WHEN OTHERS THEN
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1354: IF FND_MSG_PUB.Check_Msg_Level

1350: p_data => x_msg_data );
1351: WHEN OTHERS THEN
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1353: ROLLBACK TO apply_to_group;
1354: IF FND_MSG_PUB.Check_Msg_Level
1355: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1356: THEN
1357: FND_MSG_PUB.Add_Exc_Msg
1358: (G_PKG_NAME ,

Line 1355: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1351: WHEN OTHERS THEN
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1353: ROLLBACK TO apply_to_group;
1354: IF FND_MSG_PUB.Check_Msg_Level
1355: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1356: THEN
1357: FND_MSG_PUB.Add_Exc_Msg
1358: (G_PKG_NAME ,
1359: l_api_name );

Line 1357: FND_MSG_PUB.Add_Exc_Msg

1353: ROLLBACK TO apply_to_group;
1354: IF FND_MSG_PUB.Check_Msg_Level
1355: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1356: THEN
1357: FND_MSG_PUB.Add_Exc_Msg
1358: (G_PKG_NAME ,
1359: l_api_name );
1360: END IF;
1361: FND_MSG_PUB.Count_And_Get

Line 1361: FND_MSG_PUB.Count_And_Get

1357: FND_MSG_PUB.Add_Exc_Msg
1358: (G_PKG_NAME ,
1359: l_api_name );
1360: END IF;
1361: FND_MSG_PUB.Count_And_Get
1362: (p_count => x_msg_count,
1363: p_data => x_msg_data );
1364:
1365: END APPLY_TO_GROUP;