DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on FND_MSG_PUB

Line 22: fnd_msg_pub.add;

18: BEGIN
19: fnd_message.set_name('IEX', 'IEX_FAILED_OPERATION');
20: fnd_message.set_token('OBJECT', p_object);
21: fnd_message.set_token('UPDATE', p_operation);
22: fnd_msg_pub.add;
23:
24: END AddfailMsg;
25:
26: PROCEDURE Get_Messages ( p_message_count IN NUMBER, x_message OUT nocopy VARCHAR2) IS

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 111: fnd_msg_pub.get(p_data => l_msg_data,

107: BEGIN
108: iex_debug_pub.logmessage ( 'in get message routine');
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

Line 114: p_msg_index => fnd_msg_pub.g_next);

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
118: l_msg_list := l_msg_list || l_new_line || l_msg_data;

Line 248: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

244: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
245: iex_debug_pub.logmessage ('Successfully launched writeoff workflow');
246: END IF;
247:
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;

Line 255: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_writeoff_wf');

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
257: ,p_data => x_msg_data);
258: End invoke_writeoff_wf;
259:

Line 256: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count

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
257: ,p_data => x_msg_data);
258: End invoke_writeoff_wf;
259:
260:

Line 350: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

346: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
347: iex_debug_pub.logmessage ('Successfully launched asset mgr workflow');
348: END IF;
349:
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;

Line 357: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_asset_mgr_wf');

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
359: ,p_data => x_msg_data);
360: End invoke_asset_mgr_wf;
361:

Line 358: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count

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
359: ,p_data => x_msg_data);
360: End invoke_asset_mgr_wf;
361:
362:

Line 412: FND_MSG_PUB.initialize;

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;
414:
415: l_writeoff_obj_rec.writeoff_status := 'W';
416: l_writeoff_obj_rec.writeoff_type := p_writeoff_type;

Line 442: FND_MSG_PUB.initialize;

438: END IF;
439: raise FND_API.G_EXC_ERROR;
440:
441: ELSE
442: FND_MSG_PUB.initialize;
443: END IF;
444:
445: AddfailMsg( p_object => 'Writeoffs ', p_operation => 'UPDATE' );
446:

Line 473: FND_MSG_PUB.initialize;

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
476: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id);
477: end if;

Line 484: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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);
485:
486: EXCEPTION
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO CREATE_WRITEOFFS;

Line 492: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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

Line 499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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);
501: WHEN OTHERS THEN
502: ROLLBACK TO CREATE_WRITEOFFS;
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 506: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);

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,
508: p_data => x_msg_data);
509:
510: END create_writeoffs;

Line 507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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,
508: p_data => x_msg_data);
509:
510: END create_writeoffs;
511:

Line 667: FND_MSG_PUB.initialize;

663: result := wf_engine.eng_completed ||':'||wf_no;
664: return;
665:
666: ELSE
667: FND_MSG_PUB.initialize;
668: END IF;
669:
670: --else insert of okl_trx_ar_adjsts_b is successful we can go to
671: --the third step of populating the okl_txl_adjsts_lns_b tables

Line 703: fnd_msg_pub.add;

699: where id=i.contract_id;
700:
701: fnd_message.set_name('IEX', 'IEX_WRITEOFFOBJ_CODE_COMB');
702: fnd_message.set_token('CONTRACT_NUMBER', l_contract_number);
703: fnd_msg_pub.add;
704: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
705: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
706: iex_debug_pub.logmessage('Error' ||l_message);
707: END IF;

Line 760: FND_MSG_PUB.initialize;

756: iex_debug_pub.logmessage ('okl_txl_adjsts_lns status '
757: ||l_return_status || ' Id ' ||
758: x_ajlv_rec.id);
759: END IF;
760: FND_MSG_PUB.initialize;
761: END IF;
762:
763: --else insert of okl_txl_adjsts_lns_b is successful we can go to
764: --the fourth step of calling okl_create_adjst_pvt

Line 818: FND_MSG_PUB.initialize;

814: --raise FND_API.G_EXC_ERROR;
815: result := wf_engine.eng_completed ||':'||wf_no;
816: return;
817: ELSE
818: FND_MSG_PUB.initialize;
819: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
820: IEx_debug_pub.logmessage ('After caling OKL Adj API and adj_id ' || x_adj_id);
821: end if;
822: END IF;

Line 873: FND_MSG_PUB.initialize;

869: --raise FND_API.G_EXC_ERROR;
870: result := wf_engine.eng_completed ||':'||wf_no;
871: return;
872: ELSE
873: FND_MSG_PUB.initialize;
874: -- IF PG_DEBUG <11 THEN
875: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
876: iex_debug_pub.logmessage('Finished updating iex_writeoffobjects');
877: END IF;

Line 917: FND_MSG_PUB.initialize;

913: --raise FND_API.G_EXC_ERROR;
914: result := wf_engine.eng_completed ||':'||wf_no;
915: return;
916: ELSE
917: FND_MSG_PUB.initialize;
918: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
919: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number
920: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id||
921: 'in approve writeoff procedure');

Line 956: FND_MSG_PUB.initialize;

952: --raise FND_API.G_EXC_ERROR;
953: result := wf_engine.eng_completed ||':'||wf_no;
954: return;
955: ELSE
956: FND_MSG_PUB.initialize;
957: END IF;
958: END IF; --object_type
959: END if ;--if l_ctr;
960:

Line 1096: FND_MSG_PUB.initialize;

1092: --raise FND_API.G_EXC_ERROR;
1093: result := wf_engine.eng_completed ||':'||wf_no;
1094: return;
1095: ELSE
1096: FND_MSG_PUB.initialize;
1097: END IF;
1098:
1099: END LOOP;
1100:

Line 1137: FND_MSG_PUB.initialize;

1133: result := wf_engine.eng_completed ||':'||wf_no;
1134: return;
1135:
1136: ELSE
1137: FND_MSG_PUB.initialize;
1138: END IF;
1139:
1140: result := wf_engine.eng_completed ||':'||wf_yes;
1141: