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.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 3877: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3873: x_msg_data => l_msg_data,
3874: x_return_status => l_return_status) ;
3875:
3876:
3877: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3878: result := 'COMPLETE:SUCCESS' ;
3879: ELSE
3880: Handle_Err
3881: (p_itemtype => itemtype ,

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

4133: l_doc_type VARCHAR2(30);
4134: l_requester_id NUMBER ;
4135: l_appr_type_lookup VARCHAR2(30);
4136: l_sys_stat_code VARCHAR2(30);
4137: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4138:
4139: l_approver VARCHAR2(30);
4140: l_note VARCHAR2(2000);
4141:

Line 4217: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4213: x_msg_data => l_msg_data,
4214: x_return_status => l_return_status) ;
4215:
4216: END IF ;
4217: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4218: Handle_Err
4219: (p_itemtype => itemtype ,
4220: p_itemkey => itemkey ,
4221: p_msg_count => l_msg_count, -- Number of error Messages

Line 4238: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4234: x_msg_count => l_msg_count,
4235: x_msg_data => l_msg_data,
4236: x_return_status => l_return_status ) ;
4237:
4238: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4239: result := 'COMPLETE:SUCCESS' ;
4240: ELSE
4241: Handle_Err
4242: (p_itemtype => itemtype ,

Line 4267: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4263: x_msg_count => l_msg_count,
4264: x_msg_data => l_msg_data,
4265: x_return_status => l_return_status) ;
4266:
4267: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4268: -- Update the Attribute to show that Theme Approval is Completed
4269: IF l_appr_type_lookup = 'THEME' THEN
4270: Update_Attribute(p_obj_type => l_obj_type,
4271: p_obj_id => l_obj_id,

Line 4292: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4288: x_return_status => l_return_status) ;
4289:
4290: END IF;
4291:
4292: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4293: result := 'COMPLETE:SUCCESS' ;
4294: ELSE
4295: Handle_Err
4296: (p_itemtype => itemtype ,

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

4381: l_msg_data VARCHAR2(2000);
4382: l_obj_id NUMBER ;
4383: l_obj_version_number NUMBER ;
4384: l_requester_id NUMBER ;
4385: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
4386: l_approver VARCHAR2(30);
4387: l_note VARCHAR2(2000);
4388: BEGIN
4389: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4453: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4449: x_msg_data => l_msg_data,
4450: x_return_status => l_return_status) ;
4451:
4452: END IF ;
4453: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4454: Handle_Err
4455: (p_itemtype => itemtype ,
4456: p_itemkey => itemkey ,
4457: p_msg_count => l_msg_count, -- Number of error Messages

Line 4478: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4474: x_msg_count => l_msg_count,
4475: x_msg_data => l_msg_data,
4476: x_return_status => l_return_status) ;
4477:
4478: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4479: result := 'COMPLETE:SUCCESS' ;
4480: ELSE
4481: Handle_Err
4482: (p_itemtype => itemtype ,

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

4554: l_msg_data VARCHAR2(2000);
4555: l_obj_id NUMBER ;
4556: l_obj_version_number NUMBER ;
4557: l_sys_stat_code VARCHAR2(30);
4558: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
4559: l_approver VARCHAR2(30);
4560: l_note VARCHAR2(2000);
4561:
4562: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS

Line 4631: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4627: x_msg_data => l_msg_data,
4628: x_return_status => l_return_status) ;
4629:
4630: END IF ;
4631: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4632: Handle_Err
4633: (p_itemtype => itemtype ,
4634: p_itemkey => itemkey ,
4635: p_msg_count => l_msg_count, -- Number of error Messages

Line 4656: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4652: x_msg_count => l_msg_count,
4653: x_msg_data => l_msg_data,
4654: x_return_status => l_return_status) ;
4655:
4656: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4657: result := 'COMPLETE:SUCCESS' ;
4658: ELSE
4659: Handle_Err
4660: (p_itemtype => itemtype ,

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

4922: l_obj_version_number NUMBER ;
4923: l_requester_id NUMBER ;
4924: l_doc_type VARCHAR2(30);
4925: l_sys_stat_code VARCHAR2(30);
4926: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
4927: l_approver VARCHAR2(30);
4928: l_note VARCHAR2(2000);
4929:
4930: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS

Line 4998: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4994: x_msg_data => l_msg_data,
4995: x_return_status => l_return_status) ;
4996:
4997: END IF ;
4998: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4999: Handle_Err
5000: (p_itemtype => itemtype ,
5001: p_itemkey => itemkey ,
5002: p_msg_count => l_msg_count, -- Number of error Messages

Line 5023: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5019: x_msg_count => l_msg_count,
5020: x_msg_data => l_msg_data,
5021: x_return_status => l_return_status) ;
5022:
5023: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5024: -- Update the Attribute to show that Theme Approval is Completed
5025: Update_Attribute(p_obj_type => l_obj_type,
5026: p_obj_id => l_obj_id,
5027: p_obj_attr => 'BAPL',

Line 5032: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5028: x_msg_count => l_msg_count,
5029: x_msg_data => l_msg_data,
5030: x_return_status => l_return_status) ;
5031:
5032: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5033: result := 'COMPLETE:SUCCESS' ;
5034: ELSE
5035: Handle_Err
5036: (p_itemtype => itemtype ,