eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_OSS_SOURCE_PK dependencies on CTO_MSG_PUB

Line 491: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');

487: End if;
488: Exception When no_data_found then
489: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS: Ship from org is not valid',1);
490: l_valid_ship_from_org := 'N';
491: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
492: raise FND_API.G_EXC_ERROR;
493: End;
494:
495: -- Added by Renga Kannan on 12/02/04 for bug # 3896824

Line 552: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');

548: Exception when no_data_found then
549: if PG_DEBUG <> 0 then
550: oe_debug_pub.add(lpad(' ',g_pg_level)||
551: 'PROCESS_OSS_CONFIGURATIONS: Preconfiguration org is not a valid manufacturing or Procuring org',1);
552: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');
553: raise FND_API.G_EXC_ERROR;
554: End if;
555: End;
556: End if;

Line 720: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');

716: Exception when no_data_found then
717: If PG_DEBUG <> 0 Then
718: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS: Ship from org is not valid',5);
719: end if;
720: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
721: raise FND_API.G_EXC_ERROR;
722: End;
723:
724: -- Added By Renga Kannan on 11/30/04 for bug #3896824

Line 781: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');

777: oe_debug_pub.add(lpad(' ',g_pg_level)||
778: 'PROCESS_OSS_CONFIGURATIONS::The Preconfiguration org is not a valid manufacturing/procuring org',3);
779: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::Raising Expected error',1);
780: end if;
781: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');
782: raise FND_API.G_EXC_ERROR;
783: End;
784: End if; /* l_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID */
785:

Line 811: cto_msg_pub.count_and_get(

807: ||'::'||sqlerrm,1);
808: END IF;
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: g_pg_level := g_pg_level - 3;
811: cto_msg_pub.count_and_get(
812: p_msg_count => x_msg_count,
813: p_msg_data => x_msg_data
814: );
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 822: cto_msg_pub.count_and_get(

818: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
819: END IF;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: g_pg_level := g_pg_level - 3;
822: cto_msg_pub.count_and_get(
823: p_msg_count => x_msg_count,
824: p_msg_data => x_msg_data
825: );
826: WHEN OTHERS THEN

Line 833: cto_msg_pub.count_and_get(

829: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
830: END IF;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
832: g_pg_level := g_pg_level - 3;
833: cto_msg_pub.count_and_get(
834: p_msg_count => x_msg_count,
835: p_msg_data => x_msg_data
836: );
837:

Line 1026: cto_msg_pub.cto_message('BOM','BOM_CTO_OSS_NO_COMMON_ORGS');

1022: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG: No Intersection org found ',1);
1023: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG: Model line id = '||p_model_line_id,1);
1024: end if;
1025: If p_calling_mode = 'ACC' Then
1026: cto_msg_pub.cto_message('BOM','BOM_CTO_OSS_NO_COMMON_ORGS');
1027: raise FND_API.G_EXC_ERROR;
1028: Elsif p_calling_mode = 'ATP' Then
1029: x_exp_error_code := 350;
1030: g_pg_level := g_pg_level - 3;

Line 1207: cto_msg_pub.cto_message('BOM','CTO_OSS_NO_VALID_TREE');

1203: If PG_DEBUG <> 0 then
1204: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG: Purning model tree results wiht no valid orgs',5);
1205: End if;
1206: If p_calling_mode = 'ACC' Then
1207: cto_msg_pub.cto_message('BOM','CTO_OSS_NO_VALID_TREE');
1208: raise FND_API.G_EXC_ERROR;
1209: Elsif p_calling_mode = 'ATP' Then
1210: x_exp_error_code := 370;
1211: g_pg_level := g_pg_level - 3;

Line 1263: cto_msg_pub.count_and_get(

1259: ||'::'||sqlerrm,1);
1260: END IF;
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: g_pg_level := g_pg_level - 3;
1263: cto_msg_pub.count_and_get(
1264: p_msg_count => x_msg_count,
1265: p_msg_data => x_msg_data
1266: );
1267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1274: cto_msg_pub.count_and_get(

1270: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1271: END IF;
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1273: g_pg_level := g_pg_level - 3;
1274: cto_msg_pub.count_and_get(
1275: p_msg_count => x_msg_count,
1276: p_msg_data => x_msg_data
1277: );
1278: WHEN OTHERS THEN

Line 1285: cto_msg_pub.count_and_get(

1281: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1282: END IF;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1284: g_pg_level := g_pg_level - 3;
1285: cto_msg_pub.count_and_get(
1286: p_msg_count => x_msg_count,
1287: p_msg_data => x_msg_data
1288: );
1289:

Line 1712: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_NO_VALID_TREE');

1708: IF PG_DEBUG <> 0 Then
1709: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG: After pruning there is no valid source node',4);
1710: End if;
1711: If p_calling_mode = 'ACC' Then
1712: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_NO_VALID_TREE');
1713: raise FND_API.G_EXC_ERROR;
1714: elsif p_calling_mode = 'ATP' Then
1715: x_exp_error_code := 350;
1716: End if;

Line 1731: cto_msg_pub.count_and_get(

1727: ||'::'||sqlerrm,1);
1728: END IF;
1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: g_pg_level := g_pg_level - 3;
1731: cto_msg_pub.count_and_get(
1732: p_msg_count => x_msg_count,
1733: p_msg_data => x_msg_data
1734: );
1735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1742: cto_msg_pub.count_and_get(

1738: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1739: END IF;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: g_pg_level := g_pg_level - 3;
1742: cto_msg_pub.count_and_get(
1743: p_msg_count => x_msg_count,
1744: p_msg_data => x_msg_data
1745: );
1746: WHEN OTHERS THEN

Line 1753: cto_msg_pub.count_and_get(

1749: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1750: END IF;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1752: g_pg_level := g_pg_level - 3;
1753: cto_msg_pub.count_and_get(
1754: p_msg_count => x_msg_count,
1755: p_msg_data => x_msg_data
1756: );
1757:

Line 2925: cto_msg_pub.count_and_get(

2921: ||'::'||sqlerrm,1);
2922: END IF;
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924: g_pg_level := g_pg_level - 3;
2925: cto_msg_pub.count_and_get(
2926: p_msg_count => x_msg_count,
2927: p_msg_data => x_msg_data
2928: );
2929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2936: cto_msg_pub.count_and_get(

2932: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
2933: END IF;
2934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2935: g_pg_level := g_pg_level - 3;
2936: cto_msg_pub.count_and_get(
2937: p_msg_count => x_msg_count,
2938: p_msg_data => x_msg_data
2939: );
2940: WHEN OTHERS THEN

Line 2947: cto_msg_pub.count_and_get(

2943: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
2944: END IF;
2945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2946: g_pg_level := g_pg_level - 3;
2947: cto_msg_pub.count_and_get(
2948: p_msg_count => x_msg_count,
2949: p_msg_data => x_msg_data
2950: );
2951:

Line 3697: cto_msg_pub.count_and_get(

3693: ||to_char(l_stmt_num)
3694: ||'::'||sqlerrm,1);
3695: END IF;
3696: x_return_status := FND_API.G_RET_STS_ERROR;
3697: cto_msg_pub.count_and_get(
3698: p_msg_count => x_msg_count,
3699: p_msg_data => x_msg_data
3700: );
3701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3707: cto_msg_pub.count_and_get(

3703: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
3704: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3705: END IF;
3706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3707: cto_msg_pub.count_and_get(
3708: p_msg_count => x_msg_count,
3709: p_msg_data => x_msg_data
3710: );
3711: WHEN OTHERS THEN

Line 3717: cto_msg_pub.count_and_get(

3713: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
3714: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3715: END IF;
3716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3717: cto_msg_pub.count_and_get(
3718: p_msg_count => x_msg_count,
3719: p_msg_data => x_msg_data
3720: );
3721:

Line 3995: cto_msg_pub.count_and_get(

3991: ||'::'||sqlerrm,1);
3992: END IF;
3993: g_pg_level := g_pg_level - 3;
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995: cto_msg_pub.count_and_get(
3996: p_msg_count => x_msg_count,
3997: p_msg_data => x_msg_data
3998: );
3999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4006: cto_msg_pub.count_and_get(

4002: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4003: END IF;
4004: g_pg_level := g_pg_level - 3;
4005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4006: cto_msg_pub.count_and_get(
4007: p_msg_count => x_msg_count,
4008: p_msg_data => x_msg_data
4009: );
4010: WHEN OTHERS THEN

Line 4017: cto_msg_pub.count_and_get(

4013: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4014: END IF;
4015: g_pg_level := g_pg_level - 3;
4016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4017: cto_msg_pub.count_and_get(
4018: p_msg_count => x_msg_count,
4019: p_msg_data => x_msg_data
4020: );
4021:

Line 4228: cto_msg_pub.count_and_get(

4224: ||'::'||sqlerrm,1);
4225: END IF;
4226: g_pg_level := g_pg_level - 3;
4227: x_return_status := FND_API.G_RET_STS_ERROR;
4228: cto_msg_pub.count_and_get(
4229: p_msg_count => x_msg_count,
4230: p_msg_data => x_msg_data
4231: );
4232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4239: cto_msg_pub.count_and_get(

4235: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4236: END IF;
4237: g_pg_level := g_pg_level - 3;
4238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4239: cto_msg_pub.count_and_get(
4240: p_msg_count => x_msg_count,
4241: p_msg_data => x_msg_data
4242: );
4243: WHEN OTHERS THEN

Line 4250: cto_msg_pub.count_and_get(

4246: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4247: END IF;
4248: g_pg_level := g_pg_level - 3;
4249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4250: cto_msg_pub.count_and_get(
4251: p_msg_count => x_msg_count,
4252: p_msg_data => x_msg_data
4253: );
4254:

Line 4447: cto_msg_pub.count_and_get(

4443: ||'::'||sqlerrm,1);
4444: END IF;
4445: g_pg_level := g_pg_level - 3;
4446: x_return_status := FND_API.G_RET_STS_ERROR;
4447: cto_msg_pub.count_and_get(
4448: p_msg_count => x_msg_count,
4449: p_msg_data => x_msg_data
4450: );
4451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4458: cto_msg_pub.count_and_get(

4454: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4455: END IF;
4456: g_pg_level := g_pg_level - 3;
4457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4458: cto_msg_pub.count_and_get(
4459: p_msg_count => x_msg_count,
4460: p_msg_data => x_msg_data
4461: );
4462: WHEN OTHERS THEN

Line 4469: cto_msg_pub.count_and_get(

4465: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4466: END IF;
4467: g_pg_level := g_pg_level - 3;
4468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4469: cto_msg_pub.count_and_get(
4470: p_msg_count => x_msg_count,
4471: p_msg_data => x_msg_data
4472: );
4473: End update_oss_in_bcol;

Line 4592: cto_msg_pub.count_and_get(

4588: ||'::'||sqlerrm,1);
4589: END IF;
4590: g_pg_level := g_pg_level - 3;
4591: x_return_status := FND_API.G_RET_STS_ERROR;
4592: cto_msg_pub.count_and_get(
4593: p_msg_count => x_msg_count,
4594: p_msg_data => x_msg_data
4595: );
4596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4603: cto_msg_pub.count_and_get(

4599: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4600: END IF;
4601: g_pg_level := g_pg_level - 3;
4602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4603: cto_msg_pub.count_and_get(
4604: p_msg_count => x_msg_count,
4605: p_msg_data => x_msg_data
4606: );
4607: WHEN OTHERS THEN

Line 4614: cto_msg_pub.count_and_get(

4610: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4611: END IF;
4612: g_pg_level := g_pg_level - 3;
4613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4614: cto_msg_pub.count_and_get(
4615: p_msg_count => x_msg_count,
4616: p_msg_data => x_msg_data
4617: );
4618:

Line 5064: cto_msg_pub.count_and_get(

5060: ||'::'||sqlerrm,1);
5061: END IF;
5062: g_pg_level := g_pg_level - 3;
5063: x_return_status := FND_API.G_RET_STS_ERROR;
5064: cto_msg_pub.count_and_get(
5065: p_msg_count => x_msg_count,
5066: p_msg_data => x_msg_data
5067: );
5068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5075: cto_msg_pub.count_and_get(

5071: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5072: END IF;
5073: g_pg_level := g_pg_level - 3;
5074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5075: cto_msg_pub.count_and_get(
5076: p_msg_count => x_msg_count,
5077: p_msg_data => x_msg_data
5078: );
5079: WHEN OTHERS THEN

Line 5086: cto_msg_pub.count_and_get(

5082: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5083: END IF;
5084: g_pg_level := g_pg_level - 3;
5085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5086: cto_msg_pub.count_and_get(
5087: p_msg_count => x_msg_count,
5088: p_msg_data => x_msg_data
5089: );
5090:

Line 5494: cto_msg_pub.count_and_get(

5490: ||'::'||sqlerrm,1);
5491: END IF;
5492: g_pg_level := g_pg_level - 3;
5493: x_return_status := FND_API.G_RET_STS_ERROR;
5494: cto_msg_pub.count_and_get(
5495: p_msg_count => x_msg_count,
5496: p_msg_data => x_msg_data
5497: );
5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5505: cto_msg_pub.count_and_get(

5501: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5502: END IF;
5503: g_pg_level := g_pg_level - 3;
5504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5505: cto_msg_pub.count_and_get(
5506: p_msg_count => x_msg_count,
5507: p_msg_data => x_msg_data
5508: );
5509: WHEN OTHERS THEN

Line 5516: cto_msg_pub.count_and_get(

5512: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5513: END IF;
5514: g_pg_level := g_pg_level - 3;
5515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5516: cto_msg_pub.count_and_get(
5517: p_msg_count => x_msg_count,
5518: p_msg_data => x_msg_data
5519: );
5520:

Line 5577: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');

5573: If G_source_org_stk.exists(p_org_id) then
5574: if PG_DEBUG <> 0 then
5575: oe_debug_pub.add(lpad(' ',g_pg_level)||'TRAVERSE_SOURCING_CHAIN: Circular sourcing deducted..',5);
5576: end if;
5577: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
5578: raise FND_API.G_EXC_ERROR;
5579: Else
5580: -- Push the org to the stack
5581: G_source_org_stk(p_org_id) := p_org_id;

Line 5823: cto_msg_pub.count_and_get(

5819: ||'::'||sqlerrm,1);
5820: END IF;
5821: g_pg_level := g_pg_level - 3;
5822: x_return_status := FND_API.G_RET_STS_ERROR;
5823: cto_msg_pub.count_and_get(
5824: p_msg_count => x_msg_count,
5825: p_msg_data => x_msg_data
5826: );
5827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5834: cto_msg_pub.count_and_get(

5830: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5831: END IF;
5832: g_pg_level := g_pg_level - 3;
5833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5834: cto_msg_pub.count_and_get(
5835: p_msg_count => x_msg_count,
5836: p_msg_data => x_msg_data
5837: );
5838: WHEN OTHERS THEN

Line 5845: cto_msg_pub.count_and_get(

5841: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5842: END IF;
5843: g_pg_level := g_pg_level - 3;
5844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5845: cto_msg_pub.count_and_get(
5846: p_msg_count => x_msg_count,
5847: p_msg_data => x_msg_data
5848: );
5849: End query_oss_sourcing_org;