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 525: l_msg := FND_MSG_PUB.Get( p_msg_index => l_msg_count,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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