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.

[Home] [Help]

APPS.EAM_WORKORDERBILLING_PVT dependencies on FND_API

Line 13: -- Default = FND_API.G_FALSE

9: -- Pre-reqs : None.
10: -- Parameters :
11: -- IN : p_api_version IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_validation_level IN NUMBER Optional
17: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 15: -- Default = FND_API.G_FALSE

11: -- IN : p_api_version IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_validation_level IN NUMBER Optional
17: -- Default = FND_API.G_VALID_LEVEL_FULL
18: -- parameter1
19: -- parameter2

Line 17: -- Default = FND_API.G_VALID_LEVEL_FULL

13: -- Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_validation_level IN NUMBER Optional
17: -- Default = FND_API.G_VALID_LEVEL_FULL
18: -- parameter1
19: -- parameter2
20: -- .
21: -- .

Line 47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

43: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_WorkOrderBilling_PVT';
44:
45: PROCEDURE insert_AR_Interface
46: ( p_api_version IN NUMBER ,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
50: x_return_status OUT NOCOPY VARCHAR2 ,
51: x_msg_count OUT NOCOPY NUMBER ,

Line 48: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

44:
45: PROCEDURE insert_AR_Interface
46: ( p_api_version IN NUMBER ,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
50: x_return_status OUT NOCOPY VARCHAR2 ,
51: x_msg_count OUT NOCOPY NUMBER ,
52: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

45: PROCEDURE insert_AR_Interface
46: ( p_api_version IN NUMBER ,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
50: x_return_status OUT NOCOPY VARCHAR2 ,
51: x_msg_count OUT NOCOPY NUMBER ,
52: x_msg_data OUT NOCOPY VARCHAR2 ,
53: p_ra_line IN WO_Billing_RA_Rec_Type

Line 86: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

82: l_stmt := 10;
83: -- Standard Start of API savepoint
84: SAVEPOINT insert_AR_Interface_PVT;
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
87: p_api_version ,
88: l_api_name ,
89: G_PKG_NAME )
90: THEN

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: p_api_version ,
88: l_api_name ,
89: G_PKG_NAME )
90: THEN
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;

Line 94: IF FND_API.to_Boolean( p_init_msg_list ) THEN

90: THEN
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;

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
100: -- API body
101:
102: -- validation 0: All required fields have to be present.

Line 111: RAISE FND_API.G_EXC_ERROR;

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;
115:

Line 132: RAISE FND_API.G_EXC_ERROR;

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
136: if not (p_ra_line.unit_selling_price * p_ra_line.quantity = p_ra_line.billed_amount)

Line 140: RAISE FND_API.G_EXC_ERROR;

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;
144:

Line 162: RAISE FND_API.G_EXC_ERROR;

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
166: l_desc_of_invoice:='Invoice for work order #' || p_ra_line.wip_entity_id || ', ' || p_ra_line.wip_entity_name;

Line 177: RAISE FND_API.G_EXC_ERROR;

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;
181: -- get term id

Line 481: IF FND_API.To_Boolean( p_commit ) THEN

477:
478: -- End of API body.
479:
480: -- Standard check of p_commit.
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

Line 490: WHEN FND_API.G_EXC_ERROR THEN

486: ( p_count => x_msg_count ,
487: p_data => x_msg_data
488: );
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 ,

Line 492: x_return_status := FND_API.G_RET_STS_ERROR ;

488: );
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: );

Line 497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

495: p_data => x_msg_data
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: );

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: p_data => x_msg_data
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

Line 525: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

521:
522:
523: PROCEDURE insert_WOB_Table
524: ( p_api_version IN NUMBER ,
525: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
526: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
527: p_validation_level IN NUMBER :=
528: FND_API.G_VALID_LEVEL_FULL ,
529: x_return_status OUT NOCOPY VARCHAR2 ,

Line 526: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

522:
523: PROCEDURE insert_WOB_Table
524: ( p_api_version IN NUMBER ,
525: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
526: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
527: p_validation_level IN NUMBER :=
528: FND_API.G_VALID_LEVEL_FULL ,
529: x_return_status OUT NOCOPY VARCHAR2 ,
530: x_msg_count OUT NOCOPY NUMBER ,

Line 528: FND_API.G_VALID_LEVEL_FULL ,

524: ( p_api_version IN NUMBER ,
525: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
526: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
527: p_validation_level IN NUMBER :=
528: FND_API.G_VALID_LEVEL_FULL ,
529: x_return_status OUT NOCOPY VARCHAR2 ,
530: x_msg_count OUT NOCOPY NUMBER ,
531: x_msg_data OUT NOCOPY VARCHAR2 ,
532: p_wob_rec IN WO_Billing_Rec_Type

Line 544: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

540: BEGIN
541: -- Standard Start of API savepoint
542: SAVEPOINT insert_WO_Table_PVT;
543: -- Standard call to check for call compatibility.
544: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
545: p_api_version ,
546: l_api_name ,
547: G_PKG_NAME )
548: THEN

Line 549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

545: p_api_version ,
546: l_api_name ,
547: G_PKG_NAME )
548: THEN
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;

Line 552: IF FND_API.to_Boolean( p_init_msg_list ) THEN

548: THEN
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;

Line 556: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
558:
559: -- check all the "not null" fields
560: if (p_wob_rec.organization_id is null) or

Line 573: RAISE FND_API.G_EXC_ERROR;

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
577: select decode(c1.minimum_accountable_unit,

Line 688: IF FND_API.To_Boolean( p_commit ) THEN

684:
685:
686: -- End of API body.
687: -- Standard check of p_commit.
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

Line 697: WHEN FND_API.G_EXC_ERROR THEN

693: ( p_count => x_msg_count ,
694: p_data => x_msg_data
695: );
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 ,

Line 699: x_return_status := FND_API.G_RET_STS_ERROR ;

695: );
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: );

Line 704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

702: p_data => x_msg_data
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: );

Line 713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

709: p_data => x_msg_data
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

Line 733: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

729: /*
730: PROCEDURE insert_PAEvent_Table
731: ( p_api_version IN NUMBER
732: ,
733: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
734: p_commit IN VARCHAR2 := FND_API.G_FALSE
735: ,
736: p_validation_level IN NUMBER :=
737: FND_API.G_VALID_LEVEL_FULL

Line 734: p_commit IN VARCHAR2 := FND_API.G_FALSE

730: PROCEDURE insert_PAEvent_Table
731: ( p_api_version IN NUMBER
732: ,
733: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
734: p_commit IN VARCHAR2 := FND_API.G_FALSE
735: ,
736: p_validation_level IN NUMBER :=
737: FND_API.G_VALID_LEVEL_FULL
738: ,

Line 737: FND_API.G_VALID_LEVEL_FULL

733: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
734: p_commit IN VARCHAR2 := FND_API.G_FALSE
735: ,
736: p_validation_level IN NUMBER :=
737: FND_API.G_VALID_LEVEL_FULL
738: ,
739: x_return_status OUT NOCOPY VARCHAR2 ,
740: x_msg_count OUT NOCOPY NUMBER
741: ,

Line 782: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

778: BEGIN
779: -- Standard Start of API savepoint
780: SAVEPOINT insert_PAEvent_Table_PVT;
781: -- Standard call to check for call compatibility.
782: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
783: p_api_version ,
784: l_api_name ,
785: G_PKG_NAME )
786: THEN

Line 787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

783: p_api_version ,
784: l_api_name ,
785: G_PKG_NAME )
786: THEN
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;

Line 790: IF FND_API.to_Boolean( p_init_msg_list ) THEN

786: THEN
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;

Line 794: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
796:
797: /*
798: -- get event_num

Line 842: RAISE FND_API.G_EXC_ERROR;

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:
846: -- Get the rounded amount

Line 942: IF FND_API.To_Boolean( p_commit ) THEN

938:
939:
940: -- End of API body.
941: -- Standard check of p_commit.
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

Line 951: WHEN FND_API.G_EXC_ERROR THEN

947: ( p_count => x_msg_count ,
948: p_data => x_msg_data
949: );
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 ,

Line 953: x_return_status := FND_API.G_RET_STS_ERROR ;

949: );
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: );

Line 958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

956: p_data => x_msg_data
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: );

Line 967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

963: p_data => x_msg_data
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