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_UTILITY_PK dependencies on CTO_MSG_PUB

Line 396: CTO_MSG_PUB.Count_And_Get

392: IF PG_DEBUG <> 0 THEN
393: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
394: END IF;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: CTO_MSG_PUB.Count_And_Get
397: (p_msg_count => x_msg_count
398: ,p_msg_data => x_msg_data
399: );
400: return(0);

Line 407: CTO_MSG_PUB.Count_And_Get

403: IF PG_DEBUG <> 0 THEN
404: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
405: END IF;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: CTO_MSG_PUB.Count_And_Get
408: (p_msg_count => x_msg_count
409: ,p_msg_data => x_msg_data);
410: return(0);
411:

Line 423: CTO_MSG_PUB.Count_And_Get

419: (G_PKG_NAME
420: ,'populate_src_orgs'
421: );
422: END IF;
423: CTO_MSG_PUB.Count_And_Get
424: (p_msg_count => x_msg_count
425: ,p_msg_data => x_msg_data
426: );
427: return(0);

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

824: -- to OE, in both cases we need to set the message again
825: -- This is because if we not set the token once again the
826: -- second add will not get the message.
827:
828: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
829: raise FND_API.G_EXC_ERROR;
830: ELSE
831:
832: IF PG_DEBUG <> 0 THEN

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

910: -- to OE, in both cases we need to set the message again
911: -- This is because if we not set the token once again the
912: -- second add will not get the message.
913:
914: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
915: raise FND_API.G_EXC_ERROR;
916:
917: END;
918:

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

975: ||' in org '
976: ||to_char(pRcvOrgId), 1);
977: END IF;
978:
979: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
980: raise FND_API.G_EXC_ERROR;
981: END IF;
982:
983: lStmtNumber := 120;

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

1240: end if ;
1241:
1242:
1243: if lVAlidationOrg = -99 then -- bugfix 2646849
1244: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
1245: raise FND_API.G_EXC_ERROR;
1246: end if;
1247: IF PG_DEBUG <> 0 THEN
1248: oe_debug_pub.add('populate_plan_level: ' || 'Validation Org is :' || lValidationOrg,2);

Line 1387: cto_msg_pub.cto_message('BOM','CTO_PO_VALIDATION');

1383: if lPoVAlidationOrg = -99 then --bugfix 2646849
1384: IF PG_DEBUG <> 0 THEN
1385: oe_debug_pub.add('populate_plan_level: ' || 'No Povalidation org is defined .. Need to error out..',1);
1386: END IF;
1387: cto_msg_pub.cto_message('BOM','CTO_PO_VALIDATION');
1388: raise po_multiorg_error;
1389: end if;
1390:
1391: END IF;

Line 1542: CTO_MSG_PUB.Count_And_Get

1538: IF PG_DEBUG <> 0 THEN
1539: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1540: END IF;
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: CTO_MSG_PUB.Count_And_Get
1543: (p_msg_count => x_msg_count
1544: ,p_msg_data => x_msg_data
1545: );
1546: return(0);

Line 1553: CTO_MSG_PUB.Count_And_Get (

1549: IF PG_DEBUG <> 0 THEN
1550: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1551: END IF;
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: CTO_MSG_PUB.Count_And_Get (
1554: p_msg_count => x_msg_count
1555: ,p_msg_data => x_msg_data
1556: );
1557: return(0);

Line 1570: CTO_MSG_PUB.Count_And_Get

1566: (G_PKG_NAME
1567: ,'Get_All_Item_Orgs'
1568: );
1569: END IF;
1570: CTO_MSG_PUB.Count_And_Get
1571: (p_msg_count => x_msg_count
1572: ,p_msg_data => x_msg_data
1573: );
1574: return(0);

Line 2060: CTO_MSG_PUB.Count_And_Get

2056: IF PG_DEBUG <> 0 THEN
2057: oe_debug_pub.add('populate_plan_level: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
2058: END IF;
2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: CTO_MSG_PUB.Count_And_Get
2061: (p_msg_count => x_msg_count
2062: ,p_msg_data => x_msg_data
2063: );
2064:

Line 2070: CTO_MSG_PUB.Count_And_Get

2066: IF PG_DEBUG <> 0 THEN
2067: oe_debug_pub.add('populate_plan_level: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
2068: END IF;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070: CTO_MSG_PUB.Count_And_Get
2071: (p_msg_count => x_msg_count
2072: ,p_msg_data => x_msg_data
2073: );
2074:

Line 2086: CTO_MSG_PUB.Count_And_Get

2082: (G_PKG_NAME
2083: ,'Create_Sourcing_Rules'
2084: );
2085: END IF;
2086: CTO_MSG_PUB.Count_And_Get
2087: (p_msg_count => x_msg_count
2088: ,p_msg_data => x_msg_data
2089: );
2090:

Line 2384: cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');

2380: oe_debug_pub.add('populate_bcol: ' || ' got into exception for top level item at ' || v_step , 1 );
2381:
2382: oe_debug_pub.add('populate_bcol: ' || 'error in top ato model line id::'||sqlerrm , 1 );
2383: END IF;
2384: cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
2385: raise FND_API.G_EXC_ERROR;
2386:
2387: end;
2388:

Line 2442: cto_msg_pub.cto_message('BOM','CTO_CONFIG_ITEM_EXISTS');

2438: IF PG_DEBUG <> 0 THEN
2439: oe_debug_pub.add('populate_bcol: ' || ' ---- CONFIG Exists ', 1 );
2440: END IF;
2441:
2442: cto_msg_pub.cto_message('BOM','CTO_CONFIG_ITEM_EXISTS');
2443: raise FND_API.G_EXC_ERROR;
2444:
2445: end if ;
2446:

Line 2628: cto_msg_pub.cto_message('BOM','CTO_INVALID_MODEL_SETUP');

2624:
2625: END IF;
2626:
2627:
2628: cto_msg_pub.cto_message('BOM','CTO_INVALID_MODEL_SETUP');
2629: raise FND_API.G_EXC_ERROR;
2630:
2631: end if;
2632:

Line 2921: CTO_MSG_PUB.Count_And_Get

2917: IF PG_DEBUG <> 0 THEN
2918: oe_debug_pub.add('populate_bcol: ' || 'populate_Bcol::exp error::'|| v_step ||'::'||sqlerrm , 1);
2919: END IF;
2920: x_return_status := FND_API.G_RET_STS_ERROR;
2921: CTO_MSG_PUB.Count_And_Get
2922: (p_msg_count => x_msg_count
2923: ,p_msg_data => x_msg_data
2924: );
2925:

Line 2931: CTO_MSG_PUB.Count_And_Get

2927: IF PG_DEBUG <> 0 THEN
2928: oe_debug_pub.add('populate_bcol: ' || 'populate_Bcol::unexp error::'|| v_step ||'::'||sqlerrm , 1);
2929: END IF;
2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: CTO_MSG_PUB.Count_And_Get
2932: (p_msg_count => x_msg_count
2933: ,p_msg_data => x_msg_data
2934: );
2935:

Line 2947: CTO_MSG_PUB.Count_And_Get

2943: (G_PKG_NAME
2944: ,'populate_bcol'
2945: );
2946: END IF;
2947: CTO_MSG_PUB.Count_And_Get
2948: (p_msg_count => x_msg_count
2949: ,p_msg_data => x_msg_data
2950: );
2951:

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

3366:
3367: if( v_sourcing_rule_count > 0 ) then
3368:
3369: /* x_return_status := FND_API.G_RET_STS_ERROR;
3370: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
3371: x_exp_error_code := 66;
3372:
3373: */
3374:

Line 3665: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING'); -- bugfix 2813271

3661: oe_debug_pub.add('get_model_sourcing_org: ' || ' circular sourcing problem ' , 1 );
3662: END IF;
3663:
3664: --bugfix 2813271: Added message to show the user
3665: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING'); -- bugfix 2813271
3666: RAISE FND_API.G_EXC_ERROR;
3667:
3668: end if ;
3669:

Line 3683: CTO_MSG_PUB.Count_And_Get(

3679: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_ERROR;
3682:
3683: CTO_MSG_PUB.Count_And_Get(
3684: p_msg_count => x_msg_count
3685: , p_msg_data => x_msg_data
3686: );
3687:

Line 3694: CTO_MSG_PUB.Count_And_Get(

3690: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3691: END IF;
3692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3693:
3694: CTO_MSG_PUB.Count_And_Get(
3695: p_msg_count => x_msg_count
3696: , p_msg_data => x_msg_data
3697: );
3698:

Line 4661: cto_msg_pub.count_and_get

4657: ( 'CTO_WORKFLOW',
4658: 'chk_all_rsv_details'
4659: );
4660: end if;
4661: cto_msg_pub.count_and_get
4662: (
4663: p_msg_count=>x_msg_count,
4664: p_msg_data=>x_msg_data
4665: );

Line 5453: cto_msg_pub.count_and_get

5449: || to_char(lStmtNum), 1);
5450: END IF;
5451: x_return_status := FND_API.G_RET_STS_ERROR;
5452: -- Get message count and data
5453: cto_msg_pub.count_and_get
5454: ( p_msg_count => x_msg_count
5455: , p_msg_data => x_msg_data
5456: );
5457: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5464: cto_msg_pub.count_and_get

5460: || to_char(lStmtNum), 1);
5461: END IF;
5462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5463: -- Get message count and data
5464: cto_msg_pub.count_and_get
5465: ( p_msg_count => x_msg_count
5466: , p_msg_data => x_msg_data
5467: );
5468: WHEN OTHERS then

Line 5477: cto_msg_pub.count_and_get

5473: oe_debug_pub.add('check_cto_can_create_supply: ' || 'errormsg='||sqlerrm, 1);
5474: END IF;
5475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5476: -- Get message count and data
5477: cto_msg_pub.count_and_get
5478: ( p_msg_count => x_msg_count
5479: , p_msg_data => x_msg_data
5480: );
5481:

Line 7075: cto_msg_pub.count_and_get

7071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
7072: oe_debug_pub.add('lock_for_match: ' || 'Unexpected Error.');
7073: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7074: -- Get message count and data
7075: cto_msg_pub.count_and_get
7076: ( p_msg_count => xMsgCount
7077: , p_msg_data => xMsgData
7078: );
7079: WHEN OTHERS then

Line 7083: cto_msg_pub.count_and_get

7079: WHEN OTHERS then
7080: oe_debug_pub.add('lock_for_match: ' || 'Others Exception : ' || sqlerrm);
7081: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7082: -- Get message count and data
7083: cto_msg_pub.count_and_get
7084: ( p_msg_count => xMsgCount
7085: , p_msg_data => xMsgData
7086: );
7087: END;

Line 7134: cto_msg_pub.cto_message('BOM','BOM_LOCK_RELEASE_ERROR');

7130: --if success (status = 0) or session does not own lock (status=4),
7131: -- do nothing
7132: --if parameter error or illegal lock handle (internal error)
7133: if l_status IN (3,5) THEN
7134: cto_msg_pub.cto_message('BOM','BOM_LOCK_RELEASE_ERROR');
7135: RAISE fnd_api.g_exc_error;
7136: end if;
7137:
7138: x_return_status := l_return_status;

Line 7534: cto_msg_pub.count_and_get

7530: || to_char(lStmtNum), 1);
7531: END IF;
7532: x_return_status := FND_API.G_RET_STS_ERROR;
7533: -- Get message count and data
7534: cto_msg_pub.count_and_get
7535: ( p_msg_count => x_msg_count
7536: , p_msg_data => x_msg_data
7537: );
7538: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7545: cto_msg_pub.count_and_get

7541: || to_char(lStmtNum), 1);
7542: END IF;
7543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7544: -- Get message count and data
7545: cto_msg_pub.count_and_get
7546: ( p_msg_count => x_msg_count
7547: , p_msg_data => x_msg_data
7548: );
7549: WHEN OTHERS then

Line 7558: cto_msg_pub.count_and_get

7554: || to_char(lStmtNum), 1);
7555: END IF;
7556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7557: -- Get message count and data
7558: cto_msg_pub.count_and_get
7559: ( p_msg_count => x_msg_count
7560: , p_msg_data => x_msg_data
7561: );
7562: END Get_Resv_Qty;