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 532: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');

528: End if;
529: Exception When no_data_found then
530: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS: Ship from org is not valid',1);
531: l_valid_ship_from_org := 'N';
532: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
533: raise FND_API.G_EXC_ERROR;
534: End;
535:
536: -- Added by Renga Kannan on 12/02/04 for bug # 3896824

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

589: Exception when no_data_found then
590: if PG_DEBUG <> 0 then
591: oe_debug_pub.add(lpad(' ',g_pg_level)||
592: 'PROCESS_OSS_CONFIGURATIONS: Preconfiguration org is not a valid manufacturing or Procuring org',1);
593: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');
594: raise FND_API.G_EXC_ERROR;
595: End if;
596: End;
597: End if;

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

802: Exception when no_data_found then
803: If PG_DEBUG <> 0 Then
804: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS: Ship from org is not valid',5);
805: end if;
806: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
807: raise FND_API.G_EXC_ERROR;
808: End;
809:
810: END IF; -- IF (l_program_id <> cto_update_configs_pk.bac_program_id) Bugfix 8894392

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

865: oe_debug_pub.add(lpad(' ',g_pg_level)||
866: 'PROCESS_OSS_CONFIGURATIONS::The Preconfiguration org is not a valid manufacturing/procuring org',3);
867: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::Raising Expected error',1);
868: end if;
869: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');
870: raise FND_API.G_EXC_ERROR;
871: End;
872: End if; /* l_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID */
873:

Line 899: cto_msg_pub.count_and_get(

895: ||'::'||sqlerrm,1);
896: END IF;
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: g_pg_level := g_pg_level - 3;
899: cto_msg_pub.count_and_get(
900: p_msg_count => x_msg_count,
901: p_msg_data => x_msg_data
902: );
903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 910: cto_msg_pub.count_and_get(

906: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
907: END IF;
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: g_pg_level := g_pg_level - 3;
910: cto_msg_pub.count_and_get(
911: p_msg_count => x_msg_count,
912: p_msg_data => x_msg_data
913: );
914: WHEN OTHERS THEN

Line 921: cto_msg_pub.count_and_get(

917: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
918: END IF;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: g_pg_level := g_pg_level - 3;
921: cto_msg_pub.count_and_get(
922: p_msg_count => x_msg_count,
923: p_msg_data => x_msg_data
924: );
925:

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

1110: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG: No Intersection org found ',1);
1111: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG: Model line id = '||p_model_line_id,1);
1112: end if;
1113: If p_calling_mode in ('ACC', 'UPG') Then --Bugfix 8894392
1114: cto_msg_pub.cto_message('BOM','BOM_CTO_OSS_NO_COMMON_ORGS');
1115: raise FND_API.G_EXC_ERROR;
1116: Elsif p_calling_mode = 'ATP' Then
1117: x_exp_error_code := 350;
1118: g_pg_level := g_pg_level - 3;

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

1298: End if;
1299:
1300: del_from_msa(p_config_item_id); --Bugfix 8894392
1301:
1302: cto_msg_pub.cto_message('BOM','CTO_OSS_NO_VALID_TREE');
1303: raise FND_API.G_EXC_ERROR;
1304: Elsif p_calling_mode = 'ATP' Then
1305: x_exp_error_code := 370;
1306: g_pg_level := g_pg_level - 3;

Line 1364: cto_msg_pub.count_and_get(

1360: ||'::'||sqlerrm,1);
1361: END IF;
1362: x_return_status := FND_API.G_RET_STS_ERROR;
1363: g_pg_level := g_pg_level - 3;
1364: cto_msg_pub.count_and_get(
1365: p_msg_count => x_msg_count,
1366: p_msg_data => x_msg_data
1367: );
1368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1375: cto_msg_pub.count_and_get(

1371: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1372: END IF;
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: g_pg_level := g_pg_level - 3;
1375: cto_msg_pub.count_and_get(
1376: p_msg_count => x_msg_count,
1377: p_msg_data => x_msg_data
1378: );
1379: WHEN OTHERS THEN

Line 1386: cto_msg_pub.count_and_get(

1382: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1383: END IF;
1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1385: g_pg_level := g_pg_level - 3;
1386: cto_msg_pub.count_and_get(
1387: p_msg_count => x_msg_count,
1388: p_msg_data => x_msg_data
1389: );
1390:

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

1849: IF PG_DEBUG <> 0 Then
1850: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG: After pruning there is no valid source node',4);
1851: End if;
1852: If p_calling_mode in ('ACC', 'UPG') Then --Bugfix 8894392
1853: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_NO_VALID_TREE');
1854: raise FND_API.G_EXC_ERROR;
1855: elsif p_calling_mode = 'ATP' Then
1856: x_exp_error_code := 350;
1857: End if;

Line 1878: cto_msg_pub.count_and_get(

1874: ||'::'||sqlerrm,1);
1875: END IF;
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: g_pg_level := g_pg_level - 3;
1878: cto_msg_pub.count_and_get(
1879: p_msg_count => x_msg_count,
1880: p_msg_data => x_msg_data
1881: );
1882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1889: cto_msg_pub.count_and_get(

1885: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1886: END IF;
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1888: g_pg_level := g_pg_level - 3;
1889: cto_msg_pub.count_and_get(
1890: p_msg_count => x_msg_count,
1891: p_msg_data => x_msg_data
1892: );
1893: WHEN OTHERS THEN

Line 1900: cto_msg_pub.count_and_get(

1896: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1897: END IF;
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1899: g_pg_level := g_pg_level - 3;
1900: cto_msg_pub.count_and_get(
1901: p_msg_count => x_msg_count,
1902: p_msg_data => x_msg_data
1903: );
1904:

Line 3363: cto_msg_pub.count_and_get(

3359: ||'::'||sqlerrm,1);
3360: END IF;
3361: x_return_status := FND_API.G_RET_STS_ERROR;
3362: g_pg_level := g_pg_level - 3;
3363: cto_msg_pub.count_and_get(
3364: p_msg_count => x_msg_count,
3365: p_msg_data => x_msg_data
3366: );
3367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3374: cto_msg_pub.count_and_get(

3370: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3371: END IF;
3372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3373: g_pg_level := g_pg_level - 3;
3374: cto_msg_pub.count_and_get(
3375: p_msg_count => x_msg_count,
3376: p_msg_data => x_msg_data
3377: );
3378: WHEN OTHERS THEN

Line 3385: cto_msg_pub.count_and_get(

3381: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3382: END IF;
3383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3384: g_pg_level := g_pg_level - 3;
3385: cto_msg_pub.count_and_get(
3386: p_msg_count => x_msg_count,
3387: p_msg_data => x_msg_data
3388: );
3389:

Line 4216: cto_msg_pub.count_and_get(

4212: ||to_char(l_stmt_num)
4213: ||'::'||sqlerrm,1);
4214: END IF;
4215: x_return_status := FND_API.G_RET_STS_ERROR;
4216: cto_msg_pub.count_and_get(
4217: p_msg_count => x_msg_count,
4218: p_msg_data => x_msg_data
4219: );
4220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4226: cto_msg_pub.count_and_get(

4222: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
4223: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4224: END IF;
4225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4226: cto_msg_pub.count_and_get(
4227: p_msg_count => x_msg_count,
4228: p_msg_data => x_msg_data
4229: );
4230: WHEN OTHERS THEN

Line 4236: cto_msg_pub.count_and_get(

4232: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
4233: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4234: END IF;
4235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4236: cto_msg_pub.count_and_get(
4237: p_msg_count => x_msg_count,
4238: p_msg_data => x_msg_data
4239: );
4240:

Line 4519: cto_msg_pub.count_and_get(

4515: ||'::'||sqlerrm,1);
4516: END IF;
4517: g_pg_level := g_pg_level - 3;
4518: x_return_status := FND_API.G_RET_STS_ERROR;
4519: cto_msg_pub.count_and_get(
4520: p_msg_count => x_msg_count,
4521: p_msg_data => x_msg_data
4522: );
4523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4530: cto_msg_pub.count_and_get(

4526: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4527: END IF;
4528: g_pg_level := g_pg_level - 3;
4529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4530: cto_msg_pub.count_and_get(
4531: p_msg_count => x_msg_count,
4532: p_msg_data => x_msg_data
4533: );
4534: WHEN OTHERS THEN

Line 4541: cto_msg_pub.count_and_get(

4537: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4538: END IF;
4539: g_pg_level := g_pg_level - 3;
4540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4541: cto_msg_pub.count_and_get(
4542: p_msg_count => x_msg_count,
4543: p_msg_data => x_msg_data
4544: );
4545:

Line 4757: cto_msg_pub.count_and_get(

4753: ||'::'||sqlerrm,1);
4754: END IF;
4755: g_pg_level := g_pg_level - 3;
4756: x_return_status := FND_API.G_RET_STS_ERROR;
4757: cto_msg_pub.count_and_get(
4758: p_msg_count => x_msg_count,
4759: p_msg_data => x_msg_data
4760: );
4761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4768: cto_msg_pub.count_and_get(

4764: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4765: END IF;
4766: g_pg_level := g_pg_level - 3;
4767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4768: cto_msg_pub.count_and_get(
4769: p_msg_count => x_msg_count,
4770: p_msg_data => x_msg_data
4771: );
4772: WHEN OTHERS THEN

Line 4779: cto_msg_pub.count_and_get(

4775: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4776: END IF;
4777: g_pg_level := g_pg_level - 3;
4778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4779: cto_msg_pub.count_and_get(
4780: p_msg_count => x_msg_count,
4781: p_msg_data => x_msg_data
4782: );
4783:

Line 4989: cto_msg_pub.count_and_get(

4985: ||'::'||sqlerrm,1);
4986: END IF;
4987: g_pg_level := g_pg_level - 3;
4988: x_return_status := FND_API.G_RET_STS_ERROR;
4989: cto_msg_pub.count_and_get(
4990: p_msg_count => x_msg_count,
4991: p_msg_data => x_msg_data
4992: );
4993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5000: cto_msg_pub.count_and_get(

4996: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4997: END IF;
4998: g_pg_level := g_pg_level - 3;
4999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5000: cto_msg_pub.count_and_get(
5001: p_msg_count => x_msg_count,
5002: p_msg_data => x_msg_data
5003: );
5004: WHEN OTHERS THEN

Line 5011: cto_msg_pub.count_and_get(

5007: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5008: END IF;
5009: g_pg_level := g_pg_level - 3;
5010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5011: cto_msg_pub.count_and_get(
5012: p_msg_count => x_msg_count,
5013: p_msg_data => x_msg_data
5014: );
5015: End update_oss_in_bcol;

Line 5145: cto_msg_pub.count_and_get(

5141: ||'::'||sqlerrm,1);
5142: END IF;
5143: g_pg_level := g_pg_level - 3;
5144: x_return_status := FND_API.G_RET_STS_ERROR;
5145: cto_msg_pub.count_and_get(
5146: p_msg_count => x_msg_count,
5147: p_msg_data => x_msg_data
5148: );
5149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5156: cto_msg_pub.count_and_get(

5152: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5153: END IF;
5154: g_pg_level := g_pg_level - 3;
5155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5156: cto_msg_pub.count_and_get(
5157: p_msg_count => x_msg_count,
5158: p_msg_data => x_msg_data
5159: );
5160: WHEN OTHERS THEN

Line 5167: cto_msg_pub.count_and_get(

5163: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5164: END IF;
5165: g_pg_level := g_pg_level - 3;
5166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5167: cto_msg_pub.count_and_get(
5168: p_msg_count => x_msg_count,
5169: p_msg_data => x_msg_data
5170: );
5171:

Line 5726: cto_msg_pub.count_and_get(

5722: ||'::'||sqlerrm,1);
5723: END IF;
5724: g_pg_level := g_pg_level - 3;
5725: x_return_status := FND_API.G_RET_STS_ERROR;
5726: cto_msg_pub.count_and_get(
5727: p_msg_count => x_msg_count,
5728: p_msg_data => x_msg_data
5729: );
5730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5737: cto_msg_pub.count_and_get(

5733: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5734: END IF;
5735: g_pg_level := g_pg_level - 3;
5736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5737: cto_msg_pub.count_and_get(
5738: p_msg_count => x_msg_count,
5739: p_msg_data => x_msg_data
5740: );
5741: WHEN OTHERS THEN

Line 5748: cto_msg_pub.count_and_get(

5744: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5745: END IF;
5746: g_pg_level := g_pg_level - 3;
5747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5748: cto_msg_pub.count_and_get(
5749: p_msg_count => x_msg_count,
5750: p_msg_data => x_msg_data
5751: );
5752:

Line 6175: cto_msg_pub.count_and_get(

6171: ||'::'||sqlerrm,1);
6172: END IF;
6173: g_pg_level := g_pg_level - 3;
6174: x_return_status := FND_API.G_RET_STS_ERROR;
6175: cto_msg_pub.count_and_get(
6176: p_msg_count => x_msg_count,
6177: p_msg_data => x_msg_data
6178: );
6179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6186: cto_msg_pub.count_and_get(

6182: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6183: END IF;
6184: g_pg_level := g_pg_level - 3;
6185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6186: cto_msg_pub.count_and_get(
6187: p_msg_count => x_msg_count,
6188: p_msg_data => x_msg_data
6189: );
6190: WHEN OTHERS THEN

Line 6197: cto_msg_pub.count_and_get(

6193: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6194: END IF;
6195: g_pg_level := g_pg_level - 3;
6196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6197: cto_msg_pub.count_and_get(
6198: p_msg_count => x_msg_count,
6199: p_msg_data => x_msg_data
6200: );
6201:

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

6254: If G_source_org_stk.exists(p_org_id) then
6255: if PG_DEBUG <> 0 then
6256: oe_debug_pub.add(lpad(' ',g_pg_level)||'TRAVERSE_SOURCING_CHAIN: Circular sourcing deducted..',5);
6257: end if;
6258: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
6259: raise FND_API.G_EXC_ERROR;
6260: Else
6261: -- Push the org to the stack
6262: G_source_org_stk(p_org_id) := p_org_id;

Line 6504: cto_msg_pub.count_and_get(

6500: ||'::'||sqlerrm,1);
6501: END IF;
6502: g_pg_level := g_pg_level - 3;
6503: x_return_status := FND_API.G_RET_STS_ERROR;
6504: cto_msg_pub.count_and_get(
6505: p_msg_count => x_msg_count,
6506: p_msg_data => x_msg_data
6507: );
6508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6515: cto_msg_pub.count_and_get(

6511: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6512: END IF;
6513: g_pg_level := g_pg_level - 3;
6514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6515: cto_msg_pub.count_and_get(
6516: p_msg_count => x_msg_count,
6517: p_msg_data => x_msg_data
6518: );
6519: WHEN OTHERS THEN

Line 6526: cto_msg_pub.count_and_get(

6522: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6523: END IF;
6524: g_pg_level := g_pg_level - 3;
6525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6526: cto_msg_pub.count_and_get(
6527: p_msg_count => x_msg_count,
6528: p_msg_data => x_msg_data
6529: );
6530: End query_oss_sourcing_org;