DBA Data[Home] [Help]

APPS.FUN_TRX_PUB dependencies on FND_MSG_PUB

Line 199: FND_MSG_PUB.initialize;

195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196:
197: -- Initialize message list if p_init_msg_list is set to TRUE.
198: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE) ) THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: /*Initialize the Stack of the Validation API's when calling_sequence is Intercompany Imort Programs*/
203: If (p_calling_sequence = 'Intercompany Import Program') then

Line 353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

349: FROM fun_trx_batches
350: WHERE batch_id=l_batch_rec.batch_id;
351: -- IF batch_id exist
352: l_return_status :=FND_API.G_RET_STS_ERROR;
353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
354: FND_MESSAGE.SET_NAME('FUN', 'FUN_DUPLICATE_BATCH_ID');
355: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_rec.batch_id);
356: l_msg := FND_Message.Get;
357: IF (insert_rejections(p_batch_id => l_batch_rec.batch_id,

Line 392: l_msg := FND_MSG_PUB.Get( p_msg_index => l_msg_count,

388: If (p_calling_sequence = 'Intercompany Import Program') then
389: IF l_msg_count >= 1 THEN
390: FOR i IN 1..l_msg_count
391: LOOP
392: l_msg := FND_MSG_PUB.Get( p_msg_index => l_msg_count,
393: p_encoded => FND_API.G_FALSE);
394: If (insert_rejections(
395: p_batch_id => l_batch_rec.batch_id,
396: p_reject_reason => l_msg

Line 526: l_msg := FND_MSG_PUB.Get( p_msg_index => l_msg_count,

522: -- Insert into Rejections Table
523: IF l_msg_count >= 1 THEN
524: FOR i IN 1..l_msg_count
525: LOOP
526: l_msg := FND_MSG_PUB.Get( p_msg_index => l_msg_count,
527: p_encoded => FND_API.G_FALSE );
528: If (insert_rejections(
529: p_batch_id => p_trx_tbl(l_head_count).batch_id,
530: p_trx_id => p_trx_tbl(l_head_count).trx_id,

Line 605: l_msg := FND_MSG_PUB.Get( p_msg_index => l_msg_count,

601:
602: IF l_msg_count >= 1 THEN
603: FOR i IN 1..l_msg_count
604: LOOP
605: l_msg := FND_MSG_PUB.Get( p_msg_index => l_msg_count,
606: p_encoded => FND_API.G_FALSE );
607: If (insert_rejections(
608: p_batch_id => p_init_dist_tbl(l_line_count).batch_id,
609: p_batch_dist_id => p_init_dist_tbl(l_line_count).batch_dist_id,

Line 733: l_msg := FND_MSG_PUB.Get( p_msg_index => l_msg_count,

729:
730: IF l_msg_count >= 1 THEN
731: FOR i IN 1..l_msg_count
732: LOOP
733: l_msg := FND_MSG_PUB.Get( p_msg_index => l_msg_count,
734: p_encoded => FND_API.G_FALSE );
735: If (insert_rejections(
736: p_batch_id =>l_batch_rec.batch_id,
737: p_dist_id => p_dist_lines_tbl(l_line_count).dist_id,

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

1300: COMMIT WORK;
1301: END IF;
1302:
1303: -- Standard call to get message count and if count is 1, get message info.
1304: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1305: p_data => x_msg_data);
1306: Print('Val and Insert >>>>'||'End of the API');
1307:
1308: EXCEPTION

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

1314: p_init_dist_tbl := l_old_init_dist_tbl;
1315: p_dist_lines_tbl := l_old_dist_lines_tbl;
1316: ROLLBACK TO Fun_Trx_Val_And_Insert_PUB;
1317: x_return_status := FND_API.G_RET_STS_ERROR ;
1318: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1319: p_data => x_msg_data);
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: Print('Val and Insert >>>>'||'Unexpected error occurred -'||SQLERRM);
1322: p_batch_rec := l_old_batch_rec;

Line 1334: Print(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));

1330: Print('****************************************');
1331: IF x_msg_count > 1 THEN
1332: FOR i IN 1..x_msg_count
1333: LOOP
1334: Print(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));
1335: END LOOP;
1336: ELSE
1337: Print(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));
1338: END IF;

Line 1337: Print(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));

1333: LOOP
1334: Print(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));
1335: END LOOP;
1336: ELSE
1337: Print(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));
1338: END IF;
1339: ROLLBACK TO Fun_Trx_Val_And_Insert_PUB;
1340:
1341: WHEN OTHERS THEN

Line 1350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1346: p_dist_lines_tbl := l_old_dist_lines_tbl;
1347: ROLLBACK TO Fun_Trx_Val_And_Insert_PUB;
1348: Print('Val and Insert >>>>'||'Exception others- '||SQLERRM);
1349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1351: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1352: END IF;
1353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1354: p_data => x_msg_data);

Line 1351: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1347: ROLLBACK TO Fun_Trx_Val_And_Insert_PUB;
1348: Print('Val and Insert >>>>'||'Exception others- '||SQLERRM);
1349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1351: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1352: END IF;
1353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1354: p_data => x_msg_data);
1355:

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

1349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1351: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1352: END IF;
1353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1354: p_data => x_msg_data);
1355:
1356:
1357: END CREATE_BATCH; -- Procedure