192: WHERE organization_id = l_org_id;
193:
194: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
195: l_err_num := 30001;
196: fnd_message.set_name('GMF', 'GMF_PROCESS_ORG_ERROR');
197: fnd_message.set_token('ORGCODE', l_organization_code);
198: l_err_msg := FND_MESSAGE.Get;
199: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
200: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
193:
194: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
195: l_err_num := 30001;
196: fnd_message.set_name('GMF', 'GMF_PROCESS_ORG_ERROR');
197: fnd_message.set_token('ORGCODE', l_organization_code);
198: l_err_msg := FND_MESSAGE.Get;
199: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
200: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
201: fnd_file.put_line(fnd_file.log,l_err_msg);
194: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
195: l_err_num := 30001;
196: fnd_message.set_name('GMF', 'GMF_PROCESS_ORG_ERROR');
197: fnd_message.set_token('ORGCODE', l_organization_code);
198: l_err_msg := FND_MESSAGE.Get;
199: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
200: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
201: fnd_file.put_line(fnd_file.log,l_err_msg);
202: RETURN;
649: ||' '
650: || l_err_msg
651: || '. ',1,240);
652:
653: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');
654: l_err_msg := fnd_message.get;
655: l_err_msg := SUBSTR(l_err_msg,1,240);
656: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
657: ||' '
650: || l_err_msg
651: || '. ',1,240);
652:
653: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');
654: l_err_msg := fnd_message.get;
655: l_err_msg := SUBSTR(l_err_msg,1,240);
656: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
657: ||' '
658: ||l_err_msg,1,240));
669: || '): '
670: || l_err_msg
671: || '. ',1,240);
672:
673: fnd_message.set_name('BOM', 'CST_NO_AVG_ORG');
674: l_err_msg := fnd_message.get;
675: l_err_msg := SUBSTR(l_err_msg,1,240);
676: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
677: CONC_STATUS := FND_CONCURRENT.
670: || l_err_msg
671: || '. ',1,240);
672:
673: fnd_message.set_name('BOM', 'CST_NO_AVG_ORG');
674: l_err_msg := fnd_message.get;
675: l_err_msg := SUBSTR(l_err_msg,1,240);
676: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
677: CONC_STATUS := FND_CONCURRENT.
678: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1405: ||' '
1406: || l_err_msg
1407: || '. ',1,240);
1408:
1409: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');
1410: l_err_msg := fnd_message.get;
1411: l_err_msg := SUBSTR(l_err_msg,1,240);
1412: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
1413: ||' '
1406: || l_err_msg
1407: || '. ',1,240);
1408:
1409: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');
1410: l_err_msg := fnd_message.get;
1411: l_err_msg := SUBSTR(l_err_msg,1,240);
1412: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
1413: ||' '
1414: ||l_err_msg,1,240));
1493: WHERE organization_id = p_organization_id;
1494:
1495: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
1496: l_err_num := 30001;
1497: fnd_message.set_name('GMF', 'GMF_PROCESS_ORG_ERROR');
1498: fnd_message.set_token('ORGCODE', l_organization_code);
1499: l_err_msg := FND_MESSAGE.Get;
1500: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
1501: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1494:
1495: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
1496: l_err_num := 30001;
1497: fnd_message.set_name('GMF', 'GMF_PROCESS_ORG_ERROR');
1498: fnd_message.set_token('ORGCODE', l_organization_code);
1499: l_err_msg := FND_MESSAGE.Get;
1500: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
1501: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1502: fnd_file.put_line(fnd_file.log,l_err_msg);
1495: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
1496: l_err_num := 30001;
1497: fnd_message.set_name('GMF', 'GMF_PROCESS_ORG_ERROR');
1498: fnd_message.set_token('ORGCODE', l_organization_code);
1499: l_err_msg := FND_MESSAGE.Get;
1500: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
1501: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1502: fnd_file.put_line(fnd_file.log,l_err_msg);
1503: RETURN;