APPS.AS_CATALOG_MIGRATION dependencies on FND_MSG_PUB

Line 374: fnd_msg_pub.count_and_get( p_encoded => 'F'

370:
371: ERRBUF := 'Error in category mapping '||SQLERRM;
372: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
373:
374: fnd_msg_pub.count_and_get( p_encoded => 'F'
375: , p_count => l_msg_count
376: , p_data => l_msg_data);
377: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return Status:' || nvl(l_return_status,'xxx'));
378: --=================message display part begins

Line 380: l_msg_data := fnd_msg_pub.get( p_msg_index => k,

376: , p_data => l_msg_data);
377: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return Status:' || nvl(l_return_status,'xxx'));
378: --=================message display part begins
379: for k in 1 .. l_msg_count loop
380: l_msg_data := fnd_msg_pub.get( p_msg_index => k,
381: p_encoded => 'F'
382: );
383: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error msg: '||substr(l_msg_data,1,240));
384: ERRBUF := substr(ERRBUF || ';Error msg: '|| l_msg_data,1,3900);

Line 1096: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Process_Categories');

1092: l_return_status := FND_API.G_RET_STS_ERROR;
1093: end if;
1094:
1095: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in Process_Categories');
1096: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Process_Categories');
1097: x_return_status := l_return_status;
1098: x_msg_count := l_msg_count;
1099: x_msg_data := l_msg_data;
1100: x_category_id := l_out_category_id;

Line 1282: fnd_msg_pub.count_and_get( p_encoded => 'F'

1278: l_msg_data VARCHAR2(2000);
1279: l_msg_count NUMBER;
1280: BEGIN
1281: x_return_status := FND_API.G_RET_STS_ERROR;
1282: fnd_msg_pub.count_and_get( p_encoded => 'F'
1283: , p_count => l_msg_count
1284: , p_data => l_msg_data);
1285: for k in 1 .. l_msg_count loop
1286: l_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 1286: l_msg_data := fnd_msg_pub.get( p_msg_index => k,

1282: fnd_msg_pub.count_and_get( p_encoded => 'F'
1283: , p_count => l_msg_count
1284: , p_data => l_msg_data);
1285: for k in 1 .. l_msg_count loop
1286: l_msg_data := fnd_msg_pub.get( p_msg_index => k,
1287: p_encoded => 'F'
1288: );
1289: -- If this token is found in the message, it signifies a duplicate
1290: if (INSTR(l_msg_data,'Category Segment Combination')> 0)

Line 1293: FND_MSG_PUB.Delete_Msg(k);

1289: -- If this token is found in the message, it signifies a duplicate
1290: if (INSTR(l_msg_data,'Category Segment Combination')> 0)
1291: then
1292: x_return_status := FND_API.G_RET_STS_SUCCESS;
1293: FND_MSG_PUB.Delete_Msg(k);
1294: exit;
1295: end if;
1296: end loop;
1297: END Check_Duplicate_Category;