APPS.CTO_CHANGE_ORDER_PK dependencies on CTO_MSG_PUB

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

749:
750: Exception When No_data_found then
751: oe_debug_pub.add('Change Notify: New Ship from org '||pchgtype(i).new_value||' is not valid',1);
752: l_valid_ship_from_org := 'N';
753: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
754: raise FND_API.G_EXC_ERROR;
755: End;
756: Else
757: oe_debug_pub.add('Change_Notify : Item is not option Specific...',1);

Line 1063: CTO_MSG_PUB.cto_message('BOM',x_err_name);

1059: IF PG_DEBUG <> 0 THEN
1060: oe_debug_pub.add('Change_Notify: ' || 'Delink failed....',5);
1061: END IF;
1062:
1063: CTO_MSG_PUB.cto_message('BOM',x_err_name);
1064: raise FND_API.G_EXC_ERROR;
1065:
1066: END IF;
1067:

Line 1196: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

1192: WHEN FND_API.G_EXC_ERROR THEN
1193: IF PG_DEBUG <> 0 THEN
1194: oe_debug_pub.add('Change_Notify: ' || 'Expected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1195: END IF;
1196: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1197: p_msg_data => X_Msg_Data);
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199:
1200:

Line 1205: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1202: IF PG_DEBUG <> 0 THEN
1203: oe_debug_pub.add('Change_Notify: ' || 'UnExpected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1204: END IF;
1205: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1206: p_msg_data => X_Msg_Data);
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1208:
1209:

Line 1216: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

1212: oe_debug_pub.add('Change_Notify: ' || 'OTHERS excepn in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1213:
1214: oe_debug_pub.add('Change_Notify: ' || 'The error message is ..'||sqlerrm,2);
1215: END IF;
1216: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1217: p_msg_data => X_Msg_Data);
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1219:
1220: End CHANGE_NOTIFY;

Line 2151: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,

2147: -- x_return_status := FND_API.G_RET_STS_ERROR;
2148: IF PG_DEBUG <> 0 THEN
2149: oe_debug_pub.add('start_work_flow: ' || 'Expected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2150: END IF;
2151: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2152: p_msg_data => x_msg_data);
2153:
2154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2155: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2159: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,

2155: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2156: IF PG_DEBUG <> 0 THEN
2157: oe_debug_pub.add('start_work_flow: ' || 'UnExpected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2158: END IF;
2159: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2160: p_msg_data => x_msg_data);
2161:
2162: WHEN OTHERS THEN
2163: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2169: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,

2165: oe_debug_pub.add('start_work_flow: ' || 'OTHERS excpn in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2166:
2167: oe_debug_pub.add('start_work_flow: ' || 'Error Message is : '||Sqlerrm);
2168: END IF;
2169: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2170: p_msg_data => x_msg_data);
2171:
2172:
2173: END start_work_flow;

Line 2324: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

2320: WHEN FND_API.G_EXC_ERROR THEN
2321: IF PG_DEBUG <> 0 THEN
2322: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'Expected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2323: END IF;
2324: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2325: p_msg_Data => X_Msg_Data);
2326: x_return_status := FND_API.G_RET_STS_ERROR;
2327:
2328:

Line 2333: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

2329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2330: IF PG_DEBUG <> 0 THEN
2331: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'UnExpected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2332: END IF;
2333: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2334: p_msg_Data => X_Msg_Data);
2335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2336:
2337:

Line 2466: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

2462: x_return_status := FND_API.G_RET_STS_ERROR;
2463: IF PG_DEBUG <> 0 THEN
2464: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2465: END IF;
2466: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2467: p_msg_Data => X_Msg_Data);
2468:
2469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2474: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2471: IF PG_DEBUG <> 0 THEN
2472: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'UnExpected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2473: END IF;
2474: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2475: p_msg_Data => X_Msg_Data);
2476:
2477: WHEN OTHERS THEN
2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2484: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

2480: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'OTHERS excpn in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2481:
2482: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Error Message is : '||sqlerrm);
2483: END IF;
2484: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2485: p_msg_Data => X_Msg_Data);
2486: END Pto_Ato_Config_Wrapper;
2487:
2488: