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.AMS_WFCMPAPR_PVT dependencies on FND_API

Line 71: p_encoded => FND_API.G_FALSE,

67:
68: WHILE l_cnt < p_msg_count
69: LOOP
70: FND_MSG_PUB.Get(p_msg_index => l_cnt + 1,
71: p_encoded => FND_API.G_FALSE,
72: p_data => l_msg_data,
73: p_msg_index_out => l_msg_index ) ;
74: l_final_data := l_final_data ||l_msg_index||': '||l_msg_data||fnd_global.local_chr(10) ;
75: l_cnt := l_cnt + 1 ;

Line 107: PROCEDURE Create_WFreqest(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

103: -- 09/16/1999 ptendulk created
104: -- End of Comments
105:
106:
107: PROCEDURE Create_WFreqest(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER ,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_obj_id IN NUMBER,

Line 149: IF FND_API.to_boolean(p_init_msg_list) THEN

145: AMS_Utility_PVT.debug_message(l_full_name||': start');
146:
147: END IF;
148:
149: IF FND_API.to_boolean(p_init_msg_list) THEN
150: FND_MSG_PUB.initialize;
151: END IF;
152:
153:

Line 157: x_return_status := FND_API.G_RET_STS_SUCCESS;

153:
154: --
155: -- Initialize API return status to success
156: --
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:
159:
160: --
161: -- API body

Line 242: p_encoded => FND_API.G_FALSE

238: --
239: FND_MSG_PUB.Count_AND_Get
240: ( p_count => x_msg_count,
241: p_data => x_msg_data,
242: p_encoded => FND_API.G_FALSE
243: );
244:
245: IF (AMS_DEBUG_HIGH_ON) THEN
246:

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253:
254:
255: EXCEPTION
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258:
259: ROLLBACK TO Create_wfreq_PVT;
260: x_return_status := FND_API.G_RET_STS_ERROR ;
261:

Line 260: x_return_status := FND_API.G_RET_STS_ERROR ;

256:
257: WHEN FND_API.G_EXC_ERROR THEN
258:
259: ROLLBACK TO Create_wfreq_PVT;
260: x_return_status := FND_API.G_RET_STS_ERROR ;
261:
262: FND_MSG_PUB.Count_AND_Get
263: ( p_count => x_msg_count,
264: p_data => x_msg_data,

Line 265: p_encoded => FND_API.G_FALSE

261:
262: FND_MSG_PUB.Count_AND_Get
263: ( p_count => x_msg_count,
264: p_data => x_msg_data,
265: p_encoded => FND_API.G_FALSE
266: );
267:
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

265: p_encoded => FND_API.G_FALSE
266: );
267:
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270:
271: ROLLBACK TO Create_wfreq_PVT;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273:

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270:
271: ROLLBACK TO Create_wfreq_PVT;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273:
274: FND_MSG_PUB.Count_AND_Get
275: ( p_count => x_msg_count,
276: p_data => x_msg_data,

Line 277: p_encoded => FND_API.G_FALSE

273:
274: FND_MSG_PUB.Count_AND_Get
275: ( p_count => x_msg_count,
276: p_data => x_msg_data,
277: p_encoded => FND_API.G_FALSE
278: );
279:
280:
281: WHEN OTHERS THEN

Line 284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

280:
281: WHEN OTHERS THEN
282:
283: ROLLBACK TO Create_wfreq_PVT;
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
285:
286: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
287: THEN
288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 294: p_encoded => FND_API.G_FALSE

290:
291: FND_MSG_PUB.Count_AND_Get
292: ( p_count => x_msg_count,
293: p_data => x_msg_data,
294: p_encoded => FND_API.G_FALSE
295: );
296:
297: END Create_WFreqest;
298:

Line 1241: -- p_init_msg_list => FND_API.g_false,

1237:
1238: -- dbms_output.put_line('Update Campaign Stat Code : '||p_next_stat_code||'Status ID : '||l_next_stat_id) ;
1239: -- AMS_CAMPAIGN_PVT.Update_Campaign(
1240: -- p_api_version => l_api_version,
1241: -- p_init_msg_list => FND_API.g_false,
1242: -- p_commit => FND_API.g_false,
1243: -- p_validation_level => FND_API.g_valid_level_full,
1244: --
1245: -- x_return_status => x_return_status,

Line 1242: -- p_commit => FND_API.g_false,

1238: -- dbms_output.put_line('Update Campaign Stat Code : '||p_next_stat_code||'Status ID : '||l_next_stat_id) ;
1239: -- AMS_CAMPAIGN_PVT.Update_Campaign(
1240: -- p_api_version => l_api_version,
1241: -- p_init_msg_list => FND_API.g_false,
1242: -- p_commit => FND_API.g_false,
1243: -- p_validation_level => FND_API.g_valid_level_full,
1244: --
1245: -- x_return_status => x_return_status,
1246: -- x_msg_count => x_msg_count,

Line 1243: -- p_validation_level => FND_API.g_valid_level_full,

1239: -- AMS_CAMPAIGN_PVT.Update_Campaign(
1240: -- p_api_version => l_api_version,
1241: -- p_init_msg_list => FND_API.g_false,
1242: -- p_commit => FND_API.g_false,
1243: -- p_validation_level => FND_API.g_valid_level_full,
1244: --
1245: -- x_return_status => x_return_status,
1246: -- x_msg_count => x_msg_count,
1247: -- x_msg_data => x_msg_data,

Line 1271: -- p_init_msg_list => FND_API.g_false,

1267: -- l_delv_rec.object_version_number := p_object_version_number ;
1268: --
1269: -- AMS_DELIVERABLE_PVT.Update_Deliverable(
1270: -- p_api_version => l_api_version,
1271: -- p_init_msg_list => FND_API.g_false,
1272: -- p_commit => FND_API.g_false,
1273: -- p_validation_level => FND_API.g_valid_level_full,
1274: --
1275: -- x_return_status => x_return_status,

Line 1272: -- p_commit => FND_API.g_false,

1268: --
1269: -- AMS_DELIVERABLE_PVT.Update_Deliverable(
1270: -- p_api_version => l_api_version,
1271: -- p_init_msg_list => FND_API.g_false,
1272: -- p_commit => FND_API.g_false,
1273: -- p_validation_level => FND_API.g_valid_level_full,
1274: --
1275: -- x_return_status => x_return_status,
1276: -- x_msg_count => x_msg_count,

Line 1273: -- p_validation_level => FND_API.g_valid_level_full,

1269: -- AMS_DELIVERABLE_PVT.Update_Deliverable(
1270: -- p_api_version => l_api_version,
1271: -- p_init_msg_list => FND_API.g_false,
1272: -- p_commit => FND_API.g_false,
1273: -- p_validation_level => FND_API.g_valid_level_full,
1274: --
1275: -- x_return_status => x_return_status,
1276: -- x_msg_count => x_msg_count,
1277: -- x_msg_data => x_msg_data,

Line 1300: -- p_init_msg_list => FND_API.g_false,

1296: -- l_eveh_rec.user_status_id := l_next_stat_id ;
1297: --
1298: -- AMS_EVENTHEADER_PVT.Update_Event_Header(
1299: -- p_api_version => l_api_version,
1300: -- p_init_msg_list => FND_API.g_false,
1301: -- p_commit => FND_API.g_false,
1302: -- p_validation_level => FND_API.g_valid_level_full,
1303: --
1304: -- x_return_status => x_return_status,

Line 1301: -- p_commit => FND_API.g_false,

1297: --
1298: -- AMS_EVENTHEADER_PVT.Update_Event_Header(
1299: -- p_api_version => l_api_version,
1300: -- p_init_msg_list => FND_API.g_false,
1301: -- p_commit => FND_API.g_false,
1302: -- p_validation_level => FND_API.g_valid_level_full,
1303: --
1304: -- x_return_status => x_return_status,
1305: -- x_msg_count => x_msg_count,

Line 1302: -- p_validation_level => FND_API.g_valid_level_full,

1298: -- AMS_EVENTHEADER_PVT.Update_Event_Header(
1299: -- p_api_version => l_api_version,
1300: -- p_init_msg_list => FND_API.g_false,
1301: -- p_commit => FND_API.g_false,
1302: -- p_validation_level => FND_API.g_valid_level_full,
1303: --
1304: -- x_return_status => x_return_status,
1305: -- x_msg_count => x_msg_count,
1306: -- x_msg_data => x_msg_data,

Line 1329: -- p_init_msg_list => FND_API.g_false,

1325: -- l_eveo_rec.user_status_id := l_next_stat_id ;
1326: --
1327: -- AMS_EVENTOFFER_PVT.Update_Event_Offer(
1328: -- p_api_version => l_api_version,
1329: -- p_init_msg_list => FND_API.g_false,
1330: -- p_commit => FND_API.g_false,
1331: -- p_validation_level => FND_API.g_valid_level_full,
1332: --
1333: -- x_return_status => x_return_status,

Line 1330: -- p_commit => FND_API.g_false,

1326: --
1327: -- AMS_EVENTOFFER_PVT.Update_Event_Offer(
1328: -- p_api_version => l_api_version,
1329: -- p_init_msg_list => FND_API.g_false,
1330: -- p_commit => FND_API.g_false,
1331: -- p_validation_level => FND_API.g_valid_level_full,
1332: --
1333: -- x_return_status => x_return_status,
1334: -- x_msg_count => x_msg_count,

Line 1331: -- p_validation_level => FND_API.g_valid_level_full,

1327: -- AMS_EVENTOFFER_PVT.Update_Event_Offer(
1328: -- p_api_version => l_api_version,
1329: -- p_init_msg_list => FND_API.g_false,
1330: -- p_commit => FND_API.g_false,
1331: -- p_validation_level => FND_API.g_valid_level_full,
1332: --
1333: -- x_return_status => x_return_status,
1334: -- x_msg_count => x_msg_count,
1335: -- x_msg_data => x_msg_data,

Line 1342: Create_WFreqest(p_init_msg_list => FND_API.G_FALSE,

1338: -- ) ;
1339:
1340: END IF;
1341:
1342: Create_WFreqest(p_init_msg_list => FND_API.G_FALSE,
1343: x_return_status => x_return_status,
1344: x_msg_count => x_msg_count,
1345: x_msg_data => x_msg_data,
1346: p_obj_id => p_obj_id ,

Line 1406: p_init_msg_list => FND_API.g_false,

1402: -- AND object_attribute = p_obj_attr ;
1403:
1404: AMS_ObjectAttribute_PVT.Modify_Object_Attribute
1405: (p_api_version => 1.0 ,
1406: p_init_msg_list => FND_API.g_false,
1407: p_commit => FND_API.g_false,
1408: p_validation_level => FND_API.g_valid_level_full,
1409:
1410: x_return_status => x_return_status,

Line 1407: p_commit => FND_API.g_false,

1403:
1404: AMS_ObjectAttribute_PVT.Modify_Object_Attribute
1405: (p_api_version => 1.0 ,
1406: p_init_msg_list => FND_API.g_false,
1407: p_commit => FND_API.g_false,
1408: p_validation_level => FND_API.g_valid_level_full,
1409:
1410: x_return_status => x_return_status,
1411: x_msg_count => x_msg_count,

Line 1408: p_validation_level => FND_API.g_valid_level_full,

1404: AMS_ObjectAttribute_PVT.Modify_Object_Attribute
1405: (p_api_version => 1.0 ,
1406: p_init_msg_list => FND_API.g_false,
1407: p_commit => FND_API.g_false,
1408: p_validation_level => FND_API.g_valid_level_full,
1409:
1410: x_return_status => x_return_status,
1411: x_msg_count => x_msg_count,
1412: x_msg_data => x_msg_data,

Line 1579: x_return_status := FND_API.G_RET_STS_SUCCESS;

1575: -- dbms_output.put_line('In/ Rec : Stat_type :'||p_stat_type||' Orig_stat: '||p_orig_stat||' New Stat: '||p_new_stat) ;
1576: --
1577: -- Initialize the API Return Status to Success
1578: --
1579: x_return_status := FND_API.G_RET_STS_SUCCESS;
1580:
1581: --
1582: -- Take the System Statuses for the User Statuses
1583: --

Line 1602: x_return_status := FND_API.G_RET_STS_ERROR;

1598: -- Invalid Statuses
1599: --dbms_output.put_line('trigger_name is missing');
1600: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_NTF_INVALID_STAT_CODE');
1601: x_msg_data := FND_MESSAGE.Get;
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: -- If any errors happen abort API/Procedure.
1604: RETURN;
1605: END IF ;
1606: CLOSE c_stat_rule ;

Line 1847: IF l_return_status <> FND_API.G_ret_sts_success THEN

1843: END IF;
1844: -- dbms_output.put_line('Approval Required Ret Stat : '||l_return_status);
1845: -- dbms_output.put_line('Approval Type : '||l_appr_type);
1846: -- dbms_output.put_line('Approval Required : '||l_appr_req_flag);
1847: IF l_return_status <> FND_API.G_ret_sts_success THEN
1848: -- Approval process is errored out
1849: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1850: itemkey => itemkey,
1851: aname => 'AMS_ERROR_MSG',

Line 2759: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2755: x_msg_count => l_msg_count,
2756: x_msg_data => l_msg_data,
2757: x_return_status => l_return_status ) ;
2758:
2759: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2760: result := 'COMPLETE:SUCCESS' ;
2761: ELSE
2762: Handle_Err
2763: (p_itemtype => itemtype ,

Line 3905: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3901: x_msg_data => l_msg_data,
3902: x_return_status => l_return_status) ;
3903:
3904:
3905: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3906: result := 'COMPLETE:SUCCESS' ;
3907: ELSE
3908: Handle_Err
3909: (p_itemtype => itemtype ,

Line 4165: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4161: l_doc_type VARCHAR2(30);
4162: l_requester_id NUMBER ;
4163: l_appr_type_lookup VARCHAR2(30);
4164: l_sys_stat_code VARCHAR2(30);
4165: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4166:
4167: l_approver VARCHAR2(30);
4168: l_note VARCHAR2(2000);
4169:

Line 4245: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4241: x_msg_data => l_msg_data,
4242: x_return_status => l_return_status) ;
4243:
4244: END IF ;
4245: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4246: Handle_Err
4247: (p_itemtype => itemtype ,
4248: p_itemkey => itemkey ,
4249: p_msg_count => l_msg_count, -- Number of error Messages

Line 4266: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4262: x_msg_count => l_msg_count,
4263: x_msg_data => l_msg_data,
4264: x_return_status => l_return_status ) ;
4265:
4266: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4267: result := 'COMPLETE:SUCCESS' ;
4268: ELSE
4269: Handle_Err
4270: (p_itemtype => itemtype ,

Line 4295: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4291: x_msg_count => l_msg_count,
4292: x_msg_data => l_msg_data,
4293: x_return_status => l_return_status) ;
4294:
4295: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4296: -- Update the Attribute to show that Theme Approval is Completed
4297: IF l_appr_type_lookup = 'THEME' THEN
4298: Update_Attribute(p_obj_type => l_obj_type,
4299: p_obj_id => l_obj_id,

Line 4320: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4316: x_return_status => l_return_status) ;
4317:
4318: END IF;
4319:
4320: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4321: result := 'COMPLETE:SUCCESS' ;
4322: ELSE
4323: Handle_Err
4324: (p_itemtype => itemtype ,

Line 4413: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;

4409: l_msg_data VARCHAR2(2000);
4410: l_obj_id NUMBER ;
4411: l_obj_version_number NUMBER ;
4412: l_requester_id NUMBER ;
4413: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
4414: l_approver VARCHAR2(30);
4415: l_note VARCHAR2(2000);
4416: BEGIN
4417: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4481: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4477: x_msg_data => l_msg_data,
4478: x_return_status => l_return_status) ;
4479:
4480: END IF ;
4481: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4482: Handle_Err
4483: (p_itemtype => itemtype ,
4484: p_itemkey => itemkey ,
4485: p_msg_count => l_msg_count, -- Number of error Messages

Line 4506: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4502: x_msg_count => l_msg_count,
4503: x_msg_data => l_msg_data,
4504: x_return_status => l_return_status) ;
4505:
4506: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4507: result := 'COMPLETE:SUCCESS' ;
4508: ELSE
4509: Handle_Err
4510: (p_itemtype => itemtype ,

Line 4586: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;

4582: l_msg_data VARCHAR2(2000);
4583: l_obj_id NUMBER ;
4584: l_obj_version_number NUMBER ;
4585: l_sys_stat_code VARCHAR2(30);
4586: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
4587: l_approver VARCHAR2(30);
4588: l_note VARCHAR2(2000);
4589:
4590: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS

Line 4659: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4655: x_msg_data => l_msg_data,
4656: x_return_status => l_return_status) ;
4657:
4658: END IF ;
4659: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4660: Handle_Err
4661: (p_itemtype => itemtype ,
4662: p_itemkey => itemkey ,
4663: p_msg_count => l_msg_count, -- Number of error Messages

Line 4684: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4680: x_msg_count => l_msg_count,
4681: x_msg_data => l_msg_data,
4682: x_return_status => l_return_status) ;
4683:
4684: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4685: result := 'COMPLETE:SUCCESS' ;
4686: ELSE
4687: Handle_Err
4688: (p_itemtype => itemtype ,

Line 4954: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;

4950: l_obj_version_number NUMBER ;
4951: l_requester_id NUMBER ;
4952: l_doc_type VARCHAR2(30);
4953: l_sys_stat_code VARCHAR2(30);
4954: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
4955: l_approver VARCHAR2(30);
4956: l_note VARCHAR2(2000);
4957:
4958: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS

Line 5026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5022: x_msg_data => l_msg_data,
5023: x_return_status => l_return_status) ;
5024:
5025: END IF ;
5026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5027: Handle_Err
5028: (p_itemtype => itemtype ,
5029: p_itemkey => itemkey ,
5030: p_msg_count => l_msg_count, -- Number of error Messages

Line 5051: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5047: x_msg_count => l_msg_count,
5048: x_msg_data => l_msg_data,
5049: x_return_status => l_return_status) ;
5050:
5051: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5052: -- Update the Attribute to show that Theme Approval is Completed
5053: Update_Attribute(p_obj_type => l_obj_type,
5054: p_obj_id => l_obj_id,
5055: p_obj_attr => 'BAPL',

Line 5060: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5056: x_msg_count => l_msg_count,
5057: x_msg_data => l_msg_data,
5058: x_return_status => l_return_status) ;
5059:
5060: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5061: result := 'COMPLETE:SUCCESS' ;
5062: ELSE
5063: Handle_Err
5064: (p_itemtype => itemtype ,