DBA Data[Home] [Help]

APPS.EAM_WORKORDERBILLING_PVT dependencies on FND_MSG_PUB

Line 95: FND_MSG_PUB.initialize;

91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_Boolean( p_init_msg_list ) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97: -- Initialize API return status to success
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:

Line 110: FND_MSG_PUB.Add;

106: (p_ra_line.invoice_num is null) or
107: (p_ra_line.line_num is null)
108: then
109: FND_MESSAGE.SET_NAME('EAM', 'EAM_NOT_ENOUGH_PARAMS');
110: FND_MSG_PUB.Add;
111: RAISE FND_API.G_EXC_ERROR;
112: end if;
113:
114: l_stmt := 20;

Line 131: FND_MSG_PUB.Add;

127: where cust_account_id=p_ra_line.customer_id;
128:
129: if (l_count=0) then
130: FND_MESSAGE.SET_NAME('EAM', 'EAM_CUSTOMER_NOT_EXIST');
131: FND_MSG_PUB.Add;
132: RAISE FND_API.G_EXC_ERROR;
133: end if;
134:
135: -- validation 3: unit selling price * quantity = amount

Line 139: FND_MSG_PUB.Add;

135: -- validation 3: unit selling price * quantity = amount
136: if not (p_ra_line.unit_selling_price * p_ra_line.quantity = p_ra_line.billed_amount)
137: then
138: FND_MESSAGE.SET_NAME('EAM', 'EAM_RA_WRONG_AMOUNT');
139: FND_MSG_PUB.Add;
140: RAISE FND_API.G_EXC_ERROR;
141: end if;
142:
143: l_stmt := 30;

Line 161: FND_MSG_PUB.Add;

157:
158: exception
159: when no_data_found then
160: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_ORG_ID');
161: FND_MSG_PUB.Add;
162: RAISE FND_API.G_EXC_ERROR;
163: end;
164:
165: -- get desc. of invoice

Line 176: FND_MSG_PUB.Add;

172: where uom_code = p_ra_line.uom_code;
173: exception
174: when no_data_found then
175: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_UOM_CODE');
176: FND_MSG_PUB.Add;
177: RAISE FND_API.G_EXC_ERROR;
178: end;
179:
180: l_stmt := 40;

Line 485: FND_MSG_PUB.Count_And_Get

481: IF FND_API.To_Boolean( p_commit ) THEN
482: COMMIT WORK;
483: END IF;
484: -- Standard call to get message count and if count is 1, get message info.
485: FND_MSG_PUB.Count_And_Get
486: ( p_count => x_msg_count ,
487: p_data => x_msg_data
488: );
489: EXCEPTION

Line 493: FND_MSG_PUB.Count_And_Get

489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO insert_AR_Interface_PVT;
492: x_return_status := FND_API.G_RET_STS_ERROR ;
493: FND_MSG_PUB.Count_And_Get
494: ( p_count => x_msg_count ,
495: p_data => x_msg_data
496: );
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 500: FND_MSG_PUB.Count_And_Get

496: );
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO insert_AR_Interface_PVT;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
500: FND_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count ,
502: p_data => x_msg_data
503: );
504: WHEN OTHERS THEN

Line 507: IF FND_MSG_PUB.Check_Msg_Level

503: );
504: WHEN OTHERS THEN
505: ROLLBACK TO insert_AR_Interface_PVT;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level
508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
509: THEN
510: FND_MSG_PUB.Add_Exc_Msg
511: ( G_PKG_NAME ,

Line 508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

504: WHEN OTHERS THEN
505: ROLLBACK TO insert_AR_Interface_PVT;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level
508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
509: THEN
510: FND_MSG_PUB.Add_Exc_Msg
511: ( G_PKG_NAME ,
512: l_api_name

Line 510: FND_MSG_PUB.Add_Exc_Msg

506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level
508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
509: THEN
510: FND_MSG_PUB.Add_Exc_Msg
511: ( G_PKG_NAME ,
512: l_api_name
513: );
514: END IF;

Line 515: FND_MSG_PUB.Count_And_Get

511: ( G_PKG_NAME ,
512: l_api_name
513: );
514: END IF;
515: FND_MSG_PUB.Count_And_Get
516: ( p_count => x_msg_count ,
517: p_data => x_msg_data
518: );
519: END insert_AR_Interface;

Line 553: FND_MSG_PUB.initialize;

549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: END IF;
551: -- Initialize message list if p_init_msg_list is set to TRUE.
552: IF FND_API.to_Boolean( p_init_msg_list ) THEN
553: FND_MSG_PUB.initialize;
554: END IF;
555: -- Initialize API return status to success
556: x_return_status := FND_API.G_RET_STS_SUCCESS;
557: -- API body

Line 572: FND_MSG_PUB.Add;

568: --(p_wob_rec.invoice_line_number is null) or
569: (p_wob_rec.currency_code is null)
570: then
571: FND_MESSAGE.SET_NAME('EAM', 'EAM_WRONG_PARAM_COST_PL');
572: FND_MSG_PUB.Add;
573: RAISE FND_API.G_EXC_ERROR;
574: end if;
575:
576: -- get rounded amount

Line 692: FND_MSG_PUB.Count_And_Get

688: IF FND_API.To_Boolean( p_commit ) THEN
689: COMMIT WORK;
690: END IF;
691: -- Standard call to get message count and if count is 1, get message info.
692: FND_MSG_PUB.Count_And_Get
693: ( p_count => x_msg_count ,
694: p_data => x_msg_data
695: );
696: EXCEPTION

Line 700: FND_MSG_PUB.Count_And_Get

696: EXCEPTION
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO insert_WO_Table_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR ;
700: FND_MSG_PUB.Count_And_Get
701: ( p_count => x_msg_count ,
702: p_data => x_msg_data
703: );
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 707: FND_MSG_PUB.Count_And_Get

703: );
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: ROLLBACK TO insert_WO_Table_PVT;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
707: FND_MSG_PUB.Count_And_Get
708: ( p_count => x_msg_count ,
709: p_data => x_msg_data
710: );
711: WHEN OTHERS THEN

Line 714: IF FND_MSG_PUB.Check_Msg_Level

710: );
711: WHEN OTHERS THEN
712: ROLLBACK TO insert_WO_Table_PVT;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
714: IF FND_MSG_PUB.Check_Msg_Level
715: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
716: THEN
717: FND_MSG_PUB.Add_Exc_Msg
718: ( G_PKG_NAME ,

Line 715: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

711: WHEN OTHERS THEN
712: ROLLBACK TO insert_WO_Table_PVT;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
714: IF FND_MSG_PUB.Check_Msg_Level
715: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
716: THEN
717: FND_MSG_PUB.Add_Exc_Msg
718: ( G_PKG_NAME ,
719: l_api_name

Line 717: FND_MSG_PUB.Add_Exc_Msg

713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
714: IF FND_MSG_PUB.Check_Msg_Level
715: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
716: THEN
717: FND_MSG_PUB.Add_Exc_Msg
718: ( G_PKG_NAME ,
719: l_api_name
720: );
721: END IF;

Line 722: FND_MSG_PUB.Count_And_Get

718: ( G_PKG_NAME ,
719: l_api_name
720: );
721: END IF;
722: FND_MSG_PUB.Count_And_Get
723: ( p_count => x_msg_count ,
724: p_data => x_msg_data
725: );
726: END insert_WOB_Table;

Line 791: FND_MSG_PUB.initialize;

787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;
789: -- Initialize message list if p_init_msg_list is set to TRUE.
790: IF FND_API.to_Boolean( p_init_msg_list ) THEN
791: FND_MSG_PUB.initialize;
792: END IF;
793: -- Initialize API return status to success
794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795: -- API body

Line 841: FND_MSG_PUB.Add;

837: , X_msg_data => l_msg_data);
838:
839: if (l_return_status='E') then
840: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_PROJ_ID');
841: FND_MSG_PUB.Add;
842: RAISE FND_API.G_EXC_ERROR;
843: end if;
844:
845:

Line 946: FND_MSG_PUB.Count_And_Get

942: IF FND_API.To_Boolean( p_commit ) THEN
943: COMMIT WORK;
944: END IF;
945: -- Standard call to get message count and if count is 1, get message info.
946: FND_MSG_PUB.Count_And_Get
947: ( p_count => x_msg_count ,
948: p_data => x_msg_data
949: );
950: EXCEPTION

Line 954: FND_MSG_PUB.Count_And_Get

950: EXCEPTION
951: WHEN FND_API.G_EXC_ERROR THEN
952: ROLLBACK TO insert_PAEvent_Table_PVT;
953: x_return_status := FND_API.G_RET_STS_ERROR ;
954: FND_MSG_PUB.Count_And_Get
955: ( p_count => x_msg_count ,
956: p_data => x_msg_data
957: );
958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 961: FND_MSG_PUB.Count_And_Get

957: );
958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
959: ROLLBACK TO insert_PAEvent_Table_PVT;
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
961: FND_MSG_PUB.Count_And_Get
962: ( p_count => x_msg_count ,
963: p_data => x_msg_data
964: );
965: WHEN OTHERS THEN

Line 968: IF FND_MSG_PUB.Check_Msg_Level

964: );
965: WHEN OTHERS THEN
966: ROLLBACK TO insert_PAEvent_Table_PVT;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
968: IF FND_MSG_PUB.Check_Msg_Level
969: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
970: THEN
971: FND_MSG_PUB.Add_Exc_Msg
972: ( G_PKG_NAME ,

Line 969: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

965: WHEN OTHERS THEN
966: ROLLBACK TO insert_PAEvent_Table_PVT;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
968: IF FND_MSG_PUB.Check_Msg_Level
969: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
970: THEN
971: FND_MSG_PUB.Add_Exc_Msg
972: ( G_PKG_NAME ,
973: l_api_name

Line 971: FND_MSG_PUB.Add_Exc_Msg

967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
968: IF FND_MSG_PUB.Check_Msg_Level
969: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
970: THEN
971: FND_MSG_PUB.Add_Exc_Msg
972: ( G_PKG_NAME ,
973: l_api_name
974: );
975: END IF;

Line 976: FND_MSG_PUB.Count_And_Get

972: ( G_PKG_NAME ,
973: l_api_name
974: );
975: END IF;
976: FND_MSG_PUB.Count_And_Get
977: ( p_count => x_msg_count ,
978: p_data => x_msg_data
979: );
980: END insert_PAEvent_Table;