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 394: CTO_MSG_PUB.Count_And_Get

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

Line 405: CTO_MSG_PUB.Count_And_Get

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

Line 421: CTO_MSG_PUB.Count_And_Get

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

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

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

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

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

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

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

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

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

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

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

Line 1540: CTO_MSG_PUB.Count_And_Get

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

Line 1551: CTO_MSG_PUB.Count_And_Get (

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

Line 1568: CTO_MSG_PUB.Count_And_Get

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

Line 2058: CTO_MSG_PUB.Count_And_Get

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

Line 2068: CTO_MSG_PUB.Count_And_Get

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

Line 2084: CTO_MSG_PUB.Count_And_Get

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

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

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

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

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

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

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

Line 2919: CTO_MSG_PUB.Count_And_Get

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

Line 2929: CTO_MSG_PUB.Count_And_Get

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

Line 2945: CTO_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 3681: CTO_MSG_PUB.Count_And_Get(

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

Line 3692: CTO_MSG_PUB.Count_And_Get(

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

Line 4637: cto_msg_pub.count_and_get

4633: ( 'CTO_WORKFLOW',
4634: 'chk_all_rsv_details'
4635: );
4636: end if;
4637: cto_msg_pub.count_and_get
4638: (
4639: p_msg_count=>x_msg_count,
4640: p_msg_data=>x_msg_data
4641: );

Line 5429: cto_msg_pub.count_and_get

5425: || to_char(lStmtNum), 1);
5426: END IF;
5427: x_return_status := FND_API.G_RET_STS_ERROR;
5428: -- Get message count and data
5429: cto_msg_pub.count_and_get
5430: ( p_msg_count => x_msg_count
5431: , p_msg_data => x_msg_data
5432: );
5433: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5440: cto_msg_pub.count_and_get

5436: || to_char(lStmtNum), 1);
5437: END IF;
5438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5439: -- Get message count and data
5440: cto_msg_pub.count_and_get
5441: ( p_msg_count => x_msg_count
5442: , p_msg_data => x_msg_data
5443: );
5444: WHEN OTHERS then

Line 5453: cto_msg_pub.count_and_get

5449: oe_debug_pub.add('check_cto_can_create_supply: ' || 'errormsg='||sqlerrm, 1);
5450: END IF;
5451: x_return_status := FND_API.G_RET_STS_UNEXP_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:

Line 7051: cto_msg_pub.count_and_get

7047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
7048: oe_debug_pub.add('lock_for_match: ' || 'Unexpected Error.');
7049: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7050: -- Get message count and data
7051: cto_msg_pub.count_and_get
7052: ( p_msg_count => xMsgCount
7053: , p_msg_data => xMsgData
7054: );
7055: WHEN OTHERS then

Line 7059: cto_msg_pub.count_and_get

7055: WHEN OTHERS then
7056: oe_debug_pub.add('lock_for_match: ' || 'Others Exception : ' || sqlerrm);
7057: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7058: -- Get message count and data
7059: cto_msg_pub.count_and_get
7060: ( p_msg_count => xMsgCount
7061: , p_msg_data => xMsgData
7062: );
7063: END;

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

7106: --if success (status = 0) or session does not own lock (status=4),
7107: -- do nothing
7108: --if parameter error or illegal lock handle (internal error)
7109: if l_status IN (3,5) THEN
7110: cto_msg_pub.cto_message('BOM','BOM_LOCK_RELEASE_ERROR');
7111: RAISE fnd_api.g_exc_error;
7112: end if;
7113:
7114: x_return_status := l_return_status;

Line 7412: cto_msg_pub.count_and_get

7408: || to_char(lStmtNum), 1);
7409: END IF;
7410: x_return_status := FND_API.G_RET_STS_ERROR;
7411: -- Get message count and data
7412: cto_msg_pub.count_and_get
7413: ( p_msg_count => x_msg_count
7414: , p_msg_data => x_msg_data
7415: );
7416: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7423: cto_msg_pub.count_and_get

7419: || to_char(lStmtNum), 1);
7420: END IF;
7421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7422: -- Get message count and data
7423: cto_msg_pub.count_and_get
7424: ( p_msg_count => x_msg_count
7425: , p_msg_data => x_msg_data
7426: );
7427: WHEN OTHERS then

Line 7436: cto_msg_pub.count_and_get

7432: || to_char(lStmtNum), 1);
7433: END IF;
7434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7435: -- Get message count and data
7436: cto_msg_pub.count_and_get
7437: ( p_msg_count => x_msg_count
7438: , p_msg_data => x_msg_data
7439: );
7440: END Get_Resv_Qty;