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 262: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

258: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
259: iex_debug_pub.logmessage ('Successfully launched writeoff workflow');
260: END IF;
261:
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;

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

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
271: ,p_data => x_msg_data);
272: End invoke_writeoff_wf;
273:

Line 270: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count

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
271: ,p_data => x_msg_data);
272: End invoke_writeoff_wf;
273:
274:

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

367: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
368: iex_debug_pub.logmessage ('Successfully launched asset mgr workflow');
369: END IF;
370:
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;

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

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
380: ,p_data => x_msg_data);
381: End invoke_asset_mgr_wf;
382:

Line 379: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count

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
380: ,p_data => x_msg_data);
381: End invoke_asset_mgr_wf;
382:
383:

Line 433: FND_MSG_PUB.initialize;

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;
435:
436: l_writeoff_obj_rec.writeoff_status := 'W';
437: l_writeoff_obj_rec.writeoff_type := p_writeoff_type;

Line 463: FND_MSG_PUB.initialize;

459: END IF;
460: raise FND_API.G_EXC_ERROR;
461:
462: ELSE
463: FND_MSG_PUB.initialize;
464: END IF;
465:
466: AddfailMsg( p_object => 'Writeoffs ', p_operation => 'UPDATE' );
467:

Line 494: FND_MSG_PUB.initialize;

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

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

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);
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO CREATE_WRITEOFFS;

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

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

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

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);
522: WHEN OTHERS THEN
523: ROLLBACK TO CREATE_WRITEOFFS;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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,
529: p_data => x_msg_data);
530:
531: END create_writeoffs;

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

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,
529: p_data => x_msg_data);
530:
531: END create_writeoffs;
532:

Line 687: FND_MSG_PUB.initialize;

683: result := wf_engine.eng_completed ||':'||wf_no;
684: return;
685:
686: ELSE
687: FND_MSG_PUB.initialize;
688: END IF;
689:
690: --else insert of okl_trx_ar_adjsts_b is successful we can go to
691: --the third step of populating the okl_txl_adjsts_lns_b tables

Line 723: fnd_msg_pub.add;

719: where id=i.contract_id;
720:
721: fnd_message.set_name('IEX', 'IEX_WRITEOFFOBJ_CODE_COMB');
722: fnd_message.set_token('CONTRACT_NUMBER', l_contract_number);
723: fnd_msg_pub.add;
724: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
725: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
726: iex_debug_pub.logmessage('Error' ||l_message);
727: END IF;

Line 780: FND_MSG_PUB.initialize;

776: iex_debug_pub.logmessage ('okl_txl_adjsts_lns status '
777: ||l_return_status || ' Id ' ||
778: x_ajlv_rec.id);
779: END IF;
780: FND_MSG_PUB.initialize;
781: END IF;
782:
783: --else insert of okl_txl_adjsts_lns_b is successful we can go to
784: --the fourth step of calling okl_create_adjst_pvt

Line 838: FND_MSG_PUB.initialize;

834: --raise FND_API.G_EXC_ERROR;
835: result := wf_engine.eng_completed ||':'||wf_no;
836: return;
837: ELSE
838: FND_MSG_PUB.initialize;
839: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
840: IEx_debug_pub.logmessage ('After caling OKL Adj API and adj_id ' || x_adj_id);
841: end if;
842: END IF;

Line 893: FND_MSG_PUB.initialize;

889: --raise FND_API.G_EXC_ERROR;
890: result := wf_engine.eng_completed ||':'||wf_no;
891: return;
892: ELSE
893: FND_MSG_PUB.initialize;
894: -- IF PG_DEBUG <11 THEN
895: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
896: iex_debug_pub.logmessage('Finished updating iex_writeoffobjects');
897: END IF;

Line 937: FND_MSG_PUB.initialize;

933: --raise FND_API.G_EXC_ERROR;
934: result := wf_engine.eng_completed ||':'||wf_no;
935: return;
936: ELSE
937: FND_MSG_PUB.initialize;
938: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
939: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number
940: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id||
941: 'in approve writeoff procedure');

Line 976: FND_MSG_PUB.initialize;

972: --raise FND_API.G_EXC_ERROR;
973: result := wf_engine.eng_completed ||':'||wf_no;
974: return;
975: ELSE
976: FND_MSG_PUB.initialize;
977: END IF;
978: END IF; --object_type
979: END if ;--if l_ctr;
980:

Line 1116: FND_MSG_PUB.initialize;

1112: --raise FND_API.G_EXC_ERROR;
1113: result := wf_engine.eng_completed ||':'||wf_no;
1114: return;
1115: ELSE
1116: FND_MSG_PUB.initialize;
1117: END IF;
1118:
1119: END LOOP;
1120:

Line 1157: FND_MSG_PUB.initialize;

1153: result := wf_engine.eng_completed ||':'||wf_no;
1154: return;
1155:
1156: ELSE
1157: FND_MSG_PUB.initialize;
1158: END IF;
1159:
1160: result := wf_engine.eng_completed ||':'||wf_yes;
1161: