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

Line 55: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);

51: BEGIN
52: iex_debug_pub.logmessage ( 'in get message routine');
53: FOR l_count in 1..p_message_count LOOP
54:
55: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
56: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
57: OPEN Get_Appl_Id (l_appl_short_name);
58: FETCH Get_Appl_Id into l_id;
59: CLOSE Get_Appl_Id;

Line 69: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);

65: FETCH Get_Message_Num into l_message_num;
66: CLOSE Get_Message_Num;
67: END IF;
68:
69: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
70:
71: IF NVL(l_message_num, 0) <> 0 then
72: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';
73: ELSE

Line 78: l_msg_list := l_msg_list || l_temp_msg || fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

74: l_temp_msg := NULL;
75: END IF;
76:
77: IF l_count = 1 then
78: l_msg_list := l_msg_list || l_temp_msg || fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
79: ELSE
80: l_msg_list := l_msg_list || l_temp_msg || fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
81: END IF;
82:

Line 80: l_msg_list := l_msg_list || l_temp_msg || fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);

76:
77: IF l_count = 1 then
78: l_msg_list := l_msg_list || l_temp_msg || fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
79: ELSE
80: l_msg_list := l_msg_list || l_temp_msg || fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
81: END IF;
82:
83: l_msg_list := l_msg_list || '';
84: iex_debug_pub.logmessage ( 'l_msg_lis'||l_msg_list);

Line 113: p_encoded => fnd_api.g_false,

109: FOR i IN 1..p_message_count
110: LOOP
111: fnd_msg_pub.get(p_data => l_msg_data,
112: p_msg_index_out => l_msg_count,
113: p_encoded => fnd_api.g_false,
114: p_msg_index => fnd_msg_pub.g_next);
115: IF i = 1 THEN
116: l_msg_list := l_msg_data;
117: ELSE

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: SAVEPOINT invoke_writeoff_wf;
181: l_event_name := 'oracle.apps.iex.wrf.approvewriteoff';
182: l_api_name := 'invoke_writeoff_wf';
183: l_api_name_full := g_pkg_name || '.'||l_api_name;
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: AddfailMsg(p_object => 'BEFORE CALLING WORKFLOW ', p_operation => 'CREATE');
187:
188: l_key := l_event_name ||'-'||p_request_id;

Line 252: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

248: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
249: EXCEPTION
250: WHEN OTHERS THEN
251: ROLLBACK TO invoke_writeoff_wf;
252: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
253: x_msg_count := l_msg_count ;
254: x_msg_data := l_msg_data ;
255: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_writeoff_wf');
256: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count

Line 304: x_return_status := FND_API.G_RET_STS_SUCCESS;

300: SAVEPOINT invoke_asset_mgr_wf;
301: l_event_name := 'oracle.apps.iex.wrf.terminatenotification';
302: l_api_name := 'invoke_asset_mgr_wf';
303: l_api_name_full := g_pkg_name || '.'||l_api_name;
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: AddfailMsg(p_object => 'BEFORE CALLING WORKFLOW ', p_operation => 'CREATE');
307:
308: l_key := l_event_name ||'-'||p_request_id;

Line 354: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

350: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
351: EXCEPTION
352: WHEN OTHERS THEN
353: ROLLBACK TO invoke_asset_mgr_wf;
354: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
355: x_msg_count := l_msg_count ;
356: x_msg_data := l_msg_data ;
357: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_asset_mgr_wf');
358: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count

Line 408: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME) then

404:
405: l_writeoff_obj_rec := p_writeoff_object_rec;
406: SAVEPOINT CREATE_WRITEOFFS;
407:
408: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME) then
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411:
412: FND_MSG_PUB.initialize;

Line 409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

405: l_writeoff_obj_rec := p_writeoff_object_rec;
406: SAVEPOINT CREATE_WRITEOFFS;
407:
408: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME) then
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411:
412: FND_MSG_PUB.initialize;
413: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 413: x_return_status := FND_API.G_RET_STS_SUCCESS;

409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411:
412: FND_MSG_PUB.initialize;
413: x_return_status := FND_API.G_RET_STS_SUCCESS;
414:
415: l_writeoff_obj_rec.writeoff_status := 'W';
416: l_writeoff_obj_rec.writeoff_type := p_writeoff_type;
417: l_writeoff_obj_rec.writeoff_type_id := p_object_id;

Line 434: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

430: iex_debug_pub.logmessage ('writeoff creation object ID '||
431: l_writeoff_object_id || 'status ' ||l_return_status);
432: END IF;
433:
434: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
435: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
436: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
437: iex_debug_pub.logmessage('Error' ||l_message);
438: END IF;

Line 439: raise FND_API.G_EXC_ERROR;

435: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
436: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
437: iex_debug_pub.logmessage('Error' ||l_message);
438: END IF;
439: raise FND_API.G_EXC_ERROR;
440:
441: ELSE
442: FND_MSG_PUB.initialize;
443: END IF;

Line 466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

462: ,x_msg_data => l_msg_data
463: ,xo_object_version_number =>l_object_version_number
464: );
465:
466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
467: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
468: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
469: iex_debug_pub.logmessage('Error' ||l_message);
470: END IF;

Line 471: raise FND_API.G_EXC_ERROR;

467: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
468: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
469: iex_debug_pub.logmessage('Error' ||l_message);
470: END IF;
471: raise FND_API.G_EXC_ERROR;
472: ELSE
473: FND_MSG_PUB.initialize;
474: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
475: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number

Line 480: IF FND_API.to_Boolean( p_commit ) THEN

476: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id);
477: end if;
478: END IF;
479:
480: IF FND_API.to_Boolean( p_commit ) THEN
481: COMMIT WORK;
482: END IF;
483:
484: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 487: WHEN FND_API.G_EXC_ERROR THEN

483:
484: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
485:
486: EXCEPTION
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO CREATE_WRITEOFFS;
489: x_return_status := FND_API.G_RET_STS_ERROR ;
490: x_msg_count := l_msg_count ;
491: x_msg_data := l_msg_data ;

Line 489: x_return_status := FND_API.G_RET_STS_ERROR ;

485:
486: EXCEPTION
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO CREATE_WRITEOFFS;
489: x_return_status := FND_API.G_RET_STS_ERROR ;
490: x_msg_count := l_msg_count ;
491: x_msg_data := l_msg_data ;
492: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
493: p_data => x_msg_data);

Line 494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

490: x_msg_count := l_msg_count ;
491: x_msg_data := l_msg_data ;
492: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
493: p_data => x_msg_data);
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: ROLLBACK TO CREATE_WRITEOFFS;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497: x_msg_count := l_msg_count ;
498: x_msg_data := l_msg_data ;

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

492: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
493: p_data => x_msg_data);
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: ROLLBACK TO CREATE_WRITEOFFS;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497: x_msg_count := l_msg_count ;
498: x_msg_data := l_msg_data ;
499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
500: p_data => x_msg_data);

Line 503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
500: p_data => x_msg_data);
501: WHEN OTHERS THEN
502: ROLLBACK TO CREATE_WRITEOFFS;
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: x_msg_count := l_msg_count ;
505: x_msg_data := l_msg_data ;
506: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 652: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

648: iex_debug_pub.logmessage ('okl_trx_ar_adjsts status ' ||l_return_status);
649: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);
650: END IF;
651:
652: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
653: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
654: -- IF PG_DEBUG <11 THEN
655: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
656: iex_debug_pub.logmessage('Error' ||l_message);

Line 662: --raise FND_API.G_EXC_ERROR;

658: wf_engine.SetItemAttrText(itemtype => itemtype,
659: itemkey => itemkey,
660: aname => 'ERROR_MESSAGE',
661: avalue => l_message);
662: --raise FND_API.G_EXC_ERROR;
663: result := wf_engine.eng_completed ||':'||wf_no;
664: return;
665:
666: ELSE

Line 740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

736: ,p_ajlv_rec =>l_ajlv_rec
737: ,x_ajlv_rec =>x_ajlv_rec);
738:
739:
740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
741: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
742: -- IF PG_DEBUG <11 THEN
743: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
744: iex_debug_pub.logmessage('Error' ||l_message);

Line 750: --raise FND_API.G_EXC_ERROR;

746: wf_engine.SetItemAttrText(itemtype => itemtype,
747: itemkey => itemkey,
748: aname => 'ERROR_MESSAGE',
749: avalue => l_message);
750: --raise FND_API.G_EXC_ERROR;
751: result := wf_engine.eng_completed ||':'||wf_no;
752: return;
753: ELSE
754: -- IF PG_DEBUG <11 THEN

Line 804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
801: iex_debug_pub.logmessage ('After calling Okl Api and status'||l_return_status);
802: END IF;
803:
804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
805: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
806: -- IF PG_DEBUG <11 THEN
807: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
808: iex_debug_pub.logmessage('Error' ||l_message);

Line 814: --raise FND_API.G_EXC_ERROR;

810: wf_engine.SetItemAttrText(itemtype => itemtype,
811: itemkey => itemkey,
812: aname => 'ERROR_MESSAGE',
813: avalue => l_message);
814: --raise FND_API.G_EXC_ERROR;
815: result := wf_engine.eng_completed ||':'||wf_no;
816: return;
817: ELSE
818: FND_MSG_PUB.initialize;

Line 839: --raise FND_API.G_EXC_ERROR;

835: END IF;
836:
837: AddfailMsg(p_object => 'Adjustments ',
838: p_operation => 'CREATE' );
839: --raise FND_API.G_EXC_ERROR;
840: result := wf_engine.eng_completed ||':'||wf_no;
841: return;
842: end if;
843:

Line 859: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

855: ,x_return_status =>l_return_status
856: ,x_msg_count =>l_msg_count
857: ,x_msg_data =>l_msg_data);
858:
859: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
860: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
861: -- IF PG_DEBUG <11 THEN
862: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
863: iex_debug_pub.logmessage('Error' ||l_message);

Line 869: --raise FND_API.G_EXC_ERROR;

865: wf_engine.SetItemAttrText(itemtype => itemtype,
866: itemkey => itemkey,
867: aname => 'ERROR_MESSAGE',
868: avalue => l_message);
869: --raise FND_API.G_EXC_ERROR;
870: result := wf_engine.eng_completed ||':'||wf_no;
871: return;
872: ELSE
873: FND_MSG_PUB.initialize;

Line 903: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

899: ,x_msg_count => l_msg_count
900: ,x_msg_data => l_msg_data
901: ,xo_object_version_number =>l_object_version_number);
902:
903: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
904: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
905: -- IF PG_DEBUG <11 THEN
906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
907: iex_debug_pub.logmessage('Error' ||l_message);

Line 913: --raise FND_API.G_EXC_ERROR;

909: wf_engine.SetItemAttrText(itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'ERROR_MESSAGE',
912: avalue => l_message);
913: --raise FND_API.G_EXC_ERROR;
914: result := wf_engine.eng_completed ||':'||wf_no;
915: return;
916: ELSE
917: FND_MSG_PUB.initialize;

Line 941: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

937: ,x_return_status => l_return_status
938: ,x_msg_count => l_msg_count
939: ,x_msg_data => l_msg_data );
940:
941: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
942: Get_Messages1 (l_msg_count,l_message);
943: -- IF PG_DEBUG < 11 THEN
944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
945: iex_debug_pub.logmessage('Error after calling asset mgr WF' ||l_message);

Line 952: --raise FND_API.G_EXC_ERROR;

948: wf_engine.SetItemAttrText(itemtype => itemtype,
949: itemkey => itemkey,
950: aname => 'ERROR_MESSAGE',
951: avalue => l_message);
952: --raise FND_API.G_EXC_ERROR;
953: result := wf_engine.eng_completed ||':'||wf_no;
954: return;
955: ELSE
956: FND_MSG_PUB.initialize;

Line 964: WHEN FND_API.G_EXC_ERROR THEN

960:
961: result := wf_engine.eng_completed ||':'||wf_yes;
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: --resultout := wf_engine.eng_completed ||':'||wf_no;
966: -- IF PG_DEBUG < 11 THEN
967: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
968: iex_debug_pub.logmessage('Error ' ||l_message);

Line 1082: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1078: ,x_return_status =>l_return_status
1079: ,x_msg_count =>l_msg_count
1080: ,x_msg_data =>l_msg_data);
1081:
1082: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1083: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1084: -- IF PG_DEBUG <11 THEN
1085: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1086: iex_debug_pub.logmessage('Error' ||l_message);

Line 1092: --raise FND_API.G_EXC_ERROR;

1088: wf_engine.SetItemAttrText(itemtype => itemtype,
1089: itemkey => itemkey,
1090: aname => 'ERROR_MESSAGE',
1091: avalue => l_message);
1092: --raise FND_API.G_EXC_ERROR;
1093: result := wf_engine.eng_completed ||':'||wf_no;
1094: return;
1095: ELSE
1096: FND_MSG_PUB.initialize;

Line 1121: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1117: ,x_msg_count => l_msg_count
1118: ,x_msg_data => l_msg_data
1119: ,xo_object_version_number => l_object_version_number);
1120:
1121: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1122: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1123: -- IF PG_DEBUG <11 THEN
1124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1125: iex_debug_pub.logmessage('Error' ||l_message||itemkey||itemtype);

Line 1132: --raise FND_API.G_EXC_ERROR;

1128: wf_engine.SetItemAttrText(itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'ERROR_MESSAGE',
1131: avalue => l_message);
1132: --raise FND_API.G_EXC_ERROR;
1133: result := wf_engine.eng_completed ||':'||wf_no;
1134: return;
1135:
1136: ELSE

Line 1143: WHEN FND_API.G_EXC_ERROR THEN

1139:
1140: result := wf_engine.eng_completed ||':'||wf_yes;
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: --resultout := wf_engine.eng_completed ||':'||wf_no;
1145: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1146: 'reject_writeoffs',
1147: itemtype,