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 190: x_return_status := FND_API.G_RET_STS_SUCCESS;

186: SAVEPOINT invoke_writeoff_wf;
187: l_event_name := 'oracle.apps.iex.wrf.approvewriteoff';
188: l_api_name := 'invoke_writeoff_wf';
189: l_api_name_full := g_pkg_name || '.'||l_api_name;
190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191:
192: AddfailMsg(p_object => 'BEFORE CALLING WORKFLOW ', p_operation => 'CREATE');
193:
194: l_key := l_event_name ||'-'||p_request_id;

Line 266: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

262: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
263: EXCEPTION
264: WHEN OTHERS THEN
265: ROLLBACK TO invoke_writeoff_wf;
266: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
267: x_msg_count := l_msg_count ;
268: x_msg_data := l_msg_data ;
269: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_writeoff_wf');
270: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count

Line 319: x_return_status := FND_API.G_RET_STS_SUCCESS;

315: SAVEPOINT invoke_asset_mgr_wf;
316: l_event_name := 'oracle.apps.iex.wrf.terminatenotification';
317: l_api_name := 'invoke_asset_mgr_wf';
318: l_api_name_full := g_pkg_name || '.'||l_api_name;
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: AddfailMsg(p_object => 'BEFORE CALLING WORKFLOW ', p_operation => 'CREATE');
322:
323: l_key := l_event_name ||'-'||p_request_id;

Line 375: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

371: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
372: EXCEPTION
373: WHEN OTHERS THEN
374: ROLLBACK TO invoke_asset_mgr_wf;
375: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
376: x_msg_count := l_msg_count ;
377: x_msg_data := l_msg_data ;
378: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_asset_mgr_wf');
379: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count

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

425:
426: l_writeoff_obj_rec := p_writeoff_object_rec;
427: SAVEPOINT CREATE_WRITEOFFS;
428:
429: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME) then
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: END IF;
432:
433: FND_MSG_PUB.initialize;

Line 430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

426: l_writeoff_obj_rec := p_writeoff_object_rec;
427: SAVEPOINT CREATE_WRITEOFFS;
428:
429: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME) then
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: END IF;
432:
433: FND_MSG_PUB.initialize;
434: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 434: x_return_status := FND_API.G_RET_STS_SUCCESS;

430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: END IF;
432:
433: FND_MSG_PUB.initialize;
434: x_return_status := FND_API.G_RET_STS_SUCCESS;
435:
436: l_writeoff_obj_rec.writeoff_status := 'W';
437: l_writeoff_obj_rec.writeoff_type := p_writeoff_type;
438: l_writeoff_obj_rec.writeoff_type_id := p_object_id;

Line 455: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

451: iex_debug_pub.logmessage ('writeoff creation object ID '||
452: l_writeoff_object_id || 'status ' ||l_return_status);
453: END IF;
454:
455: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
456: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
457: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
458: iex_debug_pub.logmessage('Error' ||l_message);
459: END IF;

Line 460: raise FND_API.G_EXC_ERROR;

456: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
457: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
458: iex_debug_pub.logmessage('Error' ||l_message);
459: END IF;
460: raise FND_API.G_EXC_ERROR;
461:
462: ELSE
463: FND_MSG_PUB.initialize;
464: END IF;

Line 487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

483: ,x_msg_data => l_msg_data
484: ,xo_object_version_number =>l_object_version_number
485: );
486:
487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
488: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
490: iex_debug_pub.logmessage('Error' ||l_message);
491: END IF;

Line 492: raise FND_API.G_EXC_ERROR;

488: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
490: iex_debug_pub.logmessage('Error' ||l_message);
491: END IF;
492: raise FND_API.G_EXC_ERROR;
493: ELSE
494: FND_MSG_PUB.initialize;
495: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
496: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number

Line 501: IF FND_API.to_Boolean( p_commit ) THEN

497: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id);
498: end if;
499: END IF;
500:
501: IF FND_API.to_Boolean( p_commit ) THEN
502: COMMIT WORK;
503: END IF;
504:
505: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 508: WHEN FND_API.G_EXC_ERROR THEN

504:
505: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO CREATE_WRITEOFFS;
510: x_return_status := FND_API.G_RET_STS_ERROR ;
511: x_msg_count := l_msg_count ;
512: x_msg_data := l_msg_data ;

Line 510: x_return_status := FND_API.G_RET_STS_ERROR ;

506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO CREATE_WRITEOFFS;
510: x_return_status := FND_API.G_RET_STS_ERROR ;
511: x_msg_count := l_msg_count ;
512: x_msg_data := l_msg_data ;
513: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
514: p_data => x_msg_data);

Line 515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

511: x_msg_count := l_msg_count ;
512: x_msg_data := l_msg_data ;
513: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
514: p_data => x_msg_data);
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO CREATE_WRITEOFFS;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
518: x_msg_count := l_msg_count ;
519: x_msg_data := l_msg_data ;

Line 517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

513: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
514: p_data => x_msg_data);
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO CREATE_WRITEOFFS;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
518: x_msg_count := l_msg_count ;
519: x_msg_data := l_msg_data ;
520: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
521: p_data => x_msg_data);

Line 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

520: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
521: p_data => x_msg_data);
522: WHEN OTHERS THEN
523: ROLLBACK TO CREATE_WRITEOFFS;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
525: x_msg_count := l_msg_count ;
526: x_msg_data := l_msg_data ;
527: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
528: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 672: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

668: iex_debug_pub.logmessage ('okl_trx_ar_adjsts status ' ||l_return_status);
669: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);
670: END IF;
671:
672: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
673: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
674: -- IF PG_DEBUG <11 THEN
675: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
676: iex_debug_pub.logmessage('Error' ||l_message);

Line 682: --raise FND_API.G_EXC_ERROR;

678: wf_engine.SetItemAttrText(itemtype => itemtype,
679: itemkey => itemkey,
680: aname => 'ERROR_MESSAGE',
681: avalue => l_message);
682: --raise FND_API.G_EXC_ERROR;
683: result := wf_engine.eng_completed ||':'||wf_no;
684: return;
685:
686: ELSE

Line 760: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

756: ,p_ajlv_rec =>l_ajlv_rec
757: ,x_ajlv_rec =>x_ajlv_rec);
758:
759:
760: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
761: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
762: -- IF PG_DEBUG <11 THEN
763: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
764: iex_debug_pub.logmessage('Error' ||l_message);

Line 770: --raise FND_API.G_EXC_ERROR;

766: wf_engine.SetItemAttrText(itemtype => itemtype,
767: itemkey => itemkey,
768: aname => 'ERROR_MESSAGE',
769: avalue => l_message);
770: --raise FND_API.G_EXC_ERROR;
771: result := wf_engine.eng_completed ||':'||wf_no;
772: return;
773: ELSE
774: -- IF PG_DEBUG <11 THEN

Line 824: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

820: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
821: iex_debug_pub.logmessage ('After calling Okl Api and status'||l_return_status);
822: END IF;
823:
824: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
825: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
826: -- IF PG_DEBUG <11 THEN
827: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
828: iex_debug_pub.logmessage('Error' ||l_message);

Line 834: --raise FND_API.G_EXC_ERROR;

830: wf_engine.SetItemAttrText(itemtype => itemtype,
831: itemkey => itemkey,
832: aname => 'ERROR_MESSAGE',
833: avalue => l_message);
834: --raise FND_API.G_EXC_ERROR;
835: result := wf_engine.eng_completed ||':'||wf_no;
836: return;
837: ELSE
838: FND_MSG_PUB.initialize;

Line 859: --raise FND_API.G_EXC_ERROR;

855: END IF;
856:
857: AddfailMsg(p_object => 'Adjustments ',
858: p_operation => 'CREATE' );
859: --raise FND_API.G_EXC_ERROR;
860: result := wf_engine.eng_completed ||':'||wf_no;
861: return;
862: end if;
863:

Line 879: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

875: ,x_return_status =>l_return_status
876: ,x_msg_count =>l_msg_count
877: ,x_msg_data =>l_msg_data);
878:
879: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
880: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
881: -- IF PG_DEBUG <11 THEN
882: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
883: iex_debug_pub.logmessage('Error' ||l_message);

Line 889: --raise FND_API.G_EXC_ERROR;

885: wf_engine.SetItemAttrText(itemtype => itemtype,
886: itemkey => itemkey,
887: aname => 'ERROR_MESSAGE',
888: avalue => l_message);
889: --raise FND_API.G_EXC_ERROR;
890: result := wf_engine.eng_completed ||':'||wf_no;
891: return;
892: ELSE
893: FND_MSG_PUB.initialize;

Line 923: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

919: ,x_msg_count => l_msg_count
920: ,x_msg_data => l_msg_data
921: ,xo_object_version_number =>l_object_version_number);
922:
923: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
924: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
925: -- IF PG_DEBUG <11 THEN
926: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
927: iex_debug_pub.logmessage('Error' ||l_message);

Line 933: --raise FND_API.G_EXC_ERROR;

929: wf_engine.SetItemAttrText(itemtype => itemtype,
930: itemkey => itemkey,
931: aname => 'ERROR_MESSAGE',
932: avalue => l_message);
933: --raise FND_API.G_EXC_ERROR;
934: result := wf_engine.eng_completed ||':'||wf_no;
935: return;
936: ELSE
937: FND_MSG_PUB.initialize;

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

957: ,x_return_status => l_return_status
958: ,x_msg_count => l_msg_count
959: ,x_msg_data => l_msg_data );
960:
961: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
962: Get_Messages1 (l_msg_count,l_message);
963: -- IF PG_DEBUG < 11 THEN
964: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
965: iex_debug_pub.logmessage('Error after calling asset mgr WF' ||l_message);

Line 972: --raise FND_API.G_EXC_ERROR;

968: wf_engine.SetItemAttrText(itemtype => itemtype,
969: itemkey => itemkey,
970: aname => 'ERROR_MESSAGE',
971: avalue => l_message);
972: --raise FND_API.G_EXC_ERROR;
973: result := wf_engine.eng_completed ||':'||wf_no;
974: return;
975: ELSE
976: FND_MSG_PUB.initialize;

Line 984: WHEN FND_API.G_EXC_ERROR THEN

980:
981: result := wf_engine.eng_completed ||':'||wf_yes;
982:
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: --resultout := wf_engine.eng_completed ||':'||wf_no;
986: -- IF PG_DEBUG < 11 THEN
987: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
988: iex_debug_pub.logmessage('Error ' ||l_message);

Line 1102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1098: ,x_return_status =>l_return_status
1099: ,x_msg_count =>l_msg_count
1100: ,x_msg_data =>l_msg_data);
1101:
1102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1103: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1104: -- IF PG_DEBUG <11 THEN
1105: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1106: iex_debug_pub.logmessage('Error' ||l_message);

Line 1112: --raise FND_API.G_EXC_ERROR;

1108: wf_engine.SetItemAttrText(itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'ERROR_MESSAGE',
1111: avalue => l_message);
1112: --raise FND_API.G_EXC_ERROR;
1113: result := wf_engine.eng_completed ||':'||wf_no;
1114: return;
1115: ELSE
1116: FND_MSG_PUB.initialize;

Line 1141: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1137: ,x_msg_count => l_msg_count
1138: ,x_msg_data => l_msg_data
1139: ,xo_object_version_number => l_object_version_number);
1140:
1141: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1142: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1143: -- IF PG_DEBUG <11 THEN
1144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1145: iex_debug_pub.logmessage('Error' ||l_message||itemkey||itemtype);

Line 1152: --raise FND_API.G_EXC_ERROR;

1148: wf_engine.SetItemAttrText(itemtype => itemtype,
1149: itemkey => itemkey,
1150: aname => 'ERROR_MESSAGE',
1151: avalue => l_message);
1152: --raise FND_API.G_EXC_ERROR;
1153: result := wf_engine.eng_completed ||':'||wf_no;
1154: return;
1155:
1156: ELSE

Line 1163: WHEN FND_API.G_EXC_ERROR THEN

1159:
1160: result := wf_engine.eng_completed ||':'||wf_yes;
1161:
1162: EXCEPTION
1163: WHEN FND_API.G_EXC_ERROR THEN
1164: --resultout := wf_engine.eng_completed ||':'||wf_no;
1165: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1166: 'reject_writeoffs',
1167: itemtype,