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.ENG_WORKFLOW_UTIL dependencies on FND_API

Line 106: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS)

102: );
103:
104: FND_FILE.put_line(FND_FILE.LOG, 'Log file location --> '||l_log_output_dir||'/'||g_debug_filename ||' created with status '|| l_log_return_status);
105:
106: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS)
107: THEN
108: FND_FILE.put_line(FND_FILE.LOG, 'Unable to open error log file. Error => '||l_errbuff) ;
109: END IF;
110:

Line 149: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

145: -- FND_MSG_PUB.Add_Exc_Msg
146: -- ( G_PKG_NAME ,
147: -- 'Open_Debug_Session' ,
148: -- l_error_mesg ) ;
149: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
150:
151: FND_FILE.put_line(FND_FILE.LOG, G_PKG_NAME || ' Open_Debug_Session: LOGGING ERROR > '||l_error_mesg);
152: g_debug_flag := FALSE;
153: RETURN;

Line 168: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

164: WHEN OTHERS THEN
165: g_debug_errmesg := Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240);
166: FND_FILE.put_line(FND_FILE.LOG, 'LOGGING SQL ERROR => '||g_debug_errmesg);
167: g_debug_flag := FALSE;
168: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
169:
170: END Open_Debug_Session ;
171:
172:

Line 195: OR FND_API.to_Boolean(p_debug_flag)

191: g_profile_debug_option := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), TO_CHAR(0));
192: g_profile_debug_level := NVL(FND_PROFILE.VALUE('INV_DEBUG_LEVEL'), TO_CHAR(0));
193:
194: IF (g_profile_debug_option = '1' AND TO_NUMBER(g_profile_debug_level) >= 20)
195: OR FND_API.to_Boolean(p_debug_flag)
196: THEN
197:
198: ----------------------------------------------------------------------------------
199: -- Opens Error_Handler debug session, only if Debug session is not already open.

Line 244: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

240: -- ( G_PKG_NAME ,
241: -- 'Close_Debug_Session' ,
242: -- l_error_mesg ) ;
243: --
244: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
245:
246: END Close_Debug_Session ;
247:
248: -- Test Debug

Line 297: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

293: -- ( G_PKG_NAME ,
294: -- 'Write_Debug' ,
295: -- l_error_mesg ) ;
296: --
297: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
298:
299: END Write_Debug;
300:
301: PROCEDURE Get_Debug_Mode

Line 322: IF FND_API.to_Boolean( l_debug_flag ) THEN

318: , p_item_key
319: , '.DEBUG_FLAG'
320: );
321:
322: IF FND_API.to_Boolean( l_debug_flag ) THEN
323: x_debug_flag := TRUE ;
324: END IF ;
325:
326:

Line 4006: x_return_status := FND_API.G_RET_STS_SUCCESS;

4002: l_header BOOLEAN := TRUE ;
4003:
4004: BEGIN
4005:
4006: x_return_status := FND_API.G_RET_STS_SUCCESS;
4007: l_user_id := p_wf_user_id ;
4008:
4009: SELECT meaning
4010: INTO l_approval_status

Line 4236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4232: IF g_debug_flag THEN
4233: Write_Debug('When Others in SetChangeApprovalStatus ' || SQLERRM );
4234: END IF ;
4235:
4236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4237: IF FND_MSG_PUB.Check_Msg_Level
4238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4239: THEN
4240: FND_MSG_PUB.Add_Exc_Msg

Line 4294: l_return_status := FND_API.G_RET_STS_SUCCESS;

4290:
4291: BEGIN
4292:
4293: -- Initialize API return status to success
4294: l_return_status := FND_API.G_RET_STS_SUCCESS;
4295: x_return_status := FND_API.G_RET_STS_SUCCESS;
4296:
4297:
4298: -- Get Lines for this Header

Line 4295: x_return_status := FND_API.G_RET_STS_SUCCESS;

4291: BEGIN
4292:
4293: -- Initialize API return status to success
4294: l_return_status := FND_API.G_RET_STS_SUCCESS;
4295: x_return_status := FND_API.G_RET_STS_SUCCESS;
4296:
4297:
4298: -- Get Lines for this Header
4299: FOR l_line_rec IN c_lines (p_change_id)

Line 4324: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4320: , p_wf_user_id => p_wf_user_id
4321: , p_new_appr_status_type => p_header_appr_status_type
4322: ) ;
4323:
4324: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4325: THEN
4326:
4327: x_return_status := l_return_status ;
4328:

Line 4343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4339: IF g_debug_flag THEN
4340: Write_Debug('When Others in SyncLineApprovalStatus ' || SQLERRM );
4341: END IF ;
4342:
4343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4344: IF FND_MSG_PUB.Check_Msg_Level
4345: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4346: THEN
4347: FND_MSG_PUB.Add_Exc_Msg

Line 4363: , p_init_route IN VARCHAR2 := FND_API.G_FALSE

4359: , p_item_key IN VARCHAR2
4360: , p_wf_user_id IN NUMBER
4361: , p_route_id IN NUMBER
4362: , p_new_status_code IN VARCHAR2
4363: , p_init_route IN VARCHAR2 := FND_API.G_FALSE
4364: , p_change_id IN NUMBER := NULL
4365: , p_change_line_id IN NUMBER := NULL
4366: )
4367: IS

Line 4411: IF FND_API.To_Boolean( p_init_route )

4407: END IF ;
4408:
4409:
4410: -- Check if this call is to initialize Route Process
4411: IF FND_API.To_Boolean( p_init_route )
4412: AND p_change_id IS NOT NULL
4413: AND p_change_id > 0
4414: THEN
4415: -- Get Current Change Revision

Line 4503: , p_init_msg_list => FND_API.G_FALSE

4499: ( p_api_version => 1.0
4500: , x_return_status => l_return_status
4501: , x_msg_count => l_msg_count
4502: , x_msg_data => l_msg_data
4503: , p_init_msg_list => FND_API.G_FALSE
4504: , p_commit => FND_API.G_FALSE
4505: , p_action_type => Eng_Workflow_Util.G_LINE_ACT_CHG_STATUS
4506: , p_object_name => Eng_Workflow_Util.G_ENG_CHANGE_LINE
4507: , p_object_id1 => p_change_id

Line 4504: , p_commit => FND_API.G_FALSE

4500: , x_return_status => l_return_status
4501: , x_msg_count => l_msg_count
4502: , x_msg_data => l_msg_data
4503: , p_init_msg_list => FND_API.G_FALSE
4504: , p_commit => FND_API.G_FALSE
4505: , p_action_type => Eng_Workflow_Util.G_LINE_ACT_CHG_STATUS
4506: , p_object_name => Eng_Workflow_Util.G_ENG_CHANGE_LINE
4507: , p_object_id1 => p_change_id
4508: , p_object_id2 => p_change_line_id

Line 4527: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4523: Write_Debug('After Creating Line Status Action Log: return status ' || l_return_status
4524: || '- Act Id:' || to_char(l_line_stat_chg_act_id) );
4525: END IF ;
4526:
4527: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4528: THEN
4529: RAISE FND_API.G_EXC_ERROR ;
4530: END IF ;
4531:

Line 4529: RAISE FND_API.G_EXC_ERROR ;

4525: END IF ;
4526:
4527: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4528: THEN
4529: RAISE FND_API.G_EXC_ERROR ;
4530: END IF ;
4531:
4532:
4533: -- 3. Start Line Status Change Workflow

Line 4541: , p_init_msg_list => FND_API.G_FALSE

4537:
4538: -- Create and Start Line Status Change Workflow to send Resp FYI ntf
4539: Eng_Workflow_Util.StartWorkflow
4540: ( p_api_version => 1.0
4541: , p_init_msg_list => FND_API.G_FALSE
4542: , p_commit => FND_API.G_FALSE
4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4544: , x_return_status => l_return_status
4545: , x_msg_count => l_msg_count

Line 4542: , p_commit => FND_API.G_FALSE

4538: -- Create and Start Line Status Change Workflow to send Resp FYI ntf
4539: Eng_Workflow_Util.StartWorkflow
4540: ( p_api_version => 1.0
4541: , p_init_msg_list => FND_API.G_FALSE
4542: , p_commit => FND_API.G_FALSE
4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4544: , x_return_status => l_return_status
4545: , x_msg_count => l_msg_count
4546: , x_msg_data => l_msg_data

Line 4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

4539: Eng_Workflow_Util.StartWorkflow
4540: ( p_api_version => 1.0
4541: , p_init_msg_list => FND_API.G_FALSE
4542: , p_commit => FND_API.G_FALSE
4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4544: , x_return_status => l_return_status
4545: , x_msg_count => l_msg_count
4546: , x_msg_data => l_msg_data
4547: , p_item_type => Eng_Workflow_Util.G_CHANGE_LINE_ACTION_ITEM_TYPE

Line 4557: , p_debug => FND_API.G_FALSE

4553: , p_host_url => NULL
4554: , p_action_id => l_line_stat_chg_act_id
4555: , p_route_id => 0
4556: , p_route_step_id => 0
4557: , p_debug => FND_API.G_FALSE
4558: , p_output_dir => NULL
4559: , p_debug_filename => 'Eng_LineStatChg_Start.log'
4560: ) ;
4561:

Line 4850: x_return_status := FND_API.G_RET_STS_SUCCESS;

4846:
4847: BEGIN
4848:
4849: -- Initialize API return status to success
4850: x_return_status := FND_API.G_RET_STS_SUCCESS;
4851:
4852: l_change_id := p_change_id ;
4853:
4854: IF g_debug_flag THEN

Line 5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5719: Write_Debug('When Others in SetAttributes ' || SQLERRM );
5720: END IF ;
5721:
5722:
5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5724: IF FND_MSG_PUB.Check_Msg_Level
5725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5726: THEN
5727: FND_MSG_PUB.Add_Exc_Msg

Line 5759: l_return_status := FND_API.G_RET_STS_SUCCESS;

5755:
5756: BEGIN
5757:
5758: -- Initialize API return status to success
5759: l_return_status := FND_API.G_RET_STS_SUCCESS;
5760:
5761:
5762: FOR step_rec IN c_route_req_date(p_route_id => p_route_id)
5763: LOOP

Line 5771: l_return_status := FND_API.G_RET_STS_ERROR ;

5767: -- for bug fix3456536
5768: IF step_rec.required_date < SYSDATE THEN
5769:
5770:
5771: l_return_status := FND_API.G_RET_STS_ERROR ;
5772:
5773: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_REQDATE_INVALID') ;
5774: FND_MESSAGE.SET_TOKEN('STEP_SEQ_NUM', step_rec.step_seq_num );
5775: FND_MSG_PUB.Add ;

Line 5785: l_return_status := FND_API.G_RET_STS_ERROR ;

5781: IF step_rec.required_date < l_pre_require_date
5782: THEN
5783:
5784:
5785: l_return_status := FND_API.G_RET_STS_ERROR ;
5786:
5787: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_REQDATE_LESS') ;
5788: FND_MESSAGE.SET_TOKEN('STEP_SEQ_NUM', step_rec.step_seq_num );
5789: FND_MSG_PUB.Add ;

Line 5808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5804:
5805:
5806: END LOOP ;
5807:
5808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5809:
5810: RETURN FALSE ;
5811:
5812: END IF ;

Line 5855: l_return_status := FND_API.G_RET_STS_SUCCESS;

5851:
5852:
5853:
5854: BEGIN
5855: l_return_status := FND_API.G_RET_STS_SUCCESS;
5856:
5857:
5858: -- Check Route Status
5859: FOR route_rec IN c_route_status(p_route_id => p_route_id)

Line 5862: l_return_status := FND_API.G_RET_STS_ERROR ;

5858: -- Check Route Status
5859: FOR route_rec IN c_route_status(p_route_id => p_route_id)
5860: LOOP
5861:
5862: l_return_status := FND_API.G_RET_STS_ERROR ;
5863:
5864: IF p_change_line_id IS NOT NULL AND p_change_line_id > 0
5865: THEN
5866:

Line 5897: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5893:
5894: END LOOP ;
5895:
5896:
5897: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5898:
5899: RETURN FALSE ;
5900:
5901: END IF ;

Line 5907: l_return_status := FND_API.G_RET_STS_ERROR ;

5903: -- Check Route is instance
5904: FOR route_rec IN c_route_instance(p_route_id => p_route_id)
5905: LOOP
5906:
5907: l_return_status := FND_API.G_RET_STS_ERROR ;
5908:
5909: -- Set Error Message for Header
5910: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_NOT_INSTANCE') ;
5911: FND_MSG_PUB.Add ;

Line 5916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5912:
5913: END LOOP ;
5914:
5915:
5916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5917:
5918: RETURN FALSE ;
5919:
5920: END IF ;

Line 5963: l_return_status := FND_API.G_RET_STS_SUCCESS;

5959:
5960: BEGIN
5961:
5962: -- Initialize API return status to success
5963: l_return_status := FND_API.G_RET_STS_SUCCESS;
5964:
5965:
5966: FOR route_rec IN c_route_assignees(p_route_id => p_route_id)
5967: LOOP

Line 5969: l_return_status := FND_API.G_RET_STS_ERROR ;

5965:
5966: FOR route_rec IN c_route_assignees(p_route_id => p_route_id)
5967: LOOP
5968:
5969: l_return_status := FND_API.G_RET_STS_ERROR ;
5970:
5971: IF p_change_line_id IS NOT NULL AND p_change_line_id > 0
5972: THEN
5973:

Line 6006: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6002:
6003:
6004: END LOOP ;
6005:
6006: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6007:
6008: RETURN FALSE ;
6009:
6010: END IF ;

Line 6035: l_return_status := FND_API.G_RET_STS_SUCCESS;

6031: route_rec c_Mandatory_route_assignees%rowtype;
6032: BEGIN
6033:
6034: -- Initialize API return status to success
6035: l_return_status := FND_API.G_RET_STS_SUCCESS;
6036:
6037: OPEN c_Mandatory_route_assignees(p_route_id => p_route_id) ;
6038: FETCH c_Mandatory_route_assignees into route_rec;
6039:

Line 6041: l_return_status := FND_API.G_RET_STS_ERROR ;

6037: OPEN c_Mandatory_route_assignees(p_route_id => p_route_id) ;
6038: FETCH c_Mandatory_route_assignees into route_rec;
6039:
6040: IF (c_Mandatory_route_assignees%found) THEN
6041: l_return_status := FND_API.G_RET_STS_ERROR ;
6042:
6043: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_MANDAT_ASSIGN_MISS') ;
6044: --fnd_message.SET_TOKEN ('STEP_NO',route_rec.STEP_SEQ_NUM , TRUE);
6045: FND_MSG_PUB.Add ;

Line 6049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6045: FND_MSG_PUB.Add ;
6046:
6047: END IF ;
6048:
6049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6050:
6051: RETURN FALSE ;
6052:
6053: END IF ;

Line 6062: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6058:
6059:
6060:
6061: PROCEDURE ValidateProcess
6062: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6063: , x_return_status OUT NOCOPY VARCHAR2
6064: , x_msg_count OUT NOCOPY NUMBER
6065: , x_msg_data OUT NOCOPY VARCHAR2
6066: , p_item_type IN VARCHAR2

Line 6102: x_return_status := FND_API.G_RET_STS_SUCCESS;

6098:
6099: BEGIN
6100:
6101: -- Initialize API return status to success
6102: x_return_status := FND_API.G_RET_STS_SUCCESS;
6103:
6104: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN
6105: RETURN ;
6106: END IF ;

Line 6104: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN

6100:
6101: -- Initialize API return status to success
6102: x_return_status := FND_API.G_RET_STS_SUCCESS;
6103:
6104: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN
6105: RETURN ;
6106: END IF ;
6107:
6108: -- Item Type: ALL

Line 6157: , p_init_msg_list => FND_API.G_FALSE --

6153: END IF ;
6154:
6155: ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF
6156: ( p_api_version => 1.0
6157: , p_init_msg_list => FND_API.G_FALSE --
6158: , p_commit => FND_API.G_FALSE --
6159: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6160: , x_return_status => l_return_status
6161: , x_msg_count => l_msg_count

Line 6158: , p_commit => FND_API.G_FALSE --

6154:
6155: ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF
6156: ( p_api_version => 1.0
6157: , p_init_msg_list => FND_API.G_FALSE --
6158: , p_commit => FND_API.G_FALSE --
6159: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6160: , x_return_status => l_return_status
6161: , x_msg_count => l_msg_count
6162: , x_msg_data => l_msg_data

Line 6159: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

6155: ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF
6156: ( p_api_version => 1.0
6157: , p_init_msg_list => FND_API.G_FALSE --
6158: , p_commit => FND_API.G_FALSE --
6159: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6160: , x_return_status => l_return_status
6161: , x_msg_count => l_msg_count
6162: , x_msg_data => l_msg_data
6163: , p_change_id => p_change_id -- Change Id

Line 6171: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

6167:
6168: IF g_debug_flag THEN
6169: Write_Debug('After calling ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF: ' || l_return_status );
6170: END IF ;
6171: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
6172: THEN
6173: x_return_status := l_return_status ;
6174: END IF ;
6175:

Line 6183: x_return_status := FND_API.G_RET_STS_ERROR ;

6179:
6180:
6181: IF NOT CheckMandatoryAssignee(p_route_id => p_route_id)
6182: THEN
6183: x_return_status := FND_API.G_RET_STS_ERROR ;
6184: END IF;
6185:
6186:
6187: /*

Line 6199: x_return_status := FND_API.G_RET_STS_ERROR ;

6195: -- 2. the greater step num, the later required date
6196: IF NOT CheckRouteStepRequiredDate(p_route_id => p_route_id)
6197: THEN
6198:
6199: x_return_status := FND_API.G_RET_STS_ERROR ;
6200:
6201: END IF ;
6202: */
6203:

Line 6217: x_return_status := FND_API.G_RET_STS_ERROR ;

6213: Write_Debug('Verify Route is Instance . . .');
6214: END IF ;
6215:
6216:
6217: x_return_status := FND_API.G_RET_STS_ERROR ;
6218:
6219: END IF ;
6220:
6221:

Line 6235: x_return_status := FND_API.G_RET_STS_ERROR ;

6231: IF g_debug_flag THEN
6232: Write_Debug('Verify there is not missing assignee . . .');
6233: END IF ;
6234:
6235: x_return_status := FND_API.G_RET_STS_ERROR ;
6236:
6237: END IF ;
6238: */
6239:

Line 6257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6253:
6254: EXCEPTION
6255: WHEN OTHERS THEN
6256:
6257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6258: IF FND_MSG_PUB.Check_Msg_Level
6259: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6260: THEN
6261: FND_MSG_PUB.Add_Exc_Msg

Line 6271: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6267: END ValidateProcess;
6268:
6269:
6270: PROCEDURE ValidateAbortingProcess
6271: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6272: , x_return_status OUT NOCOPY VARCHAR2
6273: , x_msg_count OUT NOCOPY NUMBER
6274: , x_msg_data OUT NOCOPY VARCHAR2
6275: , p_item_type IN VARCHAR2

Line 6288: x_return_status := FND_API.G_RET_STS_SUCCESS;

6284:
6285: BEGIN
6286:
6287: -- Initialize API return status to success
6288: x_return_status := FND_API.G_RET_STS_SUCCESS;
6289:
6290: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN
6291: RETURN ;
6292: END IF ;

Line 6290: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN

6286:
6287: -- Initialize API return status to success
6288: x_return_status := FND_API.G_RET_STS_SUCCESS;
6289:
6290: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN
6291: RETURN ;
6292: END IF ;
6293:
6294:

Line 6318: x_return_status := FND_API.G_RET_STS_ERROR ;

6314:
6315: IF l_status = G_WF_COMPLETE
6316: THEN
6317:
6318: x_return_status := FND_API.G_RET_STS_ERROR ;
6319:
6320: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_WF_NOT_RUNNING') ;
6321: FND_MSG_PUB.Add ;
6322:

Line 6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6324:
6325: EXCEPTION
6326: WHEN OTHERS THEN
6327:
6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6329: IF FND_MSG_PUB.Check_Msg_Level
6330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6331: THEN
6332: FND_MSG_PUB.Add_Exc_Msg

Line 6371: x_return_status := FND_API.G_RET_STS_SUCCESS;

6367:
6368: BEGIN
6369:
6370: -- Initialize API return status to success
6371: x_return_status := FND_API.G_RET_STS_SUCCESS;
6372:
6373: -- Get Adhoc Party List
6374: list_rest := LTRIM(p_adhoc_party_list) ;
6375: LOOP

Line 6442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6438:
6439: EXCEPTION
6440: WHEN OTHERS THEN
6441:
6442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6443: IF FND_MSG_PUB.Check_Msg_Level
6444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6445: THEN
6446: FND_MSG_PUB.Add_Exc_Msg

Line 6491: x_return_status := FND_API.G_RET_STS_SUCCESS;

6487: END IF ;
6488:
6489:
6490: -- Initialize API return status to success
6491: x_return_status := FND_API.G_RET_STS_SUCCESS;
6492:
6493: -- Get Change Object Identifier
6494: GetChangeObject
6495: ( p_item_type => p_item_type

Line 6557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6553:
6554: EXCEPTION
6555: WHEN OTHERS THEN
6556:
6557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6558: IF FND_MSG_PUB.Check_Msg_Level
6559: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6560: THEN
6561: FND_MSG_PUB.Add_Exc_Msg

Line 6613: x_return_status := FND_API.G_RET_STS_SUCCESS;

6609:
6610:
6611:
6612: -- Initialize API return status to success
6613: x_return_status := FND_API.G_RET_STS_SUCCESS;
6614:
6615: IF g_debug_flag THEN
6616: Write_Debug('Get Change Object Identifier . . . ' );
6617: END IF ;

Line 6726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6722:
6723: EXCEPTION
6724: WHEN OTHERS THEN
6725:
6726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6727: IF FND_MSG_PUB.Check_Msg_Level
6728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6729: THEN
6730: FND_MSG_PUB.Add_Exc_Msg

Line 6767: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

6763:
6764: l_return_status VARCHAR2(1) ;
6765: l_line_item_key VARCHAR2(240) ;
6766: l_change_id NUMBER ;
6767: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
6768: l_output_dir VARCHAR2(240) := '' ;
6769: l_debug_filename VARCHAR2(200) := 'StartAllLineWorkflows.log' ;
6770:
6771: CURSOR c_lines (p_change_id NUMBER)

Line 6795: l_return_status := FND_API.G_RET_STS_SUCCESS;

6791: Write_Debug('-----------------------------------------------------');
6792: END IF ;
6793:
6794: -- Initialize API return status to success
6795: l_return_status := FND_API.G_RET_STS_SUCCESS;
6796: x_return_status := FND_API.G_RET_STS_SUCCESS;
6797:
6798:
6799: --

Line 6796: x_return_status := FND_API.G_RET_STS_SUCCESS;

6792: END IF ;
6793:
6794: -- Initialize API return status to success
6795: l_return_status := FND_API.G_RET_STS_SUCCESS;
6796: x_return_status := FND_API.G_RET_STS_SUCCESS;
6797:
6798:
6799: --
6800: -- Don't try to get Parent Item Attributes from this procedure

Line 6818: , p_init_msg_list => FND_API.G_FALSE

6814: -- Start Change Line Workflows
6815: -- FND_MSG_PUB.initialize ;
6816: Eng_Workflow_Util.StartWorkflow
6817: ( p_api_version => 1.0
6818: , p_init_msg_list => FND_API.G_FALSE
6819: , p_commit => FND_API.G_FALSE
6820: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6821: , x_return_status => l_return_status
6822: , x_msg_count => x_msg_count

Line 6819: , p_commit => FND_API.G_FALSE

6815: -- FND_MSG_PUB.initialize ;
6816: Eng_Workflow_Util.StartWorkflow
6817: ( p_api_version => 1.0
6818: , p_init_msg_list => FND_API.G_FALSE
6819: , p_commit => FND_API.G_FALSE
6820: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6821: , x_return_status => l_return_status
6822: , x_msg_count => x_msg_count
6823: , x_msg_data => x_msg_data

Line 6820: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

6816: Eng_Workflow_Util.StartWorkflow
6817: ( p_api_version => 1.0
6818: , p_init_msg_list => FND_API.G_FALSE
6819: , p_commit => FND_API.G_FALSE
6820: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6821: , x_return_status => l_return_status
6822: , x_msg_count => x_msg_count
6823: , x_msg_data => x_msg_data
6824: , p_item_type => p_line_item_type

Line 6837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

6833: , p_output_dir => l_output_dir
6834: , p_debug_filename => l_debug_filename || TO_CHAR(line_rec.change_line_id)
6835: ) ;
6836:
6837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
6838: THEN
6839:
6840: x_return_status := l_return_status ;
6841:

Line 6859: IF x_return_status = FND_API.G_RET_STS_SUCCESS

6855: END LOOP ;
6856:
6857:
6858:
6859: IF x_return_status = FND_API.G_RET_STS_SUCCESS
6860: THEN
6861:
6862: -- COMMENT OUT PRAGMA AUTONOMOUS_TRANSACTION
6863: -- COMMIT ;

Line 6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

6866: ELSE
6867:
6868: -- COMMENT OUT PRAGMA AUTONOMOUS_TRANSACTION
6869: -- ROLLBACK ;
6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6871:
6872: END IF ;
6873:
6874:

Line 6878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6874:
6875: EXCEPTION
6876: WHEN OTHERS THEN
6877: -- ROLLBACK ;
6878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6879:
6880: IF FND_MSG_PUB.Check_Msg_Level
6881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6882: THEN

Line 6925: x_return_status := FND_API.G_RET_STS_SUCCESS;

6921: Write_Debug('-----------------------------------------------------');
6922: END IF ;
6923:
6924: -- Initialize API return status to success
6925: x_return_status := FND_API.G_RET_STS_SUCCESS;
6926:
6927: -- Get Change Line Object Identifier
6928: GetChangeLineObject
6929: ( p_item_type => p_item_type

Line 6987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6983:
6984: EXCEPTION
6985: WHEN OTHERS THEN
6986:
6987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6988: IF FND_MSG_PUB.Check_Msg_Level
6989: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6990: THEN
6991: FND_MSG_PUB.Add_Exc_Msg

Line 7045: x_return_status := FND_API.G_RET_STS_SUCCESS;

7041: END IF ;
7042:
7043:
7044: -- Initialize API return status to success
7045: x_return_status := FND_API.G_RET_STS_SUCCESS;
7046:
7047: IF g_debug_flag THEN
7048: Write_Debug('Get Change Header and Line Object Identifier . . . ' );
7049: END IF ;

Line 7169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7165:
7166: EXCEPTION
7167: WHEN OTHERS THEN
7168:
7169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7170: IF FND_MSG_PUB.Check_Msg_Level
7171: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7172: THEN
7173: FND_MSG_PUB.Add_Exc_Msg

Line 7225: x_return_status := FND_API.G_RET_STS_SUCCESS;

7221: END IF ;
7222:
7223:
7224: -- Initialize API return status to success
7225: x_return_status := FND_API.G_RET_STS_SUCCESS;
7226:
7227: -- Get Route Route Id
7228: GetRouteId
7229: ( p_item_type => p_item_type

Line 7295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7291:
7292: EXCEPTION
7293: WHEN OTHERS THEN
7294:
7295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7296: IF FND_MSG_PUB.Check_Msg_Level
7297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7298: THEN
7299: FND_MSG_PUB.Add_Exc_Msg

Line 7351: x_return_status := FND_API.G_RET_STS_SUCCESS;

7347: END IF ;
7348:
7349:
7350: -- Initialize API return status to success
7351: x_return_status := FND_API.G_RET_STS_SUCCESS;
7352:
7353: -- Get Route Step Id
7354: GetRouteStepId
7355: ( p_item_type => p_item_type

Line 7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7403:
7404: EXCEPTION
7405: WHEN OTHERS THEN
7406:
7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7408: IF FND_MSG_PUB.Check_Msg_Level
7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7410: THEN
7411: FND_MSG_PUB.Add_Exc_Msg

Line 7448: x_return_status := FND_API.G_RET_STS_SUCCESS;

7444:
7445: BEGIN
7446:
7447: -- Initialize API return status to success
7448: x_return_status := FND_API.G_RET_STS_SUCCESS;
7449:
7450:
7451: -- Eng Workflow Adhoc Roles Pre-Fix
7452: -- G_ADHOC_PARTY_ROLE

Line 7524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7520:
7521: EXCEPTION
7522: WHEN OTHERS THEN
7523:
7524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7525: IF FND_MSG_PUB.Check_Msg_Level
7526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7527: THEN
7528: FND_MSG_PUB.Add_Exc_Msg

Line 7548: , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12

7544: , p_action_type IN VARCHAR2
7545: , p_comment IN VARCHAR2 := NULL
7546: , x_action_id OUT NOCOPY NUMBER
7547: , p_assignee_id IN NUMBER := NULL
7548: , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12
7549: )
7550: IS
7551:
7552: l_api_name CONSTANT VARCHAR2(30) := 'CreateAction';

Line 7589: x_return_status := FND_API.G_RET_STS_SUCCESS;

7585: -- Write_Debug('-----------------------------------------------------');
7586: --END IF ;
7587:
7588: -- Initialize API return status to success
7589: x_return_status := FND_API.G_RET_STS_SUCCESS;
7590:
7591: -- Get Change Object Identifier
7592: GetChangeObject
7593: ( p_item_type => p_item_type

Line 7693: -- , p_init_msg_list => FND_API.g_FALSE

7689: ( p_api_version => 1.0
7690: , x_return_status => x_return_status
7691: , x_msg_count => x_msg_count
7692: , x_msg_data => x_msg_data
7693: -- , p_init_msg_list => FND_API.g_FALSE
7694: -- , p_commit => FND_API.g_FALSE
7695: , p_action_type => p_action_type
7696: , p_object_name => l_object_name
7697: , p_object_id1 => l_change_id

Line 7694: -- , p_commit => FND_API.g_FALSE

7690: , x_return_status => x_return_status
7691: , x_msg_count => x_msg_count
7692: , x_msg_data => x_msg_data
7693: -- , p_init_msg_list => FND_API.g_FALSE
7694: -- , p_commit => FND_API.g_FALSE
7695: , p_action_type => p_action_type
7696: , p_object_name => l_object_name
7697: , p_object_id1 => l_change_id
7698: , p_object_id2 => l_change_line_id

Line 7725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7721:
7722: EXCEPTION
7723: WHEN OTHERS THEN
7724:
7725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7726:
7727: IF FND_MSG_PUB.Check_Msg_Level
7728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7729: THEN

Line 7759: , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12

7755: , p_object_id4 IN NUMBER := NULL
7756: , p_object_id5 IN NUMBER := NULL
7757: , p_parent_object_name IN VARCHAR2 := NULL
7758: , p_parent_object_id1 IN NUMBER := NULL
7759: , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12
7760: )
7761: IS
7762:
7763: l_api_name CONSTANT VARCHAR2(30) := 'CreateRouteAction';

Line 7799: x_return_status := FND_API.G_RET_STS_SUCCESS;

7795: Write_Debug('-----------------------------------------------------');
7796: END IF ;
7797:
7798: -- Initialize API return status to success
7799: x_return_status := FND_API.G_RET_STS_SUCCESS;
7800:
7801:
7802: IF p_change_line_id IS NOT NULL AND p_change_line_id > 0
7803: THEN

Line 7859: -- , p_init_msg_list => FND_API.g_FALSE

7855: ( p_api_version => 1.0
7856: , x_return_status => x_return_status
7857: , x_msg_count => x_msg_count
7858: , x_msg_data => x_msg_data
7859: -- , p_init_msg_list => FND_API.g_FALSE
7860: -- , p_commit => FND_API.g_FALSE
7861: , p_action_type => p_action_type
7862: , p_object_name => l_object_name
7863: , p_object_id1 => p_change_id

Line 7860: -- , p_commit => FND_API.g_FALSE

7856: , x_return_status => x_return_status
7857: , x_msg_count => x_msg_count
7858: , x_msg_data => x_msg_data
7859: -- , p_init_msg_list => FND_API.g_FALSE
7860: -- , p_commit => FND_API.g_FALSE
7861: , p_action_type => p_action_type
7862: , p_object_name => l_object_name
7863: , p_object_id1 => p_change_id
7864: , p_object_id2 => l_change_line_id

Line 7891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7887:
7888: EXCEPTION
7889: WHEN OTHERS THEN
7890:
7891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7892:
7893: IF FND_MSG_PUB.Check_Msg_Level
7894: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7895: THEN

Line 7946: x_return_status := FND_API.G_RET_STS_SUCCESS;

7942: Write_Debug('-----------------------------------------------------');
7943: END IF ;
7944:
7945: -- Initialize API return status to success
7946: x_return_status := FND_API.G_RET_STS_SUCCESS;
7947:
7948:
7949: -- In case that we have to use PRAGMA AUTONOMOUS_TRANSACTION,
7950: -- DON'T try to get Data/Item Attributes updated

Line 7994: , p_commit => FND_API.g_FALSE

7990: -- properly if it return error based on some validation
7991: -- like Mandatory task is not completed on Auto Promotion
7992: ENG_CHANGE_LIFECYCLE_UTIL.Update_Lifecycle_States
7993: ( p_api_version => 1.0
7994: , p_commit => FND_API.g_FALSE
7995: , p_init_msg_list => FND_API.g_FALSE
7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7997: , p_debug => FND_API.G_FALSE
7998: , p_output_dir => NULL -- '/appslog/bis_top/utl/plm115dv/log'

Line 7995: , p_init_msg_list => FND_API.g_FALSE

7991: -- like Mandatory task is not completed on Auto Promotion
7992: ENG_CHANGE_LIFECYCLE_UTIL.Update_Lifecycle_States
7993: ( p_api_version => 1.0
7994: , p_commit => FND_API.g_FALSE
7995: , p_init_msg_list => FND_API.g_FALSE
7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7997: , p_debug => FND_API.G_FALSE
7998: , p_output_dir => NULL -- '/appslog/bis_top/utl/plm115dv/log'
7999: , p_debug_filename => NULL -- 'UpdateLCStatesFromWF.log' || to_char(p_route_id)

Line 7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7992: ENG_CHANGE_LIFECYCLE_UTIL.Update_Lifecycle_States
7993: ( p_api_version => 1.0
7994: , p_commit => FND_API.g_FALSE
7995: , p_init_msg_list => FND_API.g_FALSE
7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7997: , p_debug => FND_API.G_FALSE
7998: , p_output_dir => NULL -- '/appslog/bis_top/utl/plm115dv/log'
7999: , p_debug_filename => NULL -- 'UpdateLCStatesFromWF.log' || to_char(p_route_id)
8000: , x_return_status => l_return_status

Line 7997: , p_debug => FND_API.G_FALSE

7993: ( p_api_version => 1.0
7994: , p_commit => FND_API.g_FALSE
7995: , p_init_msg_list => FND_API.g_FALSE
7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7997: , p_debug => FND_API.G_FALSE
7998: , p_output_dir => NULL -- '/appslog/bis_top/utl/plm115dv/log'
7999: , p_debug_filename => NULL -- 'UpdateLCStatesFromWF.log' || to_char(p_route_id)
8000: , x_return_status => l_return_status
8001: , x_msg_count => l_msg_count

Line 8020: -- IF x_return_status = FND_API.G_RET_STS_SUCCESS

8016: END IF ;
8017:
8018:
8019: -- Comment Out Here
8020: -- IF x_return_status = FND_API.G_RET_STS_SUCCESS
8021: -- THEN
8022: -- COMMIT ;
8023: -- ELSE
8024: -- ROLLBACK ;

Line 8034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8030: WHEN OTHERS THEN
8031:
8032: -- ROLLBACK ;
8033:
8034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8035:
8036: IF FND_MSG_PUB.Check_Msg_Level
8037: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8038: THEN

Line 8135: x_return_status := FND_API.G_RET_STS_SUCCESS;

8131: Write_Debug('-----------------------------------------------------');
8132: END IF ;
8133:
8134: -- Initialize API return status to success
8135: x_return_status := FND_API.G_RET_STS_SUCCESS;
8136:
8137:
8138: -- Check if this is setting header or line
8139: IF p_change_line_id IS NOT NULL AND p_change_line_id > 0

Line 8209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8205:
8206: EXCEPTION
8207: WHEN OTHERS THEN
8208:
8209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8210:
8211: IF FND_MSG_PUB.Check_Msg_Level
8212: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8213: THEN

Line 8371: Check_And_Open_Debug_Session(p_debug_flag => FND_API.G_FALSE

8367:
8368: BEGIN
8369:
8370: -- For Test/Debug
8371: Check_And_Open_Debug_Session(p_debug_flag => FND_API.G_FALSE
8372: , p_output_dir => NULL
8373: , p_file_name => NULL
8374: ) ;
8375:

Line 8389: x_return_status := FND_API.G_RET_STS_SUCCESS;

8385: Write_Debug('-----------------------------------------------------');
8386: END IF ;
8387:
8388: -- Initialize API return status to success
8389: x_return_status := FND_API.G_RET_STS_SUCCESS;
8390:
8391: -- Initialize Table var
8392: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
8393: l_person_id_tbl := FND_TABLE_OF_NUMBER();

Line 8611: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8607: , p_action_type => l_action_type
8608: , x_action_id => l_created_action_id
8609: ) ;
8610:
8611: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8612:
8613: x_return_status := l_return_status ;
8614: x_msg_count := l_msg_count ;
8615: x_msg_data := l_msg_data ;

Line 8728: , p_init_msg_list => FND_API.G_FALSE --

8724:
8725:
8726: Eng_Workflow_Util.RevokeObjectRoles
8727: ( p_api_version => 1.0
8728: , p_init_msg_list => FND_API.G_FALSE --
8729: , p_commit => FND_API.G_FALSE --
8730: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8731: , p_debug => FND_API.G_FALSE
8732: , p_output_dir => NULL

Line 8729: , p_commit => FND_API.G_FALSE --

8725:
8726: Eng_Workflow_Util.RevokeObjectRoles
8727: ( p_api_version => 1.0
8728: , p_init_msg_list => FND_API.G_FALSE --
8729: , p_commit => FND_API.G_FALSE --
8730: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8731: , p_debug => FND_API.G_FALSE
8732: , p_output_dir => NULL
8733: , p_debug_filename => NULL

Line 8730: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

8726: Eng_Workflow_Util.RevokeObjectRoles
8727: ( p_api_version => 1.0
8728: , p_init_msg_list => FND_API.G_FALSE --
8729: , p_commit => FND_API.G_FALSE --
8730: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8731: , p_debug => FND_API.G_FALSE
8732: , p_output_dir => NULL
8733: , p_debug_filename => NULL
8734: , x_return_status => l_return_status

Line 8731: , p_debug => FND_API.G_FALSE

8727: ( p_api_version => 1.0
8728: , p_init_msg_list => FND_API.G_FALSE --
8729: , p_commit => FND_API.G_FALSE --
8730: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8731: , p_debug => FND_API.G_FALSE
8732: , p_output_dir => NULL
8733: , p_debug_filename => NULL
8734: , x_return_status => l_return_status
8735: , x_msg_count => l_msg_count

Line 8752: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

8748: Write_Debug('After Eng_Workflow_Util.RevokeObjectRoles.' || l_return_status );
8749: END IF ;
8750:
8751: --
8752: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
8753: -- THEN
8754: -- RAISE FND_API.G_EXC_ERROR ;
8755: -- END IF ;
8756:

Line 8754: -- RAISE FND_API.G_EXC_ERROR ;

8750:
8751: --
8752: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
8753: -- THEN
8754: -- RAISE FND_API.G_EXC_ERROR ;
8755: -- END IF ;
8756:
8757: END IF ; -- ( l_auto_revoke_resp IS NOT NULL AND p_response_code = l_auto_revoke_resp )
8758:

Line 8770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8766: IF g_debug_flag THEN
8767: Write_Debug('Eng_Workflow_Util.SetRouteResponse Unxexpected Error.' || SQLERRM);
8768: END IF ;
8769:
8770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8771:
8772: IF FND_MSG_PUB.Check_Msg_Level
8773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8774: THEN

Line 8826: x_return_status := FND_API.G_RET_STS_SUCCESS;

8822:
8823: BEGIN
8824:
8825: -- Initialize API return status to success
8826: x_return_status := FND_API.G_RET_STS_SUCCESS;
8827:
8828:
8829: OPEN c_next_step(p_route_id => p_route_id) ;
8830: FETCH c_next_step into recinfo;

Line 8850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8846:
8847: EXCEPTION
8848: WHEN OTHERS THEN
8849:
8850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8851:
8852: IF FND_MSG_PUB.Check_Msg_Level
8853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8854: THEN

Line 8899: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

8895: -- l_change_notice VARCHAR2(10) ;
8896: -- l_organization_id NUMBER ;
8897: -- l_wf_user_id NUMBER ;
8898: -- l_host_url VARCHAR2(256) ;
8899: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
8900: l_output_dir VARCHAR2(240) := NULL ;
8901: l_debug_filename VARCHAR2(200) := 'StartNextRouteStep.log' ;
8902:
8903:

Line 8918: x_return_status := FND_API.G_RET_STS_SUCCESS;

8914: Write_Debug('-----------------------------------------------------');
8915: END IF ;
8916:
8917: -- Initialize API return status to success
8918: x_return_status := FND_API.G_RET_STS_SUCCESS;
8919:
8920: --
8921: -- Don't try to get Parent Item Attributes from this procedure
8922: -- because this proc is setting PRAGMA AUTONOMOUS_TRANSACTION

Line 8951: , p_init_msg_list => FND_API.G_FALSE

8947:
8948: -- FND_MSG_PUB.initialize ;
8949: Eng_Workflow_Util.StartWorkflow
8950: ( p_api_version => 1.0
8951: , p_init_msg_list => FND_API.G_FALSE
8952: , p_commit => FND_API.G_FALSE
8953: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8954: , x_return_status => x_return_status
8955: , x_msg_count => x_msg_count

Line 8952: , p_commit => FND_API.G_FALSE

8948: -- FND_MSG_PUB.initialize ;
8949: Eng_Workflow_Util.StartWorkflow
8950: ( p_api_version => 1.0
8951: , p_init_msg_list => FND_API.G_FALSE
8952: , p_commit => FND_API.G_FALSE
8953: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8954: , x_return_status => x_return_status
8955: , x_msg_count => x_msg_count
8956: , x_msg_data => x_msg_data

Line 8953: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

8949: Eng_Workflow_Util.StartWorkflow
8950: ( p_api_version => 1.0
8951: , p_init_msg_list => FND_API.G_FALSE
8952: , p_commit => FND_API.G_FALSE
8953: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8954: , x_return_status => x_return_status
8955: , x_msg_count => x_msg_count
8956: , x_msg_data => x_msg_data
8957: , p_item_type => x_step_item_type

Line 8974: IF x_return_status = FND_API.G_RET_STS_SUCCESS

8970: , p_output_dir => l_output_dir
8971: , p_debug_filename => l_debug_filename
8972: ) ;
8973:
8974: IF x_return_status = FND_API.G_RET_STS_SUCCESS
8975: THEN
8976:
8977: -- COMMENT OUT PRAGMA AUTONOMOUS_TRANSACTION
8978: -- COMMIT ;

Line 8985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

8981: ELSE
8982:
8983: -- COMMENT OUT PRAGMA AUTONOMOUS_TRANSACTION
8984: -- ROLLBACK ;
8985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
8986:
8987: END IF ;
8988:
8989: IF g_debug_flag THEN

Line 9005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9001: WHEN OTHERS THEN
9002:
9003: -- ROLLBACK ;
9004:
9005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9006:
9007: IF FND_MSG_PUB.Check_Msg_Level
9008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9009: THEN

Line 9034: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

9030: l_msg_count NUMBER ;
9031: l_msg_data VARCHAR2(2000) ;
9032: l_return_status VARCHAR2(1) ;
9033:
9034: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
9035: l_output_dir VARCHAR2(240) := NULL ;
9036: l_debug_filename VARCHAR2(200) := 'AbortRouteSteps.log' ;
9037:
9038:

Line 9065: x_return_status := FND_API.G_RET_STS_SUCCESS;

9061: Write_Debug('-----------------------------------------------------');
9062: END IF ;
9063:
9064: -- Initialize API return status to success
9065: x_return_status := FND_API.G_RET_STS_SUCCESS;
9066:
9067: FOR abort_step_rec IN c_abort_step ( p_route_item_type => p_route_item_type
9068: , p_route_item_key => p_route_item_key )
9069: LOOP

Line 9081: , p_init_msg_list => FND_API.G_FALSE

9077:
9078:
9079: Eng_Workflow_Util.AbortWorkflow
9080: ( p_api_version => 1.0
9081: , p_init_msg_list => FND_API.G_FALSE
9082: , p_commit => FND_API.G_FALSE
9083: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9084: , x_return_status => l_return_status
9085: , x_msg_count => l_msg_count

Line 9082: , p_commit => FND_API.G_FALSE

9078:
9079: Eng_Workflow_Util.AbortWorkflow
9080: ( p_api_version => 1.0
9081: , p_init_msg_list => FND_API.G_FALSE
9082: , p_commit => FND_API.G_FALSE
9083: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9084: , x_return_status => l_return_status
9085: , x_msg_count => l_msg_count
9086: , x_msg_data => l_msg_data

Line 9083: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

9079: Eng_Workflow_Util.AbortWorkflow
9080: ( p_api_version => 1.0
9081: , p_init_msg_list => FND_API.G_FALSE
9082: , p_commit => FND_API.G_FALSE
9083: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9084: , x_return_status => l_return_status
9085: , x_msg_count => l_msg_count
9086: , x_msg_data => l_msg_data
9087: , p_item_type => abort_step_rec.wf_item_type

Line 9097: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

9093: , p_debug_filename => l_debug_filename
9094: ) ;
9095:
9096:
9097: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
9098: THEN
9099:
9100: x_return_status := l_return_status ;
9101: x_msg_count := NVL(l_msg_count, 0) + NVL(l_msg_count,0) ;

Line 9118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9114:
9115: EXCEPTION
9116: WHEN OTHERS THEN
9117:
9118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9119:
9120: IF FND_MSG_PUB.Check_Msg_Level
9121: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9122: THEN

Line 9154: x_return_status := FND_API.G_RET_STS_SUCCESS;

9150:
9151: BEGIN
9152:
9153: -- Initialize API return status to success
9154: x_return_status := FND_API.G_RET_STS_SUCCESS;
9155:
9156:
9157:
9158: EGO_SECURITY_PUB.grant_role_guid

Line 9182: IF ( l_return_status = FND_API.G_TRUE OR

9178: --
9179: -- EGO Security pub returns T if the action is success
9180: -- and F on failure
9181: --
9182: IF ( l_return_status = FND_API.G_TRUE OR
9183: l_return_status = FND_API.G_FALSE )
9184: THEN
9185:
9186: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9183: l_return_status = FND_API.G_FALSE )

9179: -- EGO Security pub returns T if the action is success
9180: -- and F on failure
9181: --
9182: IF ( l_return_status = FND_API.G_TRUE OR
9183: l_return_status = FND_API.G_FALSE )
9184: THEN
9185:
9186: x_return_status := FND_API.G_RET_STS_SUCCESS;
9187:

Line 9186: x_return_status := FND_API.G_RET_STS_SUCCESS;

9182: IF ( l_return_status = FND_API.G_TRUE OR
9183: l_return_status = FND_API.G_FALSE )
9184: THEN
9185:
9186: x_return_status := FND_API.G_RET_STS_SUCCESS;
9187:
9188: ELSE
9189:
9190: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 9190: x_return_status := FND_API.G_RET_STS_ERROR ;

9186: x_return_status := FND_API.G_RET_STS_SUCCESS;
9187:
9188: ELSE
9189:
9190: x_return_status := FND_API.G_RET_STS_ERROR ;
9191:
9192: END IF ;
9193:
9194:

Line 9198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9194:
9195: EXCEPTION
9196: WHEN OTHERS THEN
9197:
9198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9199:
9200: IF FND_MSG_PUB.Check_Msg_Level
9201: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9202: THEN

Line 9231: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

9227: l_return_status VARCHAR2(1) ;
9228: l_line_item_key VARCHAR2(240) ;
9229: l_change_id NUMBER ;
9230:
9231: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
9232: l_output_dir VARCHAR2(240) := '' ;
9233: l_debug_filename VARCHAR2(200) := 'StartLineRoutes.log' ;
9234:
9235:

Line 9298: , p_init_msg_list => FND_API.G_FALSE

9294: -- Start Change Line Workflows
9295: -- FND_MSG_PUB.initialize ;
9296: Eng_Workflow_Util.StartWorkflow
9297: ( p_api_version => 1.0
9298: , p_init_msg_list => FND_API.G_FALSE
9299: , p_commit => FND_API.G_FALSE
9300: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9301: , x_return_status => l_return_status
9302: , x_msg_count => x_msg_count

Line 9299: , p_commit => FND_API.G_FALSE

9295: -- FND_MSG_PUB.initialize ;
9296: Eng_Workflow_Util.StartWorkflow
9297: ( p_api_version => 1.0
9298: , p_init_msg_list => FND_API.G_FALSE
9299: , p_commit => FND_API.G_FALSE
9300: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9301: , x_return_status => l_return_status
9302: , x_msg_count => x_msg_count
9303: , x_msg_data => x_msg_data

Line 9300: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

9296: Eng_Workflow_Util.StartWorkflow
9297: ( p_api_version => 1.0
9298: , p_init_msg_list => FND_API.G_FALSE
9299: , p_commit => FND_API.G_FALSE
9300: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9301: , x_return_status => l_return_status
9302: , x_msg_count => x_msg_count
9303: , x_msg_data => x_msg_data
9304: , p_item_type => line_rec.wf_item_type

Line 9317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

9313: , p_output_dir => l_output_dir
9314: , p_debug_filename => l_debug_filename || TO_CHAR(line_rec.change_line_id)
9315: ) ;
9316:
9317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
9318: THEN
9319:
9320: x_return_status := l_return_status ;
9321:

Line 9339: IF x_return_status = FND_API.G_RET_STS_SUCCESS

9335: END LOOP ;
9336:
9337:
9338:
9339: IF x_return_status = FND_API.G_RET_STS_SUCCESS
9340: OR x_return_status = Eng_Workflow_Util.G_RET_STS_NONE
9341: THEN
9342:
9343: COMMIT ;

Line 9348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9344:
9345: ELSE
9346:
9347: ROLLBACK ;
9348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9349:
9350: END IF ;
9351:
9352:

Line 9358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9354: WHEN OTHERS THEN
9355:
9356: ROLLBACK ;
9357:
9358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9359:
9360: IF FND_MSG_PUB.Check_Msg_Level
9361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9362: THEN

Line 9408: x_return_status := FND_API.G_RET_STS_SUCCESS;

9404:
9405: BEGIN
9406:
9407: -- Initialize API return status to success
9408: x_return_status := FND_API.G_RET_STS_SUCCESS;
9409:
9410: x_line_approval_status := Eng_Workflow_Util.G_APPROVED ;
9411:
9412: FOR l_approved_line_rec IN c_approved_line (p_change_id )

Line 9423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9419:
9420: EXCEPTION
9421: WHEN OTHERS THEN
9422:
9423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9424:
9425: IF FND_MSG_PUB.Check_Msg_Level
9426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9427: THEN

Line 9556: x_return_status := FND_API.G_RET_STS_SUCCESS;

9552:
9553: BEGIN
9554:
9555: -- Initialize API return status to success
9556: x_return_status := FND_API.G_RET_STS_SUCCESS;
9557:
9558:
9559: -- Get Step Activity Attributes
9560: GetStepActAttributes

Line 9591: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

9587: , p_end_date => NULL
9588: ) ;
9589:
9590:
9591: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
9592: THEN
9593:
9594: x_return_status := l_return_status ;
9595: x_msg_count := NVL(l_msg_count, 0) + NVL(l_msg_count,0) ;

Line 9608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9604:
9605: EXCEPTION
9606: WHEN OTHERS THEN
9607:
9608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9609:
9610: IF FND_MSG_PUB.Check_Msg_Level
9611: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9612: THEN

Line 10549: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

10545: AND ecr.route_id = eec.route_id
10546: AND eec.change_id = p_change_id ;
10547:
10548:
10549: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
10550: l_output_dir VARCHAR2(240) := NULL ;
10551: l_debug_filename VARCHAR2(200) := 'ContinueHeaderRoute.log' ;
10552:
10553:

Line 10571: x_return_status := FND_API.G_RET_STS_SUCCESS;

10567: Write_Debug('-----------------------------------------------------');
10568: END IF ;
10569:
10570: -- Initialize API return status to success
10571: x_return_status := FND_API.G_RET_STS_SUCCESS;
10572:
10573:
10574: if (p_waiting_flow_type = 'APPROVAL') then
10575:

Line 10704: x_return_status := FND_API.G_RET_STS_SUCCESS;

10700: BEGIN
10701:
10702:
10703: -- Initialize API return status to success
10704: x_return_status := FND_API.G_RET_STS_SUCCESS;
10705:
10706:
10707: if (p_continuation_flow_type = 'APPROVAL') then
10708:

Line 10819: , p_init_msg_list => FND_API.G_FALSE

10815:
10816: -- create and start Response FYI process to send Resp FYI ntf
10817: Eng_Workflow_Util.StartWorkflow
10818: ( p_api_version => 1.0
10819: , p_init_msg_list => FND_API.G_FALSE
10820: , p_commit => FND_API.G_FALSE
10821: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10822: , x_return_status => x_return_status
10823: , x_msg_count => x_msg_count

Line 10820: , p_commit => FND_API.G_FALSE

10816: -- create and start Response FYI process to send Resp FYI ntf
10817: Eng_Workflow_Util.StartWorkflow
10818: ( p_api_version => 1.0
10819: , p_init_msg_list => FND_API.G_FALSE
10820: , p_commit => FND_API.G_FALSE
10821: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10822: , x_return_status => x_return_status
10823: , x_msg_count => x_msg_count
10824: , x_msg_data => x_msg_data

Line 10821: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

10817: Eng_Workflow_Util.StartWorkflow
10818: ( p_api_version => 1.0
10819: , p_init_msg_list => FND_API.G_FALSE
10820: , p_commit => FND_API.G_FALSE
10821: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10822: , x_return_status => x_return_status
10823: , x_msg_count => x_msg_count
10824: , x_msg_data => x_msg_data
10825: , p_item_type => G_CHANGE_ACTION_ITEM_TYPE

Line 10838: , p_debug => FND_API.G_FALSE

10834: , p_route_id => 0
10835: , p_route_step_id => 0
10836: , p_parent_item_type => p_itemtype
10837: , p_parent_item_key => p_itemkey
10838: , p_debug => FND_API.G_FALSE
10839: , p_output_dir => NULL
10840: , p_debug_filename => 'Eng_ChangeWF_Start.log'
10841: ) ;
10842:

Line 10867: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

10863: PRAGMA AUTONOMOUS_TRANSACTION;
10864:
10865: l_api_name CONSTANT VARCHAR2(30) := 'StartValidateDefProcess';
10866:
10867: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
10868: l_output_dir VARCHAR2(240) := NULL ;
10869: l_debug_filename VARCHAR2(200) := 'StartValidateDefProcess.log' ;
10870:
10871: l_resp_user_id NUMBER ;

Line 10902: x_return_status := FND_API.G_RET_STS_SUCCESS ;

10898: WHERE UserV.user_id = p_user_id ;
10899:
10900: BEGIN
10901:
10902: x_return_status := FND_API.G_RET_STS_SUCCESS ;
10903:
10904:
10905: IF g_debug_flag THEN
10906: Write_Debug('Eng_Workflow_Util.StartValidateDefProcess Log');

Line 10922: l_return_status := FND_API.G_RET_STS_SUCCESS ;

10918: l_resp_user_id := ntf_info_rec.user_id ;
10919: END LOOP ;
10920:
10921: BEGIN
10922: l_return_status := FND_API.G_RET_STS_SUCCESS ;
10923:
10924: -- FND_MSG_PUB.initialize ;
10925: Eng_Workflow_Util.StartWorkflow
10926: ( p_api_version => 1.0

Line 10927: , p_init_msg_list => FND_API.G_FALSE

10923:
10924: -- FND_MSG_PUB.initialize ;
10925: Eng_Workflow_Util.StartWorkflow
10926: ( p_api_version => 1.0
10927: , p_init_msg_list => FND_API.G_FALSE
10928: , p_commit => FND_API.G_FALSE
10929: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10930: , x_return_status => l_return_status
10931: , x_msg_count => l_msg_count

Line 10928: , p_commit => FND_API.G_FALSE

10924: -- FND_MSG_PUB.initialize ;
10925: Eng_Workflow_Util.StartWorkflow
10926: ( p_api_version => 1.0
10927: , p_init_msg_list => FND_API.G_FALSE
10928: , p_commit => FND_API.G_FALSE
10929: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10930: , x_return_status => l_return_status
10931: , x_msg_count => l_msg_count
10932: , x_msg_data => l_msg_data

Line 10929: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

10925: Eng_Workflow_Util.StartWorkflow
10926: ( p_api_version => 1.0
10927: , p_init_msg_list => FND_API.G_FALSE
10928: , p_commit => FND_API.G_FALSE
10929: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10930: , x_return_status => l_return_status
10931: , x_msg_count => l_msg_count
10932: , x_msg_data => l_msg_data
10933: , p_item_type => p_val_def_item_type

Line 10959: IF l_return_status = FND_API.G_RET_STS_SUCCESS

10955: Write_Debug('Started Val Def WF Process Name: ' || p_val_def_process_name ) ;
10956: END IF ;
10957:
10958:
10959: IF l_return_status = FND_API.G_RET_STS_SUCCESS
10960: THEN
10961:
10962: COMMIT ;
10963:

Line 10983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

10979:
10980: EXCEPTION
10981: WHEN OTHERS THEN
10982:
10983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10984:
10985: IF FND_MSG_PUB.Check_Msg_Level
10986: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10987: THEN

Line 11230: x_return_status := FND_API.G_RET_STS_SUCCESS;

11226:
11227: BEGIN
11228:
11229: -- Initialize API return status to success
11230: x_return_status := FND_API.G_RET_STS_SUCCESS;
11231:
11232: IF g_debug_flag THEN
11233: Write_Debug('Eng_Workflow_Util.RespondToActReqCommentFromUI Log');
11234: Write_Debug('-----------------------------------------------------');

Line 11299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

11295:
11296: EXCEPTION
11297: WHEN OTHERS THEN
11298:
11299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11300:
11301: IF FND_MSG_PUB.Check_Msg_Level
11302: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11303: THEN

Line 11351: x_return_status := FND_API.G_RET_STS_SUCCESS;

11347: BEGIN
11348:
11349:
11350: -- Initialize API return status to success
11351: x_return_status := FND_API.G_RET_STS_SUCCESS;
11352:
11353: IF g_debug_flag THEN
11354: Write_Debug('Eng_Workflow_Util.SetChangeOrderMRPFlag Log');
11355: Write_Debug('-----------------------------------------------------');

Line 11409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

11405:
11406: EXCEPTION
11407: WHEN OTHERS THEN
11408:
11409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11410:
11411: IF FND_MSG_PUB.Check_Msg_Level
11412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11413: THEN

Line 11430: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

11426: * Purpose : Those APIs are public
11427: *********************************************************************/
11428: PROCEDURE GetWorkflowMonitorURL
11429: ( p_api_version IN NUMBER
11430: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11431: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11432: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11433: , x_return_status OUT NOCOPY VARCHAR2
11434: , x_msg_count OUT NOCOPY NUMBER

Line 11431: , p_commit IN VARCHAR2 := FND_API.G_FALSE

11427: *********************************************************************/
11428: PROCEDURE GetWorkflowMonitorURL
11429: ( p_api_version IN NUMBER
11430: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11431: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11432: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11433: , x_return_status OUT NOCOPY VARCHAR2
11434: , x_msg_count OUT NOCOPY NUMBER
11435: , x_msg_data OUT NOCOPY VARCHAR2

Line 11432: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

11428: PROCEDURE GetWorkflowMonitorURL
11429: ( p_api_version IN NUMBER
11430: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11431: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11432: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11433: , x_return_status OUT NOCOPY VARCHAR2
11434: , x_msg_count OUT NOCOPY NUMBER
11435: , x_msg_data OUT NOCOPY VARCHAR2
11436: , p_item_type IN VARCHAR2

Line 11439: , p_admin_mode IN VARCHAR2 := FND_API.G_FALSE

11435: , x_msg_data OUT NOCOPY VARCHAR2
11436: , p_item_type IN VARCHAR2
11437: , p_item_key IN VARCHAR2
11438: , p_url_type IN VARCHAR2 := Eng_Workflow_Util.G_MONITOR_DIAGRAM
11439: , p_admin_mode IN VARCHAR2 := FND_API.G_FALSE
11440: , p_option IN VARCHAR2 := NULL
11441: , x_url OUT NOCOPY VARCHAR2
11442: )
11443: IS

Line 11459: IF NOT FND_API.Compatible_API_Call( l_api_version

11455: -- No Need to set SAVEPOINT for this API
11456: -- SAVEPOINT GetWorkflowMonitorURL_Util ;
11457:
11458: -- Standard call to check for call compatibility.
11459: IF NOT FND_API.Compatible_API_Call( l_api_version
11460: , p_api_version
11461: , l_api_name
11462: , G_PKG_NAME )
11463: THEN

Line 11464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11460: , p_api_version
11461: , l_api_name
11462: , G_PKG_NAME )
11463: THEN
11464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11465: END IF;
11466:
11467:
11468: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 11469: IF FND_API.to_Boolean( p_init_msg_list ) THEN

11465: END IF;
11466:
11467:
11468: -- Initialize message list if p_init_msg_list is set to TRUE.
11469: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11470: FND_MSG_PUB.initialize;
11471: END IF ;
11472:
11473: -- Initialize API return status to success

Line 11474: x_return_status := FND_API.G_RET_STS_SUCCESS;

11470: FND_MSG_PUB.initialize;
11471: END IF ;
11472:
11473: -- Initialize API return status to success
11474: x_return_status := FND_API.G_RET_STS_SUCCESS;
11475:
11476:
11477: -- API body
11478:

Line 11480: IF FND_API.to_Boolean( p_admin_mode ) THEN

11476:
11477: -- API body
11478:
11479: -- Get Admin Mode.
11480: IF FND_API.to_Boolean( p_admin_mode ) THEN
11481: l_admin_mode := l_YES ;
11482: ELSE
11483: l_admin_mode := l_NO ;
11484: END IF ;

Line 11534: -- IF FND_API.To_Boolean( p_commit ) THEN

11530: END IF ;
11531:
11532:
11533: -- Standard check of p_commit.
11534: -- IF FND_API.To_Boolean( p_commit ) THEN
11535: -- COMMIT WORK;
11536: -- END IF;
11537:
11538: -- Standard call to get message count and if count is 1, get message info.

Line 11545: WHEN FND_API.G_EXC_ERROR THEN

11541: , p_data => x_msg_data
11542: );
11543:
11544: EXCEPTION
11545: WHEN FND_API.G_EXC_ERROR THEN
11546: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11547: x_return_status := FND_API.G_RET_STS_ERROR ;
11548:
11549: FND_MSG_PUB.Count_And_Get

Line 11547: x_return_status := FND_API.G_RET_STS_ERROR ;

11543:
11544: EXCEPTION
11545: WHEN FND_API.G_EXC_ERROR THEN
11546: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11547: x_return_status := FND_API.G_RET_STS_ERROR ;
11548:
11549: FND_MSG_PUB.Count_And_Get
11550: ( p_count => x_msg_count
11551: , p_data => x_msg_data

Line 11554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11550: ( p_count => x_msg_count
11551: , p_data => x_msg_data
11552: );
11553:
11554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11555: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11557:
11558: FND_MSG_PUB.Count_And_Get

Line 11556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

11552: );
11553:
11554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11555: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11557:
11558: FND_MSG_PUB.Count_And_Get
11559: ( p_count => x_msg_count
11560: , p_data => x_msg_data

Line 11565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

11561: );
11562:
11563: WHEN OTHERS THEN
11564: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11566:
11567: FND_MSG_PUB.Count_And_Get
11568: ( p_count => x_msg_count
11569: , p_data => x_msg_data

Line 11592: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

11588:
11589:
11590: PROCEDURE StartWorkflow
11591: ( p_api_version IN NUMBER
11592: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11593: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11594: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11595: , x_return_status OUT NOCOPY VARCHAR2
11596: , x_msg_count OUT NOCOPY NUMBER

Line 11593: , p_commit IN VARCHAR2 := FND_API.G_FALSE

11589:
11590: PROCEDURE StartWorkflow
11591: ( p_api_version IN NUMBER
11592: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11593: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11594: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11595: , x_return_status OUT NOCOPY VARCHAR2
11596: , x_msg_count OUT NOCOPY NUMBER
11597: , x_msg_data OUT NOCOPY VARCHAR2

Line 11594: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

11590: PROCEDURE StartWorkflow
11591: ( p_api_version IN NUMBER
11592: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11593: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11594: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11595: , x_return_status OUT NOCOPY VARCHAR2
11596: , x_msg_count OUT NOCOPY NUMBER
11597: , x_msg_data OUT NOCOPY VARCHAR2
11598: , p_item_type IN VARCHAR2

Line 11611: , p_debug IN VARCHAR2 := FND_API.G_FALSE

11607: , p_route_id IN NUMBER := NULL
11608: , p_route_step_id IN NUMBER := NULL
11609: , p_parent_item_type IN VARCHAR2 := NULL
11610: , p_parent_item_key IN VARCHAR2 := NULL
11611: , p_debug IN VARCHAR2 := FND_API.G_FALSE
11612: , p_output_dir IN VARCHAR2 := NULL
11613: , p_debug_filename IN VARCHAR2 := 'Eng_ChangeWF_Start.log'
11614: )
11615: IS

Line 11686: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

11682:
11683:
11684: PROCEDURE StartWorkflow
11685: ( p_api_version IN NUMBER
11686: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11687: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11688: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11689: , x_return_status OUT NOCOPY VARCHAR2
11690: , x_msg_count OUT NOCOPY NUMBER

Line 11687: , p_commit IN VARCHAR2 := FND_API.G_FALSE

11683:
11684: PROCEDURE StartWorkflow
11685: ( p_api_version IN NUMBER
11686: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11687: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11688: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11689: , x_return_status OUT NOCOPY VARCHAR2
11690: , x_msg_count OUT NOCOPY NUMBER
11691: , x_msg_data OUT NOCOPY VARCHAR2

Line 11688: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

11684: PROCEDURE StartWorkflow
11685: ( p_api_version IN NUMBER
11686: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11687: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11688: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11689: , x_return_status OUT NOCOPY VARCHAR2
11690: , x_msg_count OUT NOCOPY NUMBER
11691: , x_msg_data OUT NOCOPY VARCHAR2
11692: , p_item_type IN VARCHAR2

Line 11711: , p_debug IN VARCHAR2 := FND_API.G_FALSE

11707: , p_route_id IN NUMBER := NULL
11708: , p_route_step_id IN NUMBER := NULL
11709: , p_parent_item_type IN VARCHAR2 := NULL
11710: , p_parent_item_key IN VARCHAR2 := NULL
11711: , p_debug IN VARCHAR2 := FND_API.G_FALSE
11712: , p_output_dir IN VARCHAR2 := NULL
11713: , p_debug_filename IN VARCHAR2 := 'Eng_ChangeWF_Start.log'
11714: )
11715: IS

Line 11746: IF NOT FND_API.Compatible_API_Call( l_api_version

11742: -- Standard Start of API savepoint
11743: SAVEPOINT StartWorkflow_Util;
11744:
11745: -- Standard call to check for call compatibility.
11746: IF NOT FND_API.Compatible_API_Call( l_api_version
11747: , p_api_version
11748: , l_api_name
11749: , G_PKG_NAME )
11750: THEN

Line 11751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11747: , p_api_version
11748: , l_api_name
11749: , G_PKG_NAME )
11750: THEN
11751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11752: END IF;
11753:
11754: -- Initialize message list if p_init_msg_list is set to TRUE.
11755: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 11755: IF FND_API.to_Boolean( p_init_msg_list ) THEN

11751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11752: END IF;
11753:
11754: -- Initialize message list if p_init_msg_list is set to TRUE.
11755: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11756: FND_MSG_PUB.initialize;
11757: END IF ;
11758:
11759:

Line 11764: -- IF FND_API.to_Boolean( p_debug ) THEN

11760:
11761: -- For Test/Debug
11762: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
11763: -- R12 Comment out
11764: -- IF FND_API.to_Boolean( p_debug ) THEN
11765: -- Open_Debug_Session(p_output_dir, p_debug_filename ) ;
11766: -- END IF;
11767:
11768: -- Initialize Other Variables

Line 11809: x_return_status := FND_API.G_RET_STS_SUCCESS;

11805: Write_Debug('Initialize return status ' );
11806: END IF ;
11807:
11808: -- Initialize API return status to success
11809: x_return_status := FND_API.G_RET_STS_SUCCESS;
11810:
11811: -----------------------------------------------------------------
11812: -- API body
11813: -----------------------------------------------------------------

Line 11858: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

11854: , p_parent_object_id1 => p_parent_object_id1
11855: ) ;
11856:
11857:
11858: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
11859: THEN
11860: RAISE FND_API.G_EXC_ERROR ;
11861: END IF ;
11862:

Line 11860: RAISE FND_API.G_EXC_ERROR ;

11856:
11857:
11858: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
11859: THEN
11860: RAISE FND_API.G_EXC_ERROR ;
11861: END IF ;
11862:
11863:
11864: --

Line 11899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

11895: Write_Debug('CM Workflows except Doc Phse WF Routing are not supported in Document LC ChangeObject. Raise Error. .. ');
11896: END IF ;
11897: -- At this time, not raising any error
11898:
11899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
11900: END IF ;
11901:
11902:
11903: END IF ;

Line 12028: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12024: Write_Debug('Change Id : ' || to_char(l_change_id));
12025: END IF ;
12026:
12027:
12028: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12029: THEN
12030: RAISE FND_API.G_EXC_ERROR ;
12031: END IF ;
12032:

Line 12030: RAISE FND_API.G_EXC_ERROR ;

12026:
12027:
12028: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12029: THEN
12030: RAISE FND_API.G_EXC_ERROR ;
12031: END IF ;
12032:
12033: IF g_debug_flag THEN
12034: Write_Debug('4. SetItemParent. . .');

Line 12072: , p_init_route => FND_API.G_TRUE

12068: , p_item_key => x_item_key
12069: , p_wf_user_id => p_wf_user_id
12070: , p_route_id => p_route_id
12071: , p_new_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12072: , p_init_route => FND_API.G_TRUE
12073: , p_change_id => l_change_id
12074: , p_change_line_id => l_change_line_id -- Added in R12B
12075: ) ;
12076:

Line 12108: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12104: -- IF g_debug_flag THEN
12105: -- Write_Debug('After Set Approval Status .' || x_return_status );
12106: -- END IF ;
12107:
12108: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12109: -- THEN
12110: -- RAISE FND_API.G_EXC_ERROR ;
12111: -- END IF ;
12112: --

Line 12110: -- RAISE FND_API.G_EXC_ERROR ;

12106: -- END IF ;
12107:
12108: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12109: -- THEN
12110: -- RAISE FND_API.G_EXC_ERROR ;
12111: -- END IF ;
12112: --
12113: ****************************************************/
12114:

Line 12141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12137: IF g_debug_flag THEN
12138: Write_Debug('After Set Workflow Routing Action Log .' || x_return_status );
12139: END IF ;
12140:
12141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12142: THEN
12143: RAISE FND_API.G_EXC_ERROR ;
12144: END IF ;
12145:

Line 12143: RAISE FND_API.G_EXC_ERROR ;

12139: END IF ;
12140:
12141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12142: THEN
12143: RAISE FND_API.G_EXC_ERROR ;
12144: END IF ;
12145:
12146: -- Set Action Id
12147: SetActionId

Line 12178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12174: Write_Debug('After Sync Workflow Routing Status and LC Phase WF Status.' || x_return_status );
12175: END IF ;
12176:
12177:
12178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12179: THEN
12180: RAISE FND_API.G_EXC_ERROR ;
12181: END IF ;
12182:

Line 12180: RAISE FND_API.G_EXC_ERROR ;

12176:
12177:
12178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12179: THEN
12180: RAISE FND_API.G_EXC_ERROR ;
12181: END IF ;
12182:
12183: END IF ;
12184:

Line 12217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12213: IF g_debug_flag THEN
12214: Write_Debug('After Set Line Workflow Routing Action Log .' || x_return_status );
12215: END IF ;
12216:
12217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12218: THEN
12219: RAISE FND_API.G_EXC_ERROR ;
12220: END IF ;
12221:

Line 12219: RAISE FND_API.G_EXC_ERROR ;

12215: END IF ;
12216:
12217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12218: THEN
12219: RAISE FND_API.G_EXC_ERROR ;
12220: END IF ;
12221:
12222: -- Set Action Id
12223: SetActionId

Line 12256: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12252: --IF g_debug_flag THEN
12253: -- Write_Debug('After Set Parenet Child for Route Worklfow.' || x_return_status );
12254: --END IF ;
12255:
12256: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12257: -- THEN
12258: -- RAISE FND_API.G_EXC_ERROR ;
12259: -- END IF ;
12260: --

Line 12258: -- RAISE FND_API.G_EXC_ERROR ;

12254: --END IF ;
12255:
12256: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12257: -- THEN
12258: -- RAISE FND_API.G_EXC_ERROR ;
12259: -- END IF ;
12260: --
12261: ***********************************************/
12262:

Line 12327: , p_init_msg_list => FND_API.G_FALSE --

12323:
12324:
12325: Eng_Workflow_Util.GrantObjectRoles
12326: ( p_api_version => 1.0
12327: , p_init_msg_list => FND_API.G_FALSE --
12328: , p_commit => FND_API.G_FALSE --
12329: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12330: , p_debug => p_debug
12331: , p_output_dir => p_output_dir

Line 12328: , p_commit => FND_API.G_FALSE --

12324:
12325: Eng_Workflow_Util.GrantObjectRoles
12326: ( p_api_version => 1.0
12327: , p_init_msg_list => FND_API.G_FALSE --
12328: , p_commit => FND_API.G_FALSE --
12329: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12330: , p_debug => p_debug
12331: , p_output_dir => p_output_dir
12332: , p_debug_filename => p_debug_filename

Line 12329: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

12325: Eng_Workflow_Util.GrantObjectRoles
12326: ( p_api_version => 1.0
12327: , p_init_msg_list => FND_API.G_FALSE --
12328: , p_commit => FND_API.G_FALSE --
12329: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12330: , p_debug => p_debug
12331: , p_output_dir => p_output_dir
12332: , p_debug_filename => p_debug_filename
12333: , x_return_status => l_return_status

Line 12352: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

12348: Write_Debug('After Eng_Workflow_Util.GrantObjectRoles: ' || l_return_status );
12349: END IF ;
12350:
12351: --
12352: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12353: -- THEN
12354: -- RAISE FND_API.G_EXC_ERROR ;
12355: -- END IF ;
12356: --

Line 12354: -- RAISE FND_API.G_EXC_ERROR ;

12350:
12351: --
12352: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12353: -- THEN
12354: -- RAISE FND_API.G_EXC_ERROR ;
12355: -- END IF ;
12356: --
12357:
12358: END IF ;

Line 12402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12398: Write_Debug('Return Status: ' || x_return_status );
12399: END IF ;
12400:
12401:
12402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12403: THEN
12404: RAISE FND_API.G_EXC_ERROR ;
12405: END IF ;
12406:

Line 12404: RAISE FND_API.G_EXC_ERROR ;

12400:
12401:
12402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12403: THEN
12404: RAISE FND_API.G_EXC_ERROR ;
12405: END IF ;
12406:
12407: IF g_debug_flag THEN
12408: Write_Debug('6. StartProcess. . .');

Line 12436: IF FND_API.To_Boolean( p_commit ) THEN

12432: END IF ;
12433:
12434:
12435: -- Standard check of p_commit.
12436: IF FND_API.To_Boolean( p_commit ) THEN
12437:
12438: IF g_debug_flag THEN
12439: Write_Debug('Do Commit.') ;
12440: END IF ;

Line 12458: WHEN FND_API.G_EXC_ERROR THEN

12454: END IF ;
12455:
12456:
12457: EXCEPTION
12458: WHEN FND_API.G_EXC_ERROR THEN
12459: -- Standard check of p_commit.
12460: IF FND_API.To_Boolean( p_commit ) THEN
12461: IF g_debug_flag THEN
12462: Write_Debug('Rollback . . .') ;

Line 12460: IF FND_API.To_Boolean( p_commit ) THEN

12456:
12457: EXCEPTION
12458: WHEN FND_API.G_EXC_ERROR THEN
12459: -- Standard check of p_commit.
12460: IF FND_API.To_Boolean( p_commit ) THEN
12461: IF g_debug_flag THEN
12462: Write_Debug('Rollback . . .') ;
12463: END IF ;
12464: ROLLBACK TO StartWorkflow_Util ;

Line 12467: x_return_status := FND_API.G_RET_STS_ERROR ;

12463: END IF ;
12464: ROLLBACK TO StartWorkflow_Util ;
12465: END IF;
12466:
12467: x_return_status := FND_API.G_RET_STS_ERROR ;
12468:
12469: FND_MSG_PUB.Count_And_Get
12470: ( p_count => x_msg_count
12471: , p_data => x_msg_data

Line 12479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12475: Write_Debug('RollBack and Finish with Error.') ;
12476: Close_Debug_Session ;
12477: END IF ;
12478:
12479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12480: IF FND_API.To_Boolean( p_commit ) THEN
12481: IF g_debug_flag THEN
12482: Write_Debug('Rollback . . .') ;
12483: END IF ;

Line 12480: IF FND_API.To_Boolean( p_commit ) THEN

12476: Close_Debug_Session ;
12477: END IF ;
12478:
12479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12480: IF FND_API.To_Boolean( p_commit ) THEN
12481: IF g_debug_flag THEN
12482: Write_Debug('Rollback . . .') ;
12483: END IF ;
12484: ROLLBACK TO StartWorkflow_Util ;

Line 12487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

12483: END IF ;
12484: ROLLBACK TO StartWorkflow_Util ;
12485: END IF;
12486:
12487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12488:
12489: FND_MSG_PUB.Count_And_Get
12490: ( p_count => x_msg_count
12491: , p_data => x_msg_data

Line 12500: IF FND_API.To_Boolean( p_commit ) THEN

12496: Close_Debug_Session ;
12497: END IF ;
12498:
12499: WHEN OTHERS THEN
12500: IF FND_API.To_Boolean( p_commit ) THEN
12501: IF g_debug_flag THEN
12502: Write_Debug('Rollback . . .') ;
12503: END IF ;
12504: ROLLBACK TO StartWorkflow_Util ;

Line 12507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

12503: END IF ;
12504: ROLLBACK TO StartWorkflow_Util ;
12505: END IF;
12506:
12507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12508:
12509: FND_MSG_PUB.Count_And_Get
12510: ( p_count => x_msg_count
12511: , p_data => x_msg_data

Line 12541: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

12537:
12538:
12539: PROCEDURE AbortWorkflow
12540: ( p_api_version IN NUMBER
12541: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
12542: , p_commit IN VARCHAR2 := FND_API.G_FALSE
12543: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12544: , x_return_status OUT NOCOPY VARCHAR2
12545: , x_msg_count OUT NOCOPY NUMBER

Line 12542: , p_commit IN VARCHAR2 := FND_API.G_FALSE

12538:
12539: PROCEDURE AbortWorkflow
12540: ( p_api_version IN NUMBER
12541: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
12542: , p_commit IN VARCHAR2 := FND_API.G_FALSE
12543: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12544: , x_return_status OUT NOCOPY VARCHAR2
12545: , x_msg_count OUT NOCOPY NUMBER
12546: , x_msg_data OUT NOCOPY VARCHAR2

Line 12543: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

12539: PROCEDURE AbortWorkflow
12540: ( p_api_version IN NUMBER
12541: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
12542: , p_commit IN VARCHAR2 := FND_API.G_FALSE
12543: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12544: , x_return_status OUT NOCOPY VARCHAR2
12545: , x_msg_count OUT NOCOPY NUMBER
12546: , x_msg_data OUT NOCOPY VARCHAR2
12547: , p_item_type IN VARCHAR2

Line 12551: , p_debug IN VARCHAR2 := FND_API.G_FALSE

12547: , p_item_type IN VARCHAR2
12548: , p_item_key IN VARCHAR2
12549: , p_process_name IN VARCHAR2 := NULL
12550: , p_wf_user_id IN NUMBER
12551: , p_debug IN VARCHAR2 := FND_API.G_FALSE
12552: , p_output_dir IN VARCHAR2 := NULL
12553: , p_debug_filename IN VARCHAR2 := 'Eng_ChangeWF_Abort.log'
12554: )
12555: IS

Line 12592: IF NOT FND_API.Compatible_API_Call( l_api_version

12588: -- Standard Start of API savepoint
12589: SAVEPOINT AbortWorkflow_Util;
12590:
12591: -- Standard call to check for call compatibility.
12592: IF NOT FND_API.Compatible_API_Call( l_api_version
12593: , p_api_version
12594: , l_api_name
12595: , G_PKG_NAME )
12596: THEN

Line 12597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12593: , p_api_version
12594: , l_api_name
12595: , G_PKG_NAME )
12596: THEN
12597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12598: END IF;
12599:
12600: -- Initialize message list if p_init_msg_list is set to TRUE.
12601: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 12601: IF FND_API.to_Boolean( p_init_msg_list ) THEN

12597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12598: END IF;
12599:
12600: -- Initialize message list if p_init_msg_list is set to TRUE.
12601: IF FND_API.to_Boolean( p_init_msg_list ) THEN
12602: FND_MSG_PUB.initialize;
12603: END IF ;
12604:
12605:

Line 12609: -- IF FND_API.to_Boolean( p_debug ) THEN

12605:
12606: -- For Test/Debug
12607: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
12608: -- R12 Comment out
12609: -- IF FND_API.to_Boolean( p_debug ) THEN
12610: -- Open_Debug_Session(p_output_dir, p_debug_filename ) ;
12611: -- END IF;
12612:
12613:

Line 12625: x_return_status := FND_API.G_RET_STS_SUCCESS;

12621: Write_Debug('Initialize return status ' );
12622: END IF ;
12623:
12624: -- Initialize API return status to success
12625: x_return_status := FND_API.G_RET_STS_SUCCESS;
12626:
12627: -----------------------------------------------------------------
12628: -- API body
12629: -----------------------------------------------------------------

Line 12655: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12651: , p_wf_user_id => p_wf_user_id
12652: ) ;
12653:
12654:
12655: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12656: THEN
12657: RAISE FND_API.G_EXC_ERROR ;
12658: END IF ;
12659:

Line 12657: RAISE FND_API.G_EXC_ERROR ;

12653:
12654:
12655: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12656: THEN
12657: RAISE FND_API.G_EXC_ERROR ;
12658: END IF ;
12659:
12660: IF g_debug_flag THEN
12661: Write_Debug('2. Set User Id who is aborting the process. . .');

Line 12776: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12772: IF g_debug_flag THEN
12773: Write_Debug('After Set Approval Status .' || x_return_status );
12774: END IF ;
12775:
12776: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12777: -- THEN
12778: -- RAISE FND_API.G_EXC_ERROR ;
12779: -- END IF ;
12780:

Line 12778: -- RAISE FND_API.G_EXC_ERROR ;

12774: END IF ;
12775:
12776: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12777: -- THEN
12778: -- RAISE FND_API.G_EXC_ERROR ;
12779: -- END IF ;
12780:
12781: */
12782:

Line 12800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12796: IF g_debug_flag THEN
12797: Write_Debug('After Route Step Workflow ' || x_return_status );
12798: END IF ;
12799:
12800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12801: THEN
12802: RAISE FND_API.G_EXC_ERROR ;
12803: END IF ;
12804:

Line 12802: RAISE FND_API.G_EXC_ERROR ;

12798: END IF ;
12799:
12800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12801: THEN
12802: RAISE FND_API.G_EXC_ERROR ;
12803: END IF ;
12804:
12805:
12806: -- In case that Route Object is Change Object

Line 12823: , p_init_msg_list => FND_API.G_FALSE --

12819: END IF ;
12820:
12821: ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF
12822: ( p_api_version => 1.0
12823: , p_init_msg_list => FND_API.G_FALSE --
12824: , p_commit => FND_API.G_FALSE --
12825: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12826: , x_return_status => l_return_status
12827: , x_msg_count => l_msg_count

Line 12824: , p_commit => FND_API.G_FALSE --

12820:
12821: ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF
12822: ( p_api_version => 1.0
12823: , p_init_msg_list => FND_API.G_FALSE --
12824: , p_commit => FND_API.G_FALSE --
12825: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12826: , x_return_status => l_return_status
12827: , x_msg_count => l_msg_count
12828: , x_msg_data => l_msg_data

Line 12825: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

12821: ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF
12822: ( p_api_version => 1.0
12823: , p_init_msg_list => FND_API.G_FALSE --
12824: , p_commit => FND_API.G_FALSE --
12825: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12826: , x_return_status => l_return_status
12827: , x_msg_count => l_msg_count
12828: , x_msg_data => l_msg_data
12829: , p_change_id => l_change_id -- Change Id

Line 12837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

12833:
12834: IF g_debug_flag THEN
12835: Write_Debug('After calling ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF: ' || l_return_status );
12836: END IF ;
12837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12838: THEN
12839: RAISE FND_API.G_EXC_ERROR ;
12840: END IF ;
12841:

Line 12839: RAISE FND_API.G_EXC_ERROR ;

12835: Write_Debug('After calling ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF: ' || l_return_status );
12836: END IF ;
12837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12838: THEN
12839: RAISE FND_API.G_EXC_ERROR ;
12840: END IF ;
12841:
12842: END IF ;
12843:

Line 12879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12875: IF g_debug_flag THEN
12876: Write_Debug('After Set Workflow Routing Action Log: ' || x_return_status );
12877: END IF ;
12878:
12879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12880: THEN
12881: RAISE FND_API.G_EXC_ERROR ;
12882: END IF ;
12883:

Line 12881: RAISE FND_API.G_EXC_ERROR ;

12877: END IF ;
12878:
12879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12880: THEN
12881: RAISE FND_API.G_EXC_ERROR ;
12882: END IF ;
12883:
12884:
12885: -- R12B

Line 12905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12901: IF g_debug_flag THEN
12902: Write_Debug('After call SyncChangeLCPhase: ' || x_return_status );
12903: END IF ;
12904:
12905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12906: THEN
12907: RAISE FND_API.G_EXC_ERROR ;
12908: END IF ;
12909: END IF ;

Line 12907: RAISE FND_API.G_EXC_ERROR ;

12903: END IF ;
12904:
12905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12906: THEN
12907: RAISE FND_API.G_EXC_ERROR ;
12908: END IF ;
12909: END IF ;
12910:
12911:

Line 12953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12949: IF g_debug_flag THEN
12950: Write_Debug('After Set Line Workflow Routing Abort Action Log .' || x_return_status );
12951: END IF ;
12952:
12953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12954: THEN
12955: RAISE FND_API.G_EXC_ERROR ;
12956: END IF ;
12957:

Line 12955: RAISE FND_API.G_EXC_ERROR ;

12951: END IF ;
12952:
12953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12954: THEN
12955: RAISE FND_API.G_EXC_ERROR ;
12956: END IF ;
12957:
12958:
12959: END IF ; -- End if p_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE

Line 12988: , p_init_msg_list => FND_API.G_FALSE --

12984:
12985:
12986: Eng_Workflow_Util.RevokeObjectRoles
12987: ( p_api_version => 1.0
12988: , p_init_msg_list => FND_API.G_FALSE --
12989: , p_commit => FND_API.G_FALSE --
12990: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12991: , p_debug => p_debug
12992: , p_output_dir => p_output_dir

Line 12989: , p_commit => FND_API.G_FALSE --

12985:
12986: Eng_Workflow_Util.RevokeObjectRoles
12987: ( p_api_version => 1.0
12988: , p_init_msg_list => FND_API.G_FALSE --
12989: , p_commit => FND_API.G_FALSE --
12990: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12991: , p_debug => p_debug
12992: , p_output_dir => p_output_dir
12993: , p_debug_filename => p_debug_filename

Line 12990: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

12986: Eng_Workflow_Util.RevokeObjectRoles
12987: ( p_api_version => 1.0
12988: , p_init_msg_list => FND_API.G_FALSE --
12989: , p_commit => FND_API.G_FALSE --
12990: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12991: , p_debug => p_debug
12992: , p_output_dir => p_output_dir
12993: , p_debug_filename => p_debug_filename
12994: , x_return_status => l_return_status

Line 13012: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

13008: Write_Debug('After Eng_Workflow_Util.RevokeObjectRoles.' || l_return_status );
13009: END IF ;
13010:
13011: --
13012: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
13013: -- THEN
13014: -- RAISE FND_API.G_EXC_ERROR ;
13015: -- END IF ;
13016: --

Line 13014: -- RAISE FND_API.G_EXC_ERROR ;

13010:
13011: --
13012: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
13013: -- THEN
13014: -- RAISE FND_API.G_EXC_ERROR ;
13015: -- END IF ;
13016: --
13017:
13018: -- R12B

Line 13074: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

13070: Write_Debug('Return Status: ' || x_return_status );
13071: END IF ;
13072:
13073:
13074: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
13075: THEN
13076: RAISE FND_API.G_EXC_ERROR ;
13077: END IF ;
13078:

Line 13076: RAISE FND_API.G_EXC_ERROR ;

13072:
13073:
13074: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
13075: THEN
13076: RAISE FND_API.G_EXC_ERROR ;
13077: END IF ;
13078:
13079:
13080:

Line 13140: IF FND_API.To_Boolean( p_commit ) THEN

13136: END IF ;
13137:
13138:
13139: -- Standard check of p_commit.
13140: IF FND_API.To_Boolean( p_commit ) THEN
13141:
13142: IF g_debug_flag THEN
13143: Write_Debug('Do Commit.') ;
13144: END IF ;

Line 13164: WHEN FND_API.G_EXC_ERROR THEN

13160:
13161: -- To remove the step assignee created by the Reassignment.
13162:
13163: EXCEPTION
13164: WHEN FND_API.G_EXC_ERROR THEN
13165: IF FND_API.To_Boolean( p_commit ) THEN
13166: IF g_debug_flag THEN
13167: Write_Debug('Rollback . . .') ;
13168: END IF ;

Line 13165: IF FND_API.To_Boolean( p_commit ) THEN

13161: -- To remove the step assignee created by the Reassignment.
13162:
13163: EXCEPTION
13164: WHEN FND_API.G_EXC_ERROR THEN
13165: IF FND_API.To_Boolean( p_commit ) THEN
13166: IF g_debug_flag THEN
13167: Write_Debug('Rollback . . .') ;
13168: END IF ;
13169: ROLLBACK TO AbortWorkflow_Util ;

Line 13172: x_return_status := FND_API.G_RET_STS_ERROR ;

13168: END IF ;
13169: ROLLBACK TO AbortWorkflow_Util ;
13170: END IF;
13171:
13172: x_return_status := FND_API.G_RET_STS_ERROR ;
13173:
13174: FND_MSG_PUB.Count_And_Get
13175: ( p_count => x_msg_count
13176: , p_data => x_msg_data

Line 13184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

13180: Write_Debug('Finish with Error.') ;
13181: Close_Debug_Session ;
13182: END IF ;
13183:
13184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13185: IF FND_API.To_Boolean( p_commit ) THEN
13186: IF g_debug_flag THEN
13187: Write_Debug('Rollback . . .') ;
13188: END IF ;

Line 13185: IF FND_API.To_Boolean( p_commit ) THEN

13181: Close_Debug_Session ;
13182: END IF ;
13183:
13184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13185: IF FND_API.To_Boolean( p_commit ) THEN
13186: IF g_debug_flag THEN
13187: Write_Debug('Rollback . . .') ;
13188: END IF ;
13189: ROLLBACK TO AbortWorkflow_Util ;

Line 13192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

13188: END IF ;
13189: ROLLBACK TO AbortWorkflow_Util ;
13190: END IF;
13191:
13192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13193:
13194: FND_MSG_PUB.Count_And_Get
13195: ( p_count => x_msg_count
13196: , p_data => x_msg_data

Line 13205: IF FND_API.To_Boolean( p_commit ) THEN

13201: Close_Debug_Session ;
13202: END IF ;
13203:
13204: WHEN OTHERS THEN
13205: IF FND_API.To_Boolean( p_commit ) THEN
13206: IF g_debug_flag THEN
13207: Write_Debug('Rollback . . .') ;
13208: END IF ;
13209: ROLLBACK TO AbortWorkflow_Util ;

Line 13212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

13208: END IF ;
13209: ROLLBACK TO AbortWorkflow_Util ;
13210: END IF;
13211:
13212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13213:
13214: FND_MSG_PUB.Count_And_Get
13215: ( p_count => x_msg_count
13216: , p_data => x_msg_data

Line 13361: x_return_status := FND_API.G_RET_STS_SUCCESS;

13357: where ROUTE_PEOPLE_ID=p_route_people_id;
13358:
13359: BEGIN
13360: -- Initialize API return status to success
13361: x_return_status := FND_API.G_RET_STS_SUCCESS;
13362:
13363: IF g_debug_flag THEN
13364: Write_Debug('Route p_notification_id ' || to_char(p_notification_id));
13365: END IF ;

Line 13428: x_return_status := FND_API.G_RET_STS_ERROR ;

13424: IF g_debug_flag THEN
13425: Write_Debug('Transfer only supports users, new rols is invalid ');
13426: END IF ;
13427:
13428: x_return_status := FND_API.G_RET_STS_ERROR ;
13429: Wf_Core.context('Eng_Workflow_Util', 'reassignRoutePeople',
13430: p_item_type, p_item_key, p_notification_id, p_reassign_mode);
13431: Wf_Core.Token('ROLE', WF_ENGINE.context_new_role);
13432: Wf_Core.Raise('WFNTF_TRANSFER_FAIL');

Line 13620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

13616: , p_assignee_id => l_new_party_id
13617: ) ;
13618:
13619:
13620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13621:
13622: x_return_status := l_return_status ;
13623: x_msg_count := l_msg_count ;
13624: x_msg_data := l_msg_data ;

Line 13664: , p_init_msg_list => FND_API.G_FALSE --

13660: END IF ;
13661:
13662: Eng_Workflow_Util.GrantObjectRoles
13663: ( p_api_version => 1.0
13664: , p_init_msg_list => FND_API.G_FALSE --
13665: , p_commit => FND_API.G_FALSE --
13666: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13667: , p_debug => FND_API.G_FALSE
13668: , p_output_dir => NULL

Line 13665: , p_commit => FND_API.G_FALSE --

13661:
13662: Eng_Workflow_Util.GrantObjectRoles
13663: ( p_api_version => 1.0
13664: , p_init_msg_list => FND_API.G_FALSE --
13665: , p_commit => FND_API.G_FALSE --
13666: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13667: , p_debug => FND_API.G_FALSE
13668: , p_output_dir => NULL
13669: , p_debug_filename => NULL

Line 13666: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

13662: Eng_Workflow_Util.GrantObjectRoles
13663: ( p_api_version => 1.0
13664: , p_init_msg_list => FND_API.G_FALSE --
13665: , p_commit => FND_API.G_FALSE --
13666: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13667: , p_debug => FND_API.G_FALSE
13668: , p_output_dir => NULL
13669: , p_debug_filename => NULL
13670: , x_return_status => l_return_status

Line 13667: , p_debug => FND_API.G_FALSE

13663: ( p_api_version => 1.0
13664: , p_init_msg_list => FND_API.G_FALSE --
13665: , p_commit => FND_API.G_FALSE --
13666: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13667: , p_debug => FND_API.G_FALSE
13668: , p_output_dir => NULL
13669: , p_debug_filename => NULL
13670: , x_return_status => l_return_status
13671: , x_msg_count => l_msg_count

Line 13688: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

13684: Write_Debug('After Eng_Workflow_Util.GrantObjectRoles: ' || l_return_status );
13685: END IF ;
13686:
13687: --
13688: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
13689: -- THEN
13690: -- RAISE FND_API.G_EXC_ERROR ;
13691: -- END IF ;
13692: END IF ;

Line 13690: -- RAISE FND_API.G_EXC_ERROR ;

13686:
13687: --
13688: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
13689: -- THEN
13690: -- RAISE FND_API.G_EXC_ERROR ;
13691: -- END IF ;
13692: END IF ;
13693:
13694: EXCEPTION

Line 13695: WHEN FND_API.G_EXC_ERROR THEN

13691: -- END IF ;
13692: END IF ;
13693:
13694: EXCEPTION
13695: WHEN FND_API.G_EXC_ERROR THEN
13696: ROLLBACK TO AbortWorkflow_Util ;
13697: x_return_status := FND_API.G_RET_STS_ERROR ;
13698:
13699: FND_MSG_PUB.Count_And_Get

Line 13697: x_return_status := FND_API.G_RET_STS_ERROR ;

13693:
13694: EXCEPTION
13695: WHEN FND_API.G_EXC_ERROR THEN
13696: ROLLBACK TO AbortWorkflow_Util ;
13697: x_return_status := FND_API.G_RET_STS_ERROR ;
13698:
13699: FND_MSG_PUB.Count_And_Get
13700: ( p_count => x_msg_count
13701: , p_data => x_msg_data

Line 13720: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

13716: -- x_msg_data OUT VARCHAR2
13717: --
13718: PROCEDURE GrantObjectRoles
13719: ( p_api_version IN NUMBER
13720: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13721: , p_commit IN VARCHAR2 := FND_API.G_FALSE
13722: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13723: , p_debug IN VARCHAR2 := FND_API.G_FALSE
13724: , p_output_dir IN VARCHAR2 := NULL

Line 13721: , p_commit IN VARCHAR2 := FND_API.G_FALSE

13717: --
13718: PROCEDURE GrantObjectRoles
13719: ( p_api_version IN NUMBER
13720: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13721: , p_commit IN VARCHAR2 := FND_API.G_FALSE
13722: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13723: , p_debug IN VARCHAR2 := FND_API.G_FALSE
13724: , p_output_dir IN VARCHAR2 := NULL
13725: , p_debug_filename IN VARCHAR2 := NULL

Line 13722: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

13718: PROCEDURE GrantObjectRoles
13719: ( p_api_version IN NUMBER
13720: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13721: , p_commit IN VARCHAR2 := FND_API.G_FALSE
13722: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13723: , p_debug IN VARCHAR2 := FND_API.G_FALSE
13724: , p_output_dir IN VARCHAR2 := NULL
13725: , p_debug_filename IN VARCHAR2 := NULL
13726: , x_return_status OUT NOCOPY VARCHAR2

Line 13723: , p_debug IN VARCHAR2 := FND_API.G_FALSE

13719: ( p_api_version IN NUMBER
13720: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13721: , p_commit IN VARCHAR2 := FND_API.G_FALSE
13722: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13723: , p_debug IN VARCHAR2 := FND_API.G_FALSE
13724: , p_output_dir IN VARCHAR2 := NULL
13725: , p_debug_filename IN VARCHAR2 := NULL
13726: , x_return_status OUT NOCOPY VARCHAR2
13727: , x_msg_count OUT NOCOPY NUMBER

Line 13872: IF NOT FND_API.Compatible_API_Call( l_api_version

13868: -- Standard Start of API savepoint
13869: SAVEPOINT GrantObjectRoles;
13870:
13871: -- Standard call to check for call compatibility.
13872: IF NOT FND_API.Compatible_API_Call( l_api_version
13873: , p_api_version
13874: , l_api_name
13875: , G_PKG_NAME )
13876: THEN

Line 13877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

13873: , p_api_version
13874: , l_api_name
13875: , G_PKG_NAME )
13876: THEN
13877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13878: END IF;
13879:
13880: -- Initialize message list if p_init_msg_list is set to TRUE.
13881: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 13881: IF FND_API.to_Boolean( p_init_msg_list ) THEN

13877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13878: END IF;
13879:
13880: -- Initialize message list if p_init_msg_list is set to TRUE.
13881: IF FND_API.to_Boolean( p_init_msg_list ) THEN
13882: FND_MSG_PUB.initialize;
13883: END IF ;
13884:
13885:

Line 13887: IF FND_API.to_Boolean( p_debug ) THEN

13883: END IF ;
13884:
13885:
13886: -- For Test/Debug
13887: IF FND_API.to_Boolean( p_debug ) THEN
13888: Open_Debug_Session(p_output_dir, p_debug_filename ) ;
13889: END IF ;
13890:
13891:

Line 13906: x_return_status := FND_API.G_RET_STS_SUCCESS;

13902: Write_Debug('Initialize return status ' );
13903: END IF ;
13904:
13905: -- Initialize API return status to success
13906: x_return_status := FND_API.G_RET_STS_SUCCESS;
13907: l_return_status := FND_API.G_RET_STS_SUCCESS;
13908:
13909: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
13910: l_obj_idx := 0 ;

Line 13907: l_return_status := FND_API.G_RET_STS_SUCCESS;

13903: END IF ;
13904:
13905: -- Initialize API return status to success
13906: x_return_status := FND_API.G_RET_STS_SUCCESS;
13907: l_return_status := FND_API.G_RET_STS_SUCCESS;
13908:
13909: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
13910: l_obj_idx := 0 ;
13911:

Line 14140: , p_init_msg_list => FND_API.G_FALSE --

14136:
14137:
14138: ENG_DOCUMENT_UTIL.Grant_Document_Role
14139: ( p_api_version => 1.0
14140: , p_init_msg_list => FND_API.G_FALSE --
14141: , p_commit => FND_API.G_FALSE --
14142: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14143: , p_debug => p_debug
14144: , p_output_dir => p_output_dir

Line 14141: , p_commit => FND_API.G_FALSE --

14137:
14138: ENG_DOCUMENT_UTIL.Grant_Document_Role
14139: ( p_api_version => 1.0
14140: , p_init_msg_list => FND_API.G_FALSE --
14141: , p_commit => FND_API.G_FALSE --
14142: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14143: , p_debug => p_debug
14144: , p_output_dir => p_output_dir
14145: , p_debug_filename => p_debug_filename

Line 14142: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

14138: ENG_DOCUMENT_UTIL.Grant_Document_Role
14139: ( p_api_version => 1.0
14140: , p_init_msg_list => FND_API.G_FALSE --
14141: , p_commit => FND_API.G_FALSE --
14142: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14143: , p_debug => p_debug
14144: , p_output_dir => p_output_dir
14145: , p_debug_filename => p_debug_filename
14146: , x_return_status => l_return_status

Line 14164: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14160: Write_Debug('After calling ENG_DOCUMENT_UTIL.Grant_Document_Role: ' || l_return_status );
14161: END IF ;
14162:
14163: --
14164: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14165: -- THEN
14166: -- RAISE FND_API.G_EXC_ERROR ;
14167: -- END IF ;
14168: --

Line 14166: -- RAISE FND_API.G_EXC_ERROR ;

14162:
14163: --
14164: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14165: -- THEN
14166: -- RAISE FND_API.G_EXC_ERROR ;
14167: -- END IF ;
14168: --
14169:
14170: END IF ;

Line 14206: , p_init_msg_list => FND_API.G_FALSE --

14202: end if;
14203:
14204: ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole
14205: ( p_api_version => 1.0
14206: , p_init_msg_list => FND_API.G_FALSE --
14207: , p_commit => FND_API.G_FALSE --
14208: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14209: , p_debug => p_debug
14210: , p_output_dir => p_output_dir

Line 14207: , p_commit => FND_API.G_FALSE --

14203:
14204: ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole
14205: ( p_api_version => 1.0
14206: , p_init_msg_list => FND_API.G_FALSE --
14207: , p_commit => FND_API.G_FALSE --
14208: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14209: , p_debug => p_debug
14210: , p_output_dir => p_output_dir
14211: , p_debug_filename => p_debug_filename

Line 14208: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

14204: ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole
14205: ( p_api_version => 1.0
14206: , p_init_msg_list => FND_API.G_FALSE --
14207: , p_commit => FND_API.G_FALSE --
14208: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14209: , p_debug => p_debug
14210: , p_output_dir => p_output_dir
14211: , p_debug_filename => p_debug_filename
14212: , x_return_status => l_return_status

Line 14237: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14233: Write_Debug('After ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole: ' || l_return_status );
14234: END IF ;
14235:
14236: --
14237: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14238: -- THEN
14239: -- RAISE FND_API.G_EXC_ERROR ;
14240: -- END IF ;
14241: --

Line 14239: -- RAISE FND_API.G_EXC_ERROR ;

14235:
14236: --
14237: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14238: -- THEN
14239: -- RAISE FND_API.G_EXC_ERROR ;
14240: -- END IF ;
14241: --
14242:
14243:

Line 14254: IF FND_API.To_Boolean( p_commit ) THEN

14250: END IF ;
14251:
14252:
14253: -- Standard check of p_commit.
14254: IF FND_API.To_Boolean( p_commit ) THEN
14255:
14256: IF g_debug_flag THEN
14257: Write_Debug('Do Commit.') ;
14258: END IF ;

Line 14277: WHEN FND_API.G_EXC_ERROR THEN

14273: END IF ;
14274:
14275:
14276: EXCEPTION
14277: WHEN FND_API.G_EXC_ERROR THEN
14278:
14279: -- Standard check of p_commit.
14280: IF FND_API.To_Boolean( p_commit )
14281: THEN

Line 14280: IF FND_API.To_Boolean( p_commit )

14276: EXCEPTION
14277: WHEN FND_API.G_EXC_ERROR THEN
14278:
14279: -- Standard check of p_commit.
14280: IF FND_API.To_Boolean( p_commit )
14281: THEN
14282: ROLLBACK TO GrantObjectRoles ;
14283: END IF ;
14284: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 14284: x_return_status := FND_API.G_RET_STS_ERROR ;

14280: IF FND_API.To_Boolean( p_commit )
14281: THEN
14282: ROLLBACK TO GrantObjectRoles ;
14283: END IF ;
14284: x_return_status := FND_API.G_RET_STS_ERROR ;
14285:
14286: FND_MSG_PUB.Count_And_Get
14287: ( p_count => x_msg_count
14288: , p_data => x_msg_data

Line 14296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

14292: Write_Debug('Finish with Error.') ;
14293: Close_Debug_Session ;
14294: END IF ;
14295:
14296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14297: -- Standard check of p_commit.
14298: IF FND_API.To_Boolean( p_commit )
14299: THEN
14300: ROLLBACK TO GrantObjectRoles ;

Line 14298: IF FND_API.To_Boolean( p_commit )

14294: END IF ;
14295:
14296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14297: -- Standard check of p_commit.
14298: IF FND_API.To_Boolean( p_commit )
14299: THEN
14300: ROLLBACK TO GrantObjectRoles ;
14301: IF g_debug_flag THEN
14302: Write_Debug('Rollback. . . ' );

Line 14307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

14303: END IF ;
14304:
14305: END IF ;
14306:
14307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14308:
14309: FND_MSG_PUB.Count_And_Get
14310: ( p_count => x_msg_count
14311: , p_data => x_msg_data

Line 14321: IF FND_API.To_Boolean( p_commit )

14317: END IF ;
14318:
14319: WHEN OTHERS THEN
14320: -- Standard check of p_commit.
14321: IF FND_API.To_Boolean( p_commit )
14322: THEN
14323: ROLLBACK TO GrantObjectRoles ;
14324:
14325: IF g_debug_flag THEN

Line 14330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

14326: Write_Debug('Rollback. . . ' );
14327: END IF ;
14328:
14329: END IF ;
14330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14331:
14332: FND_MSG_PUB.Count_And_Get
14333: ( p_count => x_msg_count
14334: , p_data => x_msg_data

Line 14381: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

14377: -- p_revoke_option default G_REVOKE_LINE
14378: --
14379: PROCEDURE RevokeObjectRoles
14380: ( p_api_version IN NUMBER --
14381: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14382: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14383: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14384: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14385: , p_output_dir IN VARCHAR2 := NULL

Line 14382: , p_commit IN VARCHAR2 := FND_API.G_FALSE --

14378: --
14379: PROCEDURE RevokeObjectRoles
14380: ( p_api_version IN NUMBER --
14381: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14382: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14383: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14384: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14385: , p_output_dir IN VARCHAR2 := NULL
14386: , p_debug_filename IN VARCHAR2 := NULL

Line 14383: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

14379: PROCEDURE RevokeObjectRoles
14380: ( p_api_version IN NUMBER --
14381: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14382: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14383: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14384: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14385: , p_output_dir IN VARCHAR2 := NULL
14386: , p_debug_filename IN VARCHAR2 := NULL
14387: , x_return_status OUT NOCOPY VARCHAR2 --

Line 14384: , p_debug IN VARCHAR2 := FND_API.G_FALSE --

14380: ( p_api_version IN NUMBER --
14381: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14382: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14383: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14384: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14385: , p_output_dir IN VARCHAR2 := NULL
14386: , p_debug_filename IN VARCHAR2 := NULL
14387: , x_return_status OUT NOCOPY VARCHAR2 --
14388: , x_msg_count OUT NOCOPY NUMBER --

Line 14473: , p_init_msg_list => FND_API.G_FALSE

14469: END IF ;
14470: BEGIN
14471: RevokeObjectRoles
14472: ( p_api_version => p_api_version
14473: , p_init_msg_list => FND_API.G_FALSE
14474: , p_commit => p_commit
14475: , p_validation_level => p_validation_level
14476: , p_debug => p_debug
14477: , p_output_dir => p_output_dir

Line 14499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14495: WHEN OTHERS THEN
14496: NULL ;
14497: END ;
14498:
14499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14500: THEN
14501: x_return_status := l_return_status ;
14502: x_msg_count := l_msg_count ;
14503: x_msg_data := l_msg_data ;

Line 14523: , p_init_msg_list => FND_API.G_FALSE

14519: END IF ;
14520: BEGIN
14521: RevokeObjectRoles
14522: ( p_api_version => p_api_version
14523: , p_init_msg_list => FND_API.G_FALSE
14524: , p_commit => p_commit
14525: , p_validation_level => p_validation_level
14526: , p_debug => p_debug
14527: , p_output_dir => p_output_dir

Line 14549: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14545: WHEN OTHERS THEN
14546: NULL ;
14547: END ;
14548:
14549: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14550: THEN
14551: x_return_status := l_return_status ;
14552: x_msg_count := l_msg_count ;
14553: x_msg_data := l_msg_data ;

Line 14577: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

14573: -- x_msg_data OUT VARCHAR2
14574: --
14575: PROCEDURE RevokeObjectRoles
14576: ( p_api_version IN NUMBER --
14577: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14578: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14579: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14580: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14581: , p_output_dir IN VARCHAR2 := NULL

Line 14578: , p_commit IN VARCHAR2 := FND_API.G_FALSE --

14574: --
14575: PROCEDURE RevokeObjectRoles
14576: ( p_api_version IN NUMBER --
14577: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14578: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14579: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14580: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14581: , p_output_dir IN VARCHAR2 := NULL
14582: , p_debug_filename IN VARCHAR2 := NULL

Line 14579: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

14575: PROCEDURE RevokeObjectRoles
14576: ( p_api_version IN NUMBER --
14577: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14578: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14579: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14580: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14581: , p_output_dir IN VARCHAR2 := NULL
14582: , p_debug_filename IN VARCHAR2 := NULL
14583: , x_return_status OUT NOCOPY VARCHAR2 --

Line 14580: , p_debug IN VARCHAR2 := FND_API.G_FALSE --

14576: ( p_api_version IN NUMBER --
14577: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14578: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14579: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14580: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14581: , p_output_dir IN VARCHAR2 := NULL
14582: , p_debug_filename IN VARCHAR2 := NULL
14583: , x_return_status OUT NOCOPY VARCHAR2 --
14584: , x_msg_count OUT NOCOPY NUMBER --

Line 14626: , p_init_msg_list => FND_API.G_FALSE

14622: END IF ;
14623: BEGIN
14624: RevokeObjectRoles
14625: ( p_api_version => p_api_version
14626: , p_init_msg_list => FND_API.G_FALSE
14627: , p_commit => p_commit
14628: , p_validation_level => p_validation_level
14629: , p_debug => p_debug
14630: , p_output_dir => p_output_dir

Line 14653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14649: WHEN OTHERS THEN
14650: NULL ;
14651: END ;
14652:
14653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14654: THEN
14655: x_return_status := l_return_status ;
14656: x_msg_count := l_msg_count ;
14657: x_msg_data := l_msg_data ;

Line 14679: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

14675: -- x_msg_data OUT VARCHAR2
14676: --
14677: PROCEDURE RevokeObjectRoles
14678: ( p_api_version IN NUMBER --
14679: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14680: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14681: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14682: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14683: , p_output_dir IN VARCHAR2 := NULL

Line 14680: , p_commit IN VARCHAR2 := FND_API.G_FALSE --

14676: --
14677: PROCEDURE RevokeObjectRoles
14678: ( p_api_version IN NUMBER --
14679: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14680: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14681: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14682: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14683: , p_output_dir IN VARCHAR2 := NULL
14684: , p_debug_filename IN VARCHAR2 := NULL

Line 14681: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

14677: PROCEDURE RevokeObjectRoles
14678: ( p_api_version IN NUMBER --
14679: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14680: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14681: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14682: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14683: , p_output_dir IN VARCHAR2 := NULL
14684: , p_debug_filename IN VARCHAR2 := NULL
14685: , x_return_status OUT NOCOPY VARCHAR2 --

Line 14682: , p_debug IN VARCHAR2 := FND_API.G_FALSE --

14678: ( p_api_version IN NUMBER --
14679: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14680: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14681: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14682: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14683: , p_output_dir IN VARCHAR2 := NULL
14684: , p_debug_filename IN VARCHAR2 := NULL
14685: , x_return_status OUT NOCOPY VARCHAR2 --
14686: , x_msg_count OUT NOCOPY NUMBER --

Line 14829: IF NOT FND_API.Compatible_API_Call( l_api_version

14825: -- Standard Start of API savepoint
14826: SAVEPOINT RevokeObjectRoles;
14827:
14828: -- Standard call to check for call compatibility.
14829: IF NOT FND_API.Compatible_API_Call( l_api_version
14830: , p_api_version
14831: , l_api_name
14832: , G_PKG_NAME )
14833: THEN

Line 14834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

14830: , p_api_version
14831: , l_api_name
14832: , G_PKG_NAME )
14833: THEN
14834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14835: END IF;
14836:
14837: -- Initialize message list if p_init_msg_list is set to TRUE.
14838: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 14838: IF FND_API.to_Boolean( p_init_msg_list ) THEN

14834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14835: END IF;
14836:
14837: -- Initialize message list if p_init_msg_list is set to TRUE.
14838: IF FND_API.to_Boolean( p_init_msg_list ) THEN
14839: FND_MSG_PUB.initialize;
14840: END IF ;
14841:
14842:

Line 14844: IF FND_API.to_Boolean( p_debug ) THEN

14840: END IF ;
14841:
14842:
14843: -- For Test/Debug
14844: IF FND_API.to_Boolean( p_debug ) THEN
14845: Open_Debug_Session(p_output_dir, p_debug_filename ) ;
14846: END IF ;
14847:
14848:

Line 14863: x_return_status := FND_API.G_RET_STS_SUCCESS;

14859: Write_Debug('Initialize return status ' );
14860: END IF ;
14861:
14862: -- Initialize API return status to success
14863: x_return_status := FND_API.G_RET_STS_SUCCESS;
14864: l_return_status := FND_API.G_RET_STS_SUCCESS;
14865:
14866: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
14867: l_obj_idx := 0 ;

Line 14864: l_return_status := FND_API.G_RET_STS_SUCCESS;

14860: END IF ;
14861:
14862: -- Initialize API return status to success
14863: x_return_status := FND_API.G_RET_STS_SUCCESS;
14864: l_return_status := FND_API.G_RET_STS_SUCCESS;
14865:
14866: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
14867: l_obj_idx := 0 ;
14868:

Line 15086: , p_init_msg_list => FND_API.G_FALSE --

15082: END IF ;
15083:
15084: ENG_DOCUMENT_UTIL.Revoke_Document_Role
15085: ( p_api_version => 1.0
15086: , p_init_msg_list => FND_API.G_FALSE --
15087: , p_commit => FND_API.G_FALSE --
15088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
15089: , p_debug => p_debug
15090: , p_output_dir => p_output_dir

Line 15087: , p_commit => FND_API.G_FALSE --

15083:
15084: ENG_DOCUMENT_UTIL.Revoke_Document_Role
15085: ( p_api_version => 1.0
15086: , p_init_msg_list => FND_API.G_FALSE --
15087: , p_commit => FND_API.G_FALSE --
15088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
15089: , p_debug => p_debug
15090: , p_output_dir => p_output_dir
15091: , p_debug_filename => p_debug_filename

Line 15088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

15084: ENG_DOCUMENT_UTIL.Revoke_Document_Role
15085: ( p_api_version => 1.0
15086: , p_init_msg_list => FND_API.G_FALSE --
15087: , p_commit => FND_API.G_FALSE --
15088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
15089: , p_debug => p_debug
15090: , p_output_dir => p_output_dir
15091: , p_debug_filename => p_debug_filename
15092: , x_return_status => l_return_status

Line 15111: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

15107: Write_Debug('After ENG_DOCUMENT_UTIL.Revoke_Document_Role: ' || l_return_status );
15108: END IF ;
15109:
15110: --
15111: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
15112: -- THEN
15113: -- RAISE FND_API.G_EXC_ERROR ;
15114: -- END IF ;
15115: --

Line 15113: -- RAISE FND_API.G_EXC_ERROR ;

15109:
15110: --
15111: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
15112: -- THEN
15113: -- RAISE FND_API.G_EXC_ERROR ;
15114: -- END IF ;
15115: --
15116:
15117: END IF ;

Line 15139: , p_init_msg_list => FND_API.G_FALSE --

15135: END IF ;
15136:
15137: ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole
15138: ( p_api_version => 1.0
15139: , p_init_msg_list => FND_API.G_FALSE --
15140: , p_commit => FND_API.G_FALSE --
15141: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
15142: , p_debug => p_debug
15143: , p_output_dir => p_output_dir

Line 15140: , p_commit => FND_API.G_FALSE --

15136:
15137: ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole
15138: ( p_api_version => 1.0
15139: , p_init_msg_list => FND_API.G_FALSE --
15140: , p_commit => FND_API.G_FALSE --
15141: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
15142: , p_debug => p_debug
15143: , p_output_dir => p_output_dir
15144: , p_debug_filename => p_debug_filename

Line 15141: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

15137: ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole
15138: ( p_api_version => 1.0
15139: , p_init_msg_list => FND_API.G_FALSE --
15140: , p_commit => FND_API.G_FALSE --
15141: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
15142: , p_debug => p_debug
15143: , p_output_dir => p_output_dir
15144: , p_debug_filename => p_debug_filename
15145: , x_return_status => l_return_status

Line 15165: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

15161: Write_Debug('After ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole: ' || l_return_status );
15162: END IF ;
15163:
15164: --
15165: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
15166: -- THEN
15167: -- RAISE FND_API.G_EXC_ERROR ;
15168: -- END IF ;
15169: --

Line 15167: -- RAISE FND_API.G_EXC_ERROR ;

15163:
15164: --
15165: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
15166: -- THEN
15167: -- RAISE FND_API.G_EXC_ERROR ;
15168: -- END IF ;
15169: --
15170:
15171:

Line 15186: IF FND_API.To_Boolean( p_commit ) THEN

15182: END IF ;
15183:
15184:
15185: -- Standard check of p_commit.
15186: IF FND_API.To_Boolean( p_commit ) THEN
15187:
15188: IF g_debug_flag THEN
15189: Write_Debug('Do Commit.') ;
15190: END IF ;

Line 15209: WHEN FND_API.G_EXC_ERROR THEN

15205: END IF ;
15206:
15207:
15208: EXCEPTION
15209: WHEN FND_API.G_EXC_ERROR THEN
15210:
15211: -- Standard check of p_commit.
15212: IF FND_API.To_Boolean( p_commit )
15213: THEN

Line 15212: IF FND_API.To_Boolean( p_commit )

15208: EXCEPTION
15209: WHEN FND_API.G_EXC_ERROR THEN
15210:
15211: -- Standard check of p_commit.
15212: IF FND_API.To_Boolean( p_commit )
15213: THEN
15214: ROLLBACK TO RevokeObjectRoles ;
15215: END IF ;
15216: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 15216: x_return_status := FND_API.G_RET_STS_ERROR ;

15212: IF FND_API.To_Boolean( p_commit )
15213: THEN
15214: ROLLBACK TO RevokeObjectRoles ;
15215: END IF ;
15216: x_return_status := FND_API.G_RET_STS_ERROR ;
15217:
15218: FND_MSG_PUB.Count_And_Get
15219: ( p_count => x_msg_count
15220: , p_data => x_msg_data

Line 15228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

15224: Write_Debug('Finish with Error.') ;
15225: Close_Debug_Session ;
15226: END IF ;
15227:
15228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15229: -- Standard check of p_commit.
15230: IF FND_API.To_Boolean( p_commit )
15231: THEN
15232: ROLLBACK TO RevokeObjectRoles ;

Line 15230: IF FND_API.To_Boolean( p_commit )

15226: END IF ;
15227:
15228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15229: -- Standard check of p_commit.
15230: IF FND_API.To_Boolean( p_commit )
15231: THEN
15232: ROLLBACK TO RevokeObjectRoles ;
15233: IF g_debug_flag THEN
15234: Write_Debug('RollBack . . ..') ;

Line 15238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

15234: Write_Debug('RollBack . . ..') ;
15235: END IF ;
15236: END IF ;
15237:
15238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15239:
15240: FND_MSG_PUB.Count_And_Get
15241: ( p_count => x_msg_count
15242: , p_data => x_msg_data

Line 15252: IF FND_API.To_Boolean( p_commit )

15248: END IF ;
15249:
15250: WHEN OTHERS THEN
15251: -- Standard check of p_commit.
15252: IF FND_API.To_Boolean( p_commit )
15253: THEN
15254: ROLLBACK TO RevokeObjectRoles ;
15255: IF g_debug_flag THEN
15256: Write_Debug('RollBack . . ..') ;

Line 15260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

15256: Write_Debug('RollBack . . ..') ;
15257: END IF ;
15258: END IF ;
15259:
15260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15261:
15262: FND_MSG_PUB.Count_And_Get
15263: ( p_count => x_msg_count
15264: , p_data => x_msg_data