DBA Data[Home] [Help]

APPS.EAM_WORKORDERBILLING_PVT dependencies on FND_MSG_PUB

Line 90: FND_MSG_PUB.initialize;

86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: END IF;
88: -- Initialize message list if p_init_msg_list is set to TRUE.
89: IF FND_API.to_Boolean( p_init_msg_list ) THEN
90: FND_MSG_PUB.initialize;
91: END IF;
92: -- Initialize API return status to success
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:

Line 105: FND_MSG_PUB.Add;

101: (p_ra_line.invoice_num is null) or
102: (p_ra_line.line_num is null)
103: then
104: FND_MESSAGE.SET_NAME('EAM', 'EAM_NOT_ENOUGH_PARAMS');
105: FND_MSG_PUB.Add;
106: RAISE FND_API.G_EXC_ERROR;
107: end if;
108:
109: l_stmt := 20;

Line 126: FND_MSG_PUB.Add;

122: where cust_account_id=p_ra_line.customer_id;
123:
124: if (l_count=0) then
125: FND_MESSAGE.SET_NAME('EAM', 'EAM_CUSTOMER_NOT_EXIST');
126: FND_MSG_PUB.Add;
127: RAISE FND_API.G_EXC_ERROR;
128: end if;
129:
130: -- validation 3: unit selling price * quantity = amount

Line 134: FND_MSG_PUB.Add;

130: -- validation 3: unit selling price * quantity = amount
131: if not (p_ra_line.unit_selling_price * p_ra_line.quantity = p_ra_line.billed_amount)
132: then
133: FND_MESSAGE.SET_NAME('EAM', 'EAM_RA_WRONG_AMOUNT');
134: FND_MSG_PUB.Add;
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
137:
138: l_stmt := 30;

Line 156: FND_MSG_PUB.Add;

152:
153: exception
154: when no_data_found then
155: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_ORG_ID');
156: FND_MSG_PUB.Add;
157: RAISE FND_API.G_EXC_ERROR;
158: end;
159:
160: -- get desc. of invoice

Line 171: FND_MSG_PUB.Add;

167: where uom_code = p_ra_line.uom_code;
168: exception
169: when no_data_found then
170: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_UOM_CODE');
171: FND_MSG_PUB.Add;
172: RAISE FND_API.G_EXC_ERROR;
173: end;
174:
175: l_stmt := 40;

Line 361: FND_MSG_PUB.Count_And_Get

357: IF FND_API.To_Boolean( p_commit ) THEN
358: COMMIT WORK;
359: END IF;
360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get
362: ( p_count => x_msg_count ,
363: p_data => x_msg_data
364: );
365: EXCEPTION

Line 369: FND_MSG_PUB.Count_And_Get

365: EXCEPTION
366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO insert_AR_Interface_PVT;
368: x_return_status := FND_API.G_RET_STS_ERROR ;
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count ,
371: p_data => x_msg_data
372: );
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 376: FND_MSG_PUB.Count_And_Get

372: );
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: ROLLBACK TO insert_AR_Interface_PVT;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
376: FND_MSG_PUB.Count_And_Get
377: ( p_count => x_msg_count ,
378: p_data => x_msg_data
379: );
380: WHEN OTHERS THEN

Line 383: IF FND_MSG_PUB.Check_Msg_Level

379: );
380: WHEN OTHERS THEN
381: ROLLBACK TO insert_AR_Interface_PVT;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: IF FND_MSG_PUB.Check_Msg_Level
384: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
385: THEN
386: FND_MSG_PUB.Add_Exc_Msg
387: ( G_PKG_NAME ,

Line 384: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

380: WHEN OTHERS THEN
381: ROLLBACK TO insert_AR_Interface_PVT;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: IF FND_MSG_PUB.Check_Msg_Level
384: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
385: THEN
386: FND_MSG_PUB.Add_Exc_Msg
387: ( G_PKG_NAME ,
388: l_api_name

Line 386: FND_MSG_PUB.Add_Exc_Msg

382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: IF FND_MSG_PUB.Check_Msg_Level
384: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
385: THEN
386: FND_MSG_PUB.Add_Exc_Msg
387: ( G_PKG_NAME ,
388: l_api_name
389: );
390: END IF;

Line 391: FND_MSG_PUB.Count_And_Get

387: ( G_PKG_NAME ,
388: l_api_name
389: );
390: END IF;
391: FND_MSG_PUB.Count_And_Get
392: ( p_count => x_msg_count ,
393: p_data => x_msg_data
394: );
395: END insert_AR_Interface;

Line 429: FND_MSG_PUB.initialize;

425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427: -- Initialize message list if p_init_msg_list is set to TRUE.
428: IF FND_API.to_Boolean( p_init_msg_list ) THEN
429: FND_MSG_PUB.initialize;
430: END IF;
431: -- Initialize API return status to success
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433: -- API body

Line 448: FND_MSG_PUB.Add;

444: --(p_wob_rec.invoice_line_number is null) or
445: (p_wob_rec.currency_code is null)
446: then
447: FND_MESSAGE.SET_NAME('EAM', 'EAM_WRONG_PARAM_COST_PL');
448: FND_MSG_PUB.Add;
449: RAISE FND_API.G_EXC_ERROR;
450: end if;
451:
452: -- get rounded amount

Line 568: FND_MSG_PUB.Count_And_Get

564: IF FND_API.To_Boolean( p_commit ) THEN
565: COMMIT WORK;
566: END IF;
567: -- Standard call to get message count and if count is 1, get message info.
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count ,
570: p_data => x_msg_data
571: );
572: EXCEPTION

Line 576: FND_MSG_PUB.Count_And_Get

572: EXCEPTION
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO insert_WO_Table_PVT;
575: x_return_status := FND_API.G_RET_STS_ERROR ;
576: FND_MSG_PUB.Count_And_Get
577: ( p_count => x_msg_count ,
578: p_data => x_msg_data
579: );
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 583: FND_MSG_PUB.Count_And_Get

579: );
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: ROLLBACK TO insert_WO_Table_PVT;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583: FND_MSG_PUB.Count_And_Get
584: ( p_count => x_msg_count ,
585: p_data => x_msg_data
586: );
587: WHEN OTHERS THEN

Line 590: IF FND_MSG_PUB.Check_Msg_Level

586: );
587: WHEN OTHERS THEN
588: ROLLBACK TO insert_WO_Table_PVT;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: IF FND_MSG_PUB.Check_Msg_Level
591: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME ,

Line 591: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

587: WHEN OTHERS THEN
588: ROLLBACK TO insert_WO_Table_PVT;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: IF FND_MSG_PUB.Check_Msg_Level
591: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME ,
595: l_api_name

Line 593: FND_MSG_PUB.Add_Exc_Msg

589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: IF FND_MSG_PUB.Check_Msg_Level
591: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME ,
595: l_api_name
596: );
597: END IF;

Line 598: FND_MSG_PUB.Count_And_Get

594: ( G_PKG_NAME ,
595: l_api_name
596: );
597: END IF;
598: FND_MSG_PUB.Count_And_Get
599: ( p_count => x_msg_count ,
600: p_data => x_msg_data
601: );
602: END insert_WOB_Table;

Line 667: FND_MSG_PUB.initialize;

663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;
665: -- Initialize message list if p_init_msg_list is set to TRUE.
666: IF FND_API.to_Boolean( p_init_msg_list ) THEN
667: FND_MSG_PUB.initialize;
668: END IF;
669: -- Initialize API return status to success
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671: -- API body

Line 717: FND_MSG_PUB.Add;

713: , X_msg_data => l_msg_data);
714:
715: if (l_return_status='E') then
716: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_PROJ_ID');
717: FND_MSG_PUB.Add;
718: RAISE FND_API.G_EXC_ERROR;
719: end if;
720:
721:

Line 822: FND_MSG_PUB.Count_And_Get

818: IF FND_API.To_Boolean( p_commit ) THEN
819: COMMIT WORK;
820: END IF;
821: -- Standard call to get message count and if count is 1, get message info.
822: FND_MSG_PUB.Count_And_Get
823: ( p_count => x_msg_count ,
824: p_data => x_msg_data
825: );
826: EXCEPTION

Line 830: FND_MSG_PUB.Count_And_Get

826: EXCEPTION
827: WHEN FND_API.G_EXC_ERROR THEN
828: ROLLBACK TO insert_PAEvent_Table_PVT;
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: FND_MSG_PUB.Count_And_Get
831: ( p_count => x_msg_count ,
832: p_data => x_msg_data
833: );
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 837: FND_MSG_PUB.Count_And_Get

833: );
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: ROLLBACK TO insert_PAEvent_Table_PVT;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
837: FND_MSG_PUB.Count_And_Get
838: ( p_count => x_msg_count ,
839: p_data => x_msg_data
840: );
841: WHEN OTHERS THEN

Line 844: IF FND_MSG_PUB.Check_Msg_Level

840: );
841: WHEN OTHERS THEN
842: ROLLBACK TO insert_PAEvent_Table_PVT;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: IF FND_MSG_PUB.Check_Msg_Level
845: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg
848: ( G_PKG_NAME ,

Line 845: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

841: WHEN OTHERS THEN
842: ROLLBACK TO insert_PAEvent_Table_PVT;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: IF FND_MSG_PUB.Check_Msg_Level
845: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg
848: ( G_PKG_NAME ,
849: l_api_name

Line 847: FND_MSG_PUB.Add_Exc_Msg

843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: IF FND_MSG_PUB.Check_Msg_Level
845: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg
848: ( G_PKG_NAME ,
849: l_api_name
850: );
851: END IF;

Line 852: FND_MSG_PUB.Count_And_Get

848: ( G_PKG_NAME ,
849: l_api_name
850: );
851: END IF;
852: FND_MSG_PUB.Count_And_Get
853: ( p_count => x_msg_count ,
854: p_data => x_msg_data
855: );
856: END insert_PAEvent_Table;